cancel
Showing results for 
Search instead for 
Did you mean: 

Group Tree selection causes database prompt

Former Member
0 Kudos

SAP Crystal Reports, version for Microsoft Visual Studio v 13.0.14.1720

Microsoft Visual Studio 2013

I am writing a ASP.NET application to display CR2013 reports. These reports could run on any of our client databases (all of which have the same schema). There is a separate DSN for each client.

So, when I set the ConnectionInfo based on the client's DSN.

I can get the report to render just fine, but when I select something from the Group Tree, I get "Failed to open the connection."  (see attached file)

I tried to set the connection info each time Page_Init runs, but I am still missing something.

Does anyone know what I am missing?

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

Hi David,

Make sure you are using Sessions and PostBack methods to keep the report in scope.

Also, the code should be in the Page_Init section and not the Page_Load

Search here on how to use Postback and sessions if you need samples. Or click on the Overview tab and on the left there is a sample application links.

Don

Answers (1)

Answers (1)

Former Member
0 Kudos

Thanks Don!

Makes total sense.

former_member183750
Active Contributor
0 Kudos

Hi David

There is a KBA on this that may come in handy:

1985571 - How to use sessions in web applications using the Crystal Reports viewer (the complete cod...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter