Crystal Reports XIR2 - Dynamic Data Connections and Sub Reports
Posted on 2009-07-08
I am currently running Crystal Reports, and using the Business Objects XI R2 Business View Manager to allow Dynamic Data Connections to our reports (prompting the user for Dev, Test, Prod).
This has all been working fine and dandy, but I have come across my first report which requires Sub Reports and I'm not sure how to get this correct.
Here are the steps I take:
1) Create a "Table" (I actually create a new Command and put the SQL statement and parameters in there) in my Business Foundation. I have one table for each report.
2) Create Business Element for new report.
3) Add Business Element to the Business View
4) Point report to Business View and new Element.
Now that I have a report with a sub report, I'm not sure what to do... I attempted doing the steps above for my sub report, but the report now prompts for the parameters from MAIN and the SUB, so I don't think this is a great way to do this.
Has anyone figured out a way to do this? We are very new at the whole Foundation/Element/View thing, so thanks in advance for your advice and patience. :-)