Mosquitoe
asked on
Dynamically allowing user to view report, select group from tree and display report
Crystal report within visual studio, programmically connecting to database and opening report. Lets say it is a generic report showing all vehicle manufactureres and the detail section shows all the different models. If the user selects a specific manufacturer from the tree on the left, is there any way to keep the tree with all the manufacturer choices, but show only the details for that selection. Right now, if I select a manufacturer, it will move within the report to where those records are, but the rest of the information remains evident. Will crystal allow that to be manipulated? I thought of sub reports, or hiding or suppressing but hope someone would have some clear concise direction to give me. Is this just an issue of how I format vs, being able to programmically set how the info displays?
ASKER
I had thought of that - What I am really wondering is if I am correct that within Crystal, once you have a report set up to display all the records, there is no way to keep just the groups in the tree and disply only their records in the main display. A user would HAVE to doubleclick on the sub-report to open it separately - I'm correct right?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Forced accept.
Computer101
EE Admin
Computer101
EE Admin
You could prompt the user for the manufactirer and then display just that information in the report.
For a Crystal solution
You could put all the details for each manufacturer in an ON DEMAND subreport. Then when you choose from the group tree, the user willthen be able to click on the subreport and get it displayed separately.
mlmcc