Drill down is not working as expected in Crystal report.

[former_member203168]

Hi,

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

[former_member203168]

Could anyone suggest me on this..

[Former Member]

Hello Praveen,

Please post your query in Crystal Reports section for faster response.

- Mahesh

[former_member203168]

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