Invalid Report Source CR 2008

[Former Member]

Im trying to preview a report from my webpage. I get Invalid Report Source error.

Also, I have an hint that it might be because of wrong references added to the project.

I also have questions regarding the framework versions for the assemblies.

for example, CrystalDecisions.Shared exists in both 12.0.2000.0 and 12.0.1100.0

the same with Engine. My website is a .NET 2.0 website.

Which is the exact reference I should use.

Any help is appreciated.

Thanks,

Aswin Dwarakanath

[Former Member · Accepted solution]

Hi,

I have a number of issues still. Not all dlls are versioned for 2.0. majority of them are still for 1.1

But before even that,

What directory should I add as a virtual directory in the website.

Thanks for your help,

Aswin

[Former Member · Accepted solution]

I have no virtual directory configured. I also no files in \aspnet_client\system_web\2_0_50727\

When I run my report I get Missing parameter values.

When I say in the code

ReportViewer.EnableParameterPrompt = True

I get the textboxes for the parameters.

I have a dataset with all the data computed from a stored procedure and assign that as a datasource to the report.

Dim cr As CrystalDecisions.CrystalReports.Engine.ReportClass
dim ds as dataset
ds = MCDAL.ExecuteDataSet(Me.ConnectionString, m_reportDefinition.Source,_ ConvertReportParameterCollectionToArray())
cr.SetDataSource(ds)
.
.
ReportViewer.ReportSource = cr

Please help

[former_member183750 · Accepted solution]

See the two White Papers in this post:

Ludek

[Former Member · Accepted solution]

Right now, I can compile and my website can run.

But Im no way near about the virtual directories etc, because my report wont run at all.

I have a dataaset with all the data that Crystal needs. If I open the report in Crystal report editor and supply the values, I can see the report.

But when I run the report in my website after assigning the datasource as my dataset, I get

missing parameter values.

can you help.

[former_member183750 · Accepted solution]

Hmm, I could swear you said the following:

"I have no virtual directory configured. "

As such I figured I'd help out with that(?).

In any case Aswin, I htink it's time to go back to square one...

Start small. Simple report - one field. New web app, make it work there. Once this simple scenario works on your development environment, try to make it work on the web server.

You may also want to consider trying to run some of our sample apps from here, possibly starting with a windows app, moving on to web after you gain confidence and experience:

Win apps:

https://smpdl.sap-ag.de/~sapidp/012002523100006252822008E/net_win_smpl.exe

Web apps:

https://smpdl.sap-ag.de/~sapidp/012002523100006252712008E/csharp_web_smpl.exe

https://smpdl.sap-ag.de/~sapidp/012002523100006252812008E/net_web_smpl.exe

These resources will also be of help:

http://www.businessobjects.com/global/pdf/dev_zone/VS2005_Walkthroughs.pdf

https://boc.sdn.sap.com/dotnet

https://websmp106.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000713358&_SCENARIO=011000358700000002...

https://smpdl.sap-ag.de/~sapidp/012002523100006252822008E/net_win_smpl.exe

https://boc.sdn.sap.com/developer/library

BTW., the error you are getting; take it at face value. I suspect the report contains a parameter that you are not setting...

Ludek

[Former Member · Accepted solution]

Hi Ludek,

I downloaded a sample report from this website.

I actually got a report to work. Thats good news. But that ran from the Visual Studios native IIS.

The code is 100% similar to my code.

I get compilation errors in my aspnet_client where I copied this entire directory.

C:\Program Files\Business Objects\Common\4.0\crystalreportviewers12

I copied it to the root directory of the website.

the path is \aspnet_client\system_web\2_0_50727\crystalreportviewers12

Im NOT adding any virtual directories. I get the compilation error in this file.

\aspnet_client\system_web\2_0_50727\crystalreportviewers12\crystalimagehandler.aspx

The file contents were

<%@ Page AutoEventWireup="false" Inherits="CrystalDecisions.Web.CrystalImageHandlerPage, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

I discovered CrystalImageHandlerPage was wrong after I got a compilation error.

Could not load type 'CrystalDecisions.Web.CrystalImageHandlerPage' from assembly 'CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304'. website\aspnet_client\system_web\2_0_50727\crystalreportviewers12\crystalimagehandler.aspx

After that I changed this to CrystalDecisions.Web.CrystalImageHandler, which gave me a slightly diff error.

CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is not allowed here because it does not extend class 'System.Web.UI.Page'. website\aspnet_client\system_web\2_0_50727\crystalreportviewers12\crystalimagehandler.aspx

Please help me thanks.

[former_member183750 · Accepted solution]

Aswin, I'm confused.

In one post you say:

"I have no virtual directory configured."

I send you resources to figure that out. Your reply was:

"... Im no way near about the virtual directories etc., because my report wont run at all."

Now you are back at the virtual directories. The fact that you have a number of assemblies of version 12.0.1000 is OK - as long as the .engine, .shared, .reportsource and .web / .windows.forms are 11.0.2000. Now, since you are back at the virtual directories, please see the post from 6/27/08, download the two White Papers attached to that post and see if you can get your virtual directories to work following the WP.

Ludek

[Former Member · Accepted solution]

I guess you had a typo error here

as long as the .engine, .shared, .reportsource and .web / .windows.forms are 11.0.2000

I have all the above as 12.0.2000

[former_member183750 · Accepted solution]

yup. you are correct 12.0.2000

[Former Member · Accepted solution]

The Virtual Directories....huh

The document that is attached to the other post you referred to, that explains only upto CR V X1.

Byt Im using CR 2008. So please update me what exactly I should do.

Also I get a compilation error from crystalImageHandler.aspx file.

this is under \aspnet_client\system_web\2_0_50727\crystalreportviewers12\crystalimagehandler.aspx

the error I get is

CrystalDecisions.Web.CrystalImageHandler, CrystalDecisions.Web, Version=12.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' is not allowed here because it does not extend class 'System.Web.UI.Page'.

Please help me. Im nearing my deadline here. Still a long long way to go. ;-(((

[former_member183750]

Based on the following:

"My website is a .NET 2.0 website."

I assume you are using .NET 2005 and CR 2008. That being the case, you have to use assemblies of version 12.0.2000.0. Assemblies of version 12.0.1100 are for the 1.1 framework.

The correct MSI is here:

https://smpdl.sap-ag.de/~sapidp/012002523100009351552008E/cr120_redist_install.zip

and the correct msm is here:

https://smpdl.sap-ag.de/~sapidp/012002523100009351532008E/cr120_mm.zip

Ludek