I am using crystal reports 2008 in PeopleSoft with a SQL Server backend. I have a Master report with an underlying query which filters on parameters passed to Crystal Report (EMPLID and Calendar Year these are the underlying tables' Primary Keys). The master report has sub reports all linked to the the master's EMPLID and Calendar Year fields. At this point everything works I enter the emplid and year at the prompt and the report runs filtering on those fields.
Each year, the report will change. I set up the subreports so that when I enter 2014 in the prompt, the 2014 version of sub report A will display. If I enter 2015, the 2015 version displays.
When I add these parallel subreports, I get prompted twice. I have checked all of the sub report links. I have made sure that each link selects data in the subreport based on the master field, not the subreport parameter field. I have tried this with conditional subreports and conditional sections and get double prompts. I am stumped. Any ideas of how to use conditional subreports in this way without being prompted more than once?
If this works I intend to add sub report versions for each year. If anyone can think of a better approach feel free to let me know. Thanks.
