Search results for query: *

I'm using Crystal Reports XI with SQL Server 2000. I have the following scenario. If a patient has a discharge date of 03/15/2009, I only want to choose records for the patient for only the 1st service date AFTER the discharge date. For instance a patient has the following records: DISCHARGE...

By any chance do you have an example of an array variable. I've never had to work with one of those? Or could you direct me so a website that would be able to explain how this would be accomplished.

Ok. So I should move the subreport into the report footer? And if so, how would I pass the page numbers from the main report with details to the subreport with the timezone groupings?

The subrport is located in the report header and is linked to the main report by an office parameter name which are ENDICOTT and MARIETTA.

Hello All. I have a report that contains 1 subreport. The main report is grouped by timezone with all details showing. The timezone group footer contains information for the specific time zone such as: number of customers, number of accounts, amount owed, and amount collected. The subreport...

Wow!! Thanks Mocgp. It worked perfectly!!!

the data in the table is stored as a date in the mm/dd/yyyy format. I only need to group by the month and year. The day of the month is not important because of the grouping. For instance, if I had payments on 08/01/2006, 08/02/2006, 08/09/2006, 09/03/2006, 09/13/2006; the groups I would...

Good morning, I’m trying to create a cross tab report that will have a column heading related to a date field in database. The rows of the crosstab will be a grouping of agency names. For each agency name, for each month/year combination, there is a paid value. My problem is I do not know...

Good Afternoon, I'm trying to create a selection formula that will select records for the previous week. However, the week should start on a Friday and end on a Thursday. In addition, there is a small twist. The records dated the last 2 days of a month should be included in the next months...

Thanks Ibass, it worked perfectly!!!! You're my HERO!!!

If possible, can someone refer me to a formula that will help me retrieve the time from the corrsponding maximum app values for this problem. I have everything else in the report except for the times. I know that individual formulas need to be written for each AppTime, in order to retreive the...

Synapsevampire, thanks for the assistance. I've generated an example of the output that I'm looking for. The output should be as follows: Server App1Max App2Max App1Date App1Time App2Date App2Time Server01 43 8 8/1/2006 2:00PM 8/01/2006 3:00AM Server02 171...

Please bear with me on an explanation of what I’m trying to accomplish. My is very strict on the number of licenses being using for a particular application. Therefore they need reports with call statistics. This particular report is supposed to determine the maximum number of licenses used...

Ok, I tried this, and it is not calculating properly, here is the actual formula The CurrentFormula is Maximum ({Cateory1}, {Server}) Then I created another formula called Cat1Total which consists of the following: numbervar MyCat1Total := numbervar MyCat1Total+ {@CurrentFormula} Then I...

you are correct, I typed in the wrong total. As far as building the report, it is NOT a crosstab. I just grouped by the server name and created 3 formulas for each category. Each formula contained a formula that calculated returned the maximum value for the corresponding server group and...

I’m trying to create a portion of a report that will be grouped by the name of a server. (There is no set amount of servers. It can increase decrease depending on a date range in a selection statement). Each server has 3 categories for a summation. The summary I’m utilizing is the MAX...

Local Numbervar Ras; Local Numbervar ras1; If {TABLE1.field1} = "E" then Ras := Count({TABLE1.field1}) else If {Table1.field1} = "C" then ras1 := Count({Table1.field1}) How can I display both RAS and RAS 1 from the same formula in Crystal 11?

Well, I'm working on a report that will show the total number for days in a month. For instance, the month of June has 30 days. The department who needs the reports needs to see the number of days remaining in a particular month in one column and the actual date in the next column. Therefore...

Excuse me for not printing enough information. I'm using Crystal 10

I’m trying to write a formula that will count the number of records in a file in descending order. For instance if there are 10 records, I will have a field that looks like the following 10 9 8 7 6 5 4 3 2 1 Any ideas?