Crystal Report in Visual Studio 2008 ASP.NET will not show the parameter entry page on the production server

Jennifer Barman
Jennifer Barman used Ask the Experts™
on
I have my program loaded on the production server and everything in my program is working fine except for my crystal report. It will not prompt for the parameter.

Help?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014

Commented:
Is the parameter used somewhere on the report?
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Hiow are you viewing the report on the server?

Is the report saved with data, that is the Crystal default setting.  If it is you generally don't get prompted for parameters until you refresh the report.
Try opening the report and hit the F5 key.

mlmcc

Commented:
Can you post the code (or printscreen of property page) where you define the report file (.rpt file) the report viewer is supposed to use? Is it pointing to the correct path where the report file resides?
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

Author

Commented:
--- yes there is a parameter in the report.

--- I tried the F5 key and it did not refresh the report.

-- Here is the print screen of the .rpt properties page.

after looking at this.. this is strange, because it is pointing to the C drive and everything is on the D drive..
properties-page.jpg
Commented:
I had a suspicion that that would be the problem .
That is because in your development machine you had things on your c: drive and then you copied to the d: drive of the production machine.
Change the path to the correct path.
Other things may be incorrect as well.
I would suggest in the future to put your app folder on the same drive as the production machine.
If you don't have a d: drive you could create a virtual one.

Author

Commented:
I have changed it and I get that same "Load Report Failed" Error..

I changed the path, then I also copyed the entire folder. removed the old folder with the app data and replaced it with the revised one. I am still not getting the report to load.

Commented:
What did you change the path to?

Can you open the report on the production machine and try to run it?

You never added the ASPNET account to your app folder that I am aware of which was suggested.
Could you post a printscreen of permissions for the app folder on your development machine?

I know that using a Web Setup Project takes longer than copying but in your case it probably would not be a bad idea and ti should not take that long if all you have is crystal report and devexpress components.

Author

Commented:
GOT IT!! :)

I was adding the report path like \\mvrbc-sql1\d$\RefLab\

I needed to add it like D:\RefLab\

Thanks for All your HELP!! :)
Most Valuable Expert 2012
Top Expert 2014

Commented:
Dont change any paths in the solution. The solution is in C drive so its fine. Use a relative path when setting the report source of the crystal report viewer. For example
Viewer.ReportSource = "/Reports/Report1.rpt"

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial