Search results for query: *

Thanks Brian. Yes that's what I need. Question - When the 49 reports all run at the same time, will it be a problem if all of the reports access the same file (on an AS400) at the same time?

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...

Thanks so much CoSpringsGuy - this is exactly what I needed. Heather

Thanks! Now, can anyone tell me what the major differences are between the 2 versions? I'm trying to decide if it's worth upgrading.

Which is the latest version of Crystal Reports - XI (11) or 2008?

Thank you so much LB - that worked great! I can't believe how short that formula is, that does this complex formula.

LB, I've tried the formula you gave, but it says 'the remaining text does not appear to be part of the formula' and it hightlights the part after the -1 in the 2nd line. I've played around with the parentheses but cannot get the formula to be error-free. Can you check it again please?

This is a different thing entirely. This field is not a date. It holds our period numbers. The other field that I asked about in my other post was an actual date. For example, the data for our period number is 11002. The first 1 is a century number which I don't need, the '10' stands for...

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...

Thanks lbass, that worked great. Now I have another question, but I will start a new thread for that.

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...

What we did to fix our problem was did a search in the Registry for our old server name, and found an entry that was the job server's default destination path. We changed it to the new server name and it worked. I noticed before we did this that even though I changed the name in the Report...

Tried that, and tried it just now again, but that did not work. Got the same error message as before.

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...