Crystal Report dialog for database login when deployed to web server

[former_member606863]

I have a crystal report designed using xml file (dataset with ado.net connection). Crystal version 14.2.5.2618 and using vs 2017... deployed to .net 4.7.2 framework website. I have a service (WCF) returning a dataset that is valid and filled. When I deploy the report to the web server the report prompts for a database login even though it is fine in development. Here is the code with names changed to protect the innocent.

<code>m_myRPT.Load(Server.MapPath("~/Reports/my.rpt"))
m_myRPT.PrintOptions.PaperOrientation=PaperOrientation.Portrait
m_myRPT.SetDataSource(m_DS.Tables("dtData"))'returned from WCF and is fine
CRV_reportviewer.ReportSource = m_MyRPT
CRV_reportviewer.DataBind()

Like I said, this works fine in development. All data is returned properly and the dataset checks out too. My questions are:

1) Do I HAVE to use SetDatabaseLogon (WCF service supplies data... report should not have access to database and I don't want it to access either)

2) Can I set this up so the dataset table suffices for report data ...

3) Shouldn't the DataSet with a valid table full of data suffice for the report to display... So basically...
4) How can I get rid of prompt (preferably without the report having access to the database) ?

Any answer to these questions would be great... I do not mind changing the report so it does not prompt for data without having to hard code database access credentials anywhere on the web pages... WCF Service provides data... n-tier application... I know these are four questions in one but number four is what I really need answered if anyone would be so kind

I used Crystal many times over the years but cannot recall having to give it access to the database... This setup works fine with a windows client but not on a web site

Best Regards and thank you in advance;

[former_member11696 · Accepted solution]

Hi Brendon,

As of CR 2011 we no longer ship the .NET SDK with CR Designer.

To get the runtime go here:

https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

Read ALL of the info for SP 21.

Yellow button on the download page is to integrate into VS 2010 ->2017, all others are for redist purposes only, don't install them on your DEV PC.

Error is likley due to missing CR runtime, you cannot just copy on include them in your project, you must run the MSI.

Don

[former_member11696]

CR for VS only comes complete so the latest SP is the one you want to use.

[former_member606863]

I have most of it figured out... It was privileges issue Than you for your help

[former_member606863]

Hi Don;

Thanks for your reply. I installed both 32 and 64 bit versions on the web server for sp24. Do I still need SP21? I installed both version for SP24 as I assumed they were cumulative before I deployed the reports and the .net web app.

Do I still need SP21?

Brendon