date/time parameter with multiple discrete values

[lshea]

I apologize in advance if this issue has been addressed previously. I searched through the FAQ's and past post and couldn't find anything that seemed to help.

I am using CR9, connecting to a Microsoft Access DB. The table I am using to build on has a field 'PayPeriod' that is a discrete date/time value using the first date of the pay period.

I built a parameter ?PayPeriodDate allowing the selection of multiple discrete values. This works fine. However, when I try to pass this through to the subreport using '{?Pm-Tbl_Weekly_Data_Final_Table.PAYPERIOD}', I only get the last value selected.

For example, if I select 1/7/07 and 1/21/07, the main report will provide data for both pay periods, but the subreport will only provide summary data for the 1/21/07 pay period.

Ideas? Suggestions?

 

[dgillz]

Where is your subreport placed?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[lbass]

It sounds like you have the sub in the report footer. Try moving it to a group section where the group is based on the pay period.

-LB

 

[lshea]

I had originally placed the subreport in Group Footer 2, which was grouping on the Employee Number.

I moved the subreport to Group Footer 3, which is grouping on Pay Period, and I am now getting a summary line per pay period as expected. However, I am trying to instead have a summary line for each Pay Period at the end, so that its more like this:

detail 1
detail 1
subtotal 1

detail 2
detail 2
subtotal 2

summary 1
summary 2

is this possible?

 

[lbass]

The simplest solution would be to add a second subreport to be placed in the employee footer that is linked only on employee. The sub would be grouped by payperiod, with summaries in each group footer, and with the details suppressed.

I'm not sure why you're using subreports. You could try inserting a crosstab into the employee group footer instead, if you are referencing the table containing the payperiods in the main report.

-LB