Search results for query: *

The subreport is a report that lists all positions in a hospital by department. The subreport has 2 fields available and authorized fte. These two are divided to get a percentage and that percentage is then pulled into the main report. There are 40 different queries that will give us a...

I am currently using Crystal 10 to access data off a sql server. The main report is a quaterly summary report based of HR staatistics and will need statistics from a Second report that has unrelated data. This 2nd report is queried 40 different ways to get 40 different statistics off a...

It works!! Thanks a million.

The Min for Lpadt1 is 0 and the Max is 12 Month The Min for Lpadt2 is 0 and the Max is 31 Day The Min for Lpadt3 is 0 and the Max is 99 Year

Also, if I rearrange the formula, like this: date({BADPLPP.LPADT1},{BADPLPP.LPADT2},2000+{BADPLPP.LPADT3}) = currentdate-1 I get the error that the year must be between 1 and 9999.

When I use this new formula, I get the error: The Month number must be between 1 and 12. What can I do?

In the select expert, I have these 3 parameter fields and they are all formatted as numbers. {lpadt1} = {?month} {lpadt2} = {?day} {lpadt3} = {?year} Yes, if the year was 89, the formula would read it as 2089, but since those records are not relevant, I can omit those. Instead of having all of...

lpadt1 lpadt2 lpadt3 1 10 1 2 12 2 3 13 3 4 14 89 5 15 92 6 16 3 7 17 7 8 20 8 9 25 99 10 31 98 They...

I still get the exact same error.

I'm running a report on Crystal 10 that lists all accounts on a daily basis. The admit date is based on 3 fields, Date1,Date2 and Date3, which represents the month/day/year. I currently have 3 different parameters; month, day, year, that is prompted to the user each time the report is run...