?
Solved

Parameter List Not Showing

Posted on 2012-08-28
11
Medium Priority
?
531 Views
Last Modified: 2012-09-02
Report files created with Crystal Reports XI
Website developed with Visual Studio 2010 (Pro)
Report Engine is Crystal Decisions v. 13.0.2000.0

Hi all,

I'm developing a web site to serve up reports to our managers.  Everything seemed to be going ok, then suddenly the parameter selection screen ("Enter Values") started showing up with no options available.  This occurs for every report that is to be displayed where there are parameter options.  It also doesn't matter whether the parameters are Dynamic (retrieved from the report query) or Static (a list the I typed in).  All the parameter selection screen layout is correct (list boxes, combo boxes, etc), they're just all empty.

I don't think I did any thing to cause it.  I was adding the report option(s) to the database (what reports are available, which user sees what reports, what parameters are set at what default value, etc).

If I run these reports within the Crystal Reports designer (application), everything works correctly and the parameter options are all correctly filled.

What's going on and, more importantly, how do I fix it?

TIA
0
Comment
Question by:Clif
  • 6
  • 5
11 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 38340891
Why are you using CR XI nd not the version available for VS2010.  You can download it here

     http://www.businessobjects.com/jump/xi/crvs2010/default.asp

There always seem to be issues when you mix Crystal versions.

mlmcc
0
 
LVL 10

Author Comment

by:Clif
ID: 38340986
I'm using CR XI because that's what the reports were written in before we acquired Visual Studio.

I would really rather not rewrite all the reports (200+).
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38341348
You shouldn't have to rewrite them.  You should be able to open them in CR 4 VS2010 and that will convert them.

As far as I know VS2010 is NOT a supported platform for CR XI.  Have you tried using the CR XI runtimes/assemblies with VS2010 rather than using the CR13 assemblies?

mlmcc
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 10

Author Comment

by:Clif
ID: 38341409
There are no XI runtimes/assemblies for Visual studio (as you pointed out, CR XI is not directly supported in Visual Studio).  The CR13 are available (for free) from SAP in placement of those missing runtimes.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38342179
CR XI has .Net assemblies.  I have used it in VS2005 and 2008.

There are issues with using different versions of Crystal.  CR9 and later are file compatible but the assemblies may cause issues in running the reports.

You can try using the CR XI .Net assemblies in VS2010.  The fact they say it is not supported simply means they never tested it and will not respond to issues.  SInce CR XI is well past support from SAP/Crystal that really isn't an issue.  VS2010 is the first version of VS that has a version of Crystal that is after CR XI.  CR for VS2008 was still based on CR10.

mlmcc
0
 
LVL 10

Author Comment

by:Clif
ID: 38342198
SAP support insists that I use the version 13 library/assemblies (specifically SP3).  

http://scn.sap.com/docs/DOC-7824
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38342254
Is this on your machine or a client?

What browser and version?

mlmcc
0
 
LVL 10

Author Comment

by:Clif
ID: 38342370
On my machine (running localhost).

The issue appears on both IE9 and Chrome.
0
 
LVL 10

Accepted Solution

by:
Clif earned 0 total points
ID: 38342594
I discovered the problem.

The issue with with the ID property of the CrystalReportViewer.  which I was setting from values in the database.

According to the MSDN website:
Only combinations of alphanumeric characters and the underscore character ( _ ) are valid values for this property. Including spaces or other invalid characters will cause an ASP.NET page parser error.

As I said in the OP, everything was going good and I was adding the report option(s) to the database (what reports are available, which user sees what reports, what parameters are set at what default value, etc).  It turns out the I had used space and dash characters to the values that would eventually be assigned to the ID property.  Once I "fixed" those values, everything is back to working correctly.

Thanks for trying.  :-)
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 38343305
Glad you found it.  SInce I don't build reports for ASP applications I would not have found that.

mlmcc
0
 
LVL 10

Author Closing Comment

by:Clif
ID: 38358453
Found the solution myself.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this Article, I will provide a few tips in problem and solution manner. Opening an ASPX page in Visual studio 2003 is very slow. To make it fast, please do follow below steps:   Open the Solution/Project. Right click the ASPX file to b…
Introduction This article shows how to use the open source plupload control to upload multiple images. The images are resized on the client side before uploading and the upload is done in chunks. Background I had to provide a way for user…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Planning to migrate your EDB file(s) to a new or an existing Outlook PST file? This video will guide you how to convert EDB file(s) to PST. Besides this, it also describes, how one can easily search any item(s) from multiple folders or mailboxes…
Suggested Courses

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question