How Use Drill down Concept in Crystal Report
Happy New Year 2014 ......
I want to know how to use drill down option in Crystal report . In below i have explained my screnario
For example :
In crystal report I have a Group Header ie, Purchase order Numer . Each purchase order have 5 line items. If i drill down ( ) on each Order No it should display line details in crystal report,and also it will be in Same page - Not seperate Tab or Seperate Window
Jamie Wiseman replied
unfortunately there is no way to do this directly in crystal reports...you'd either need the viewer that Ido suggested above (but you said no 3rd party tools) or businessobjects enterprise / cr server.
i am not familiar with sap b1, but as one last option in crystal reports you can Insert an OLAP Grid. one of the cube connectors is sap business information warehouse...not sure if that cube type is available in sap b1. other type is ms ole db for analysis services.