I have about 50 reports in Crystal Reports Server (11.5) that I have individually scheduled to run, on the 1st day of the month. I'd like to put these in a group somehow where when 1 finishes running, the next one will start. I'm thinking it has something to do with an Event, but not sure how...
I have a database with a UTC date. I have converted it to GMT format (i.e. 4/12/2010 5:30:18PM). I'm using the following ShiftDate formula to convert the GMT to Eastern time.
ShiftDateTime ({@dateutc}, "UTC,000,UTC", "EST,300,EDT")
It works but it's not taking into account Daylight Saving...
I have a field that is numeric that holds our fiscal year and period, but I want to convert it a month in it's word format, and skip the date, and display the year.
Data example: 10901 is the period number for July 2008. We run our fiscal year from July to June. Today, for example, is August...
I think I need to use an array for this, but I really am clueless on how to start it.
I have a field called date, but it actually looks like this (just an example): 1090812. I want to display as August 12, 2009 on the report. How do I setup a formula to look at the 2nd and 3rd position for the...
I need to be able to do a selection based on a comparison of the salesman number that re in 2 separate records, where the saleman number doesn't match.
Currently I have the data grouped by customer number. And I'm selecting on Type (1 and 7). If the salesman number for these two records do...
Hi, I'm in a mess... need your help please.
Our CMC was setup with many reports being run on a schedule, and the PDF files were automatically saved to a network drive/folder. In each report, the destination was set to "unmanaged disk" and the 'save to job server defaults'. Everything was...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.