Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Possible for MTD parameter and YTD paramater same report 1

Status
Not open for further replies.

IceRuby

Technical User
Jan 20, 2004
85
AU
Hi there

Utilising Crystal Version 10 with ODBC connection to SQL database.

I have a report that is deliminated by a user defined parameter for typically a month period. It breaks payroll information into Groups and then Codes. Next to these Codes I need to apply a year to date value. This would have to utilise the max date value enter by user for month to date values. (e.g. MTD - 1/3 - 31/3 then YTD would be 1/7 - 31/3)

I believe I will have to create the YTD values within subreport however appreciate your assistance in how this can be applied to month to date report.

Report should look like:
MTD Parameter 1/3/05 - 31/3/05
MTD YTD
GRP#1 DEDUCTIONS
GRP#2 Codes
Motor Vehicle 1000 5000
Power 50 900
Credit Card 300 7000

(YTD values would have to be representative of 1/7/04-31/3/05)

Thanking you.
 
Select your data for year-to-date. Use running totals to get month-to-date totals within the year-to-date.

Right-click on a field and choose Insert to get a choice of Running Total or Summary. Or else use the Field Explorer, the icon that is a grid-like box, to add running totals.

Running totals allow you to do clever things with grouping and formulas. They also accumulate for each line, hence the name. The disadvantage is that they are working out at the same time as the Crystal report formats the line. You cannot test for their values until after the details have been printed. You can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.

Summary totals are cruder, but are based directly on the data. This means that they can be shown in the header. They can also be used to sort groups, or to suppress them. Suppress a group if it has less than three members, say. They default to 'Grand Total', but also can be for a group.


[yinyang] Madawc Williams (East Anglia, UK) [yinyang]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top