Skip to Content

Drill down is not working as expected in Crystal report.


We have a Crystal Report that contains Dynamic Grouping option. so based on the Grouping parameter value report will group the data.
We have applied dynamic suppression formula in the Section expert > Suppress and also checked Hide option.It is working fine in designer.

When we deploy report in BOBI server for the frist couple of times it is working fine(Drill down is working as expected).
after some time when we change the Grouping paramter value and want to get the info for USA >2014(Drill down on USA)but it is shwoing Japan >2014 group.
After some time it is throwing "Invalid Group Number" Error message.
and some times it is prompting database logon window for enter Credentials.

We are using Crystal report 2011 SP4 and BOBI 4.0 SP4
We have saved Report Without data.

Please suggest me any solution and let me know if you required more information.

--Praveen G

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Sep 24, 2014 at 02:58 PM

    Could anyone suggest me on this..

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Mahesh,

      I have posted this thread in Crystal Reports section, they have moved this to BI Platform as there is no issue with the report design.

      Report is working as expected in crystal report Designer. it is showing first Group name instead of the group that we drill down.

      Please let me know if we need to do any changes in BI Launchpad/Servers.

      --Praveen G

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.