Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports - custom function help...

Status
Not open for further replies.

circlesam2000

IS-IT--Management
Jan 19, 2006
1
US
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 don't think that Crystal can handle this without using some front end coding.

Functions don't perform drop downs, only parameters do this.

And this does souund like on the fly slicing and dicing, which Crystal doesn't do.

Sounds more like a Hyperion task to me.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top