Hi,

I have a crystal report file which generates reports for each clients monthly. Each month the crystal report file should be refreshed. I could manually refresh the file, however I have many crystal reports, it's pain to refresh all of them manually on the first of each month.

After I did some research I found out, if I uncheck the option "save data with report" it should refresh the crystal file.

I have a program that converts crystal to pdf. If I uncheck that option and try to convert the file I get the following error: "Database logon failed".

Any help on how I can resolve this issue?

What do you mean?

Edited by rushelp - 02 Aug 2012 at 9:39am

So this is how I load my file. And yes, I did not had my connections to database. I added.
So this is what I have, however I get a dofferemt error.

string fileName = Path.GetFileName(reportPath);
ReportDocument report = new ReportDocument();
report.Load(reportPath);
//added this line
report.SetDatabaseLogon("User", "Pass", "Server", "Database");

"Missing parameter values".

Edited by rushelp - 02 Aug 2012 at 11:23am

That's what I've been trying to figure out all day. I do not pass any parameters from C# to Crystsal.

Going back to my first posts in here...

I had one big report that contained report for hundred clients. I needed somehow to separate it. I wrote a formula in crystal file where in that big report I can specify the client by it's ID. So what I was doing is running big report each time and when I get the client I need I saved it as to get one crystal file for that client, and then went to different client. That's how I get the report for all my clients.

Now when I think, the reason it's asking for the parameter is that I was entering them in crystal reports when I was doing {ContactInfo.ClientID} = {My_Parameter}.

And manually choosing parameter from the list I had. It's working this way, but only when it comes to REFRESH reports I get this.



Edited by rushelp - 03 Aug 2012 at 7:42am