Hey guys,
I had a bit of a hiccup with Crystal Reports X, was hoping someone in here had an answer to. Tried looking for my case online but wasn't able to come up with anything. If this has already been posted can you please direct me to the link? Thanks!
- I have one main report (Report1) and two sub reports (Report2 & Report3).
- The reports are supposed to filter out information based on certain criteria.
- They all pick information from the same table but through three different stored procedures at the moment (each has different recordset values based on different conditions).
- The backend is sql server 2000 thought this could be any data source and I think irrelevant.
- All three reports have completely different design structures, but the user does not want to print them as separate jobs but as a single document.
- At the moment I am not looking at calling it from any specific front-end / programming language, just going into Crystal Reports X and clicking on Preview.
- User required information (parameter definition) will be the same for all three reports viz
- Zone name (West, East, etc)
- Week for which report will be previewed (From and To Date)
- What changes is a parameter "Bank Name" which is not user prompted but rather to be harcoded for each report.
My questions are as follows:
#1. Is it possible for me to define the above user prompted parameters in the main report and somehow have these values picked up by the child subreports?
At the moment if I define them in all three, while previewing the report, the prompt for information appears thrice for each parameter.
#2. If I define header information in the main report, these headers also replicate when the subreports are viewed. Does this mean that I should infact have four reports, the parent headers being blank, and the three child reports will then have their individual headers? Can I disable parent headers the moment the subreports start to print such that the child headers will go into effect?
#3. Is it possible for me to pass a default hardcoded parameter value with the report?
Example: besides the two standard user prompted parameters for all three reports, each report passes a distinct "Bank Name" value based on which each report displays its different information (defined in the report design structure). Since I know what each report is supposed to display, say Report1 = Bank Name A, Report2 = Bank Name B, Report3 =
Bank Name C, I would like to hardcode the parameter to go out with the report query rather than have the user enter this. In this case I could have just a single stored procedure instead of multiple stored procedures extracting different recordset values based on different default report parameter set above.
If any more clarifications are required let me know.
Appreciate any help you can give me.
IP Logged
