circlesam2000
IS-IT--Management
Need help from Gurus!!
I am creating reports and the key is to have guided navigation between reports using CR XI. There is main summary report which will have 6 or 7 parameters on the left hand side of the report and list of categories on the right hand side with bunch of number fields for each category. But the key is users wants to have these prompts as drop downs on the screen (not exactly like parameters) and when they select a different value in the drop down, they want the values to changed on the right side dynamically. They don't want to refresh the report. Also when they click on the any of the category, it should open a separate report with the values for the parameters they selected on the main summary report with different fields for that category and link in that report should open up another report. This can go up to four levels. And from any level and from any category they want to come back to the main summary report. I know it may sound like a OLAPI report to you but we do not have cubes and we just have DW.
Questions: I thought initially this can be done in sub report but I have no clue how to achieve the drop-down in crystal (not the prompts). Any suggestions? Is CR a correct tool for this solution? Any one has done anything similar? Can we customize the .NET infoview in BOE XI R2 and keep the prompt values alive no matter how many levels you drill-down? How difficult to get this thing done?
How about custom functions to have the drop downs? Is that a viable option?
Any suggestions and workarounds will be greatly appreciated?
I am creating reports and the key is to have guided navigation between reports using CR XI. There is main summary report which will have 6 or 7 parameters on the left hand side of the report and list of categories on the right hand side with bunch of number fields for each category. But the key is users wants to have these prompts as drop downs on the screen (not exactly like parameters) and when they select a different value in the drop down, they want the values to changed on the right side dynamically. They don't want to refresh the report. Also when they click on the any of the category, it should open a separate report with the values for the parameters they selected on the main summary report with different fields for that category and link in that report should open up another report. This can go up to four levels. And from any level and from any category they want to come back to the main summary report. I know it may sound like a OLAPI report to you but we do not have cubes and we just have DW.
Questions: I thought initially this can be done in sub report but I have no clue how to achieve the drop-down in crystal (not the prompts). Any suggestions? Is CR a correct tool for this solution? Any one has done anything similar? Can we customize the .NET infoview in BOE XI R2 and keep the prompt values alive no matter how many levels you drill-down? How difficult to get this thing done?
How about custom functions to have the drop downs? Is that a viable option?
Any suggestions and workarounds will be greatly appreciated?