Saleslogix 8.1 Web upgrade - Error running Reports

[ChapmanFreebornNath]

Hi Guys,

I'm in the process of runing through upgrading our modified 7.5.4 Web Environment to 8.1 Web. All going very well so far, except for one thing:

When I try and 'Run Report' on one of the many custom crystal reports we have in the Web Env, the progress bar pops up and then after  a while I get the error message "Reports with dynamic parameters are not currently supported" .

Now everyone of these reports is tested and working in SLX 7.5.4 - is anyone able to tell me whether this error message is *correct* and reports that were once supported/ran fine will no longer run or whether this is a misleading error message(and that maybe there's an issue with the jobserver, or something).

Thanks for your help.

Nathan

[RJLedger]

Error message is correct..

CR version is different for 8.1 and there is info in the docs on just what is happening - you have to "fix" your reports.

[jperona · Accepted solution]

This is a known issue for 8.1 Web.  It does not currently support Reports with Dynamic Parameters.  We are currently working on the solution for that scenario.

[ChapmanFreebornNath]

Thanlks RJLedger,

Which documentation is this specified in? It's not explicitly mentioned in either the implementation guide or the upgrade guide....

[jlpemberton300]

RJ,

Which documentation are you referring to?

John,

Does this mean we have lost the ability to filter down a report to only run for a specific record?  (I.E. If I want to print a Crystal Report for a specific Opportunity?)

Thanks!

[jperona]

We've presented the limitation for Dynamic Parameters in public partner facing communication since the Partner conference.  Note, we support paramaters and filtering, just not "Crystal" dynamic parameters.

Jim,

We do support filtering to a single record, that's what a detail report on the "detail view" already does.

[jlpemberton300]

Thanks!

I just wanted to make sure nothing had changed from what we had been presented with.....

[RJSamp]

John, does that include LAN Crystal reports with the new Class Scripts? No Dynamic Parameters?

[jperona]

No since the LAN uses the Crystal Report Viewer it currently supports Dynamic and Dynamic Cascades Parameters.

Note, that they API's have changed slightly as the new Crystal Reports is a .NET API so we have abstracted that for VBScript.

We've got some rough documentation so if you are starting a project I can get you that as a "very" early draft 

[RJSamp]

That is great! Can you sure an example of how to do this? For example.....we can't even turn off the Parameter dialog boxes......

All the examples of external parameter calls we find set the name and value pairs in the Crystal Reports object.....then set all of theses pairs to a Parameters property in the Repot Viewer object. Then Report Viewer.Show().

vbScript
Dim frmReportViewer As New ReportViewer

Dim rptRc As New AgrisoftReports.Reports.rpt_Railcar

rptRc.SetParameterValue(

"@pReportDate", m_dateReport)

SetReportDBConnection(rptRc)

CrystalReportViewer1.ReportSource = rptRcfrmReportViewer.MdiParent =

Me.MdiParent

frmReportViewer.Show()

c# .Net

 Private void button1_Click(object sender, EventArgs e)     {

            //creating an object of Report Document class

            ReportDocument reportDocument = new ReportDocument();

            //creating an object of ParameterField class

            ParameterField paramField = new ParameterField();

            //creating an object of ParameterFields class

            ParameterFields paramFields = new ParameterFields();

            //creating an object of ParameterDiscreteValue class

            ParameterDiscreteValue paramDiscreteValue = new ParameterDiscreteValue();

     //set the parameter field name

            paramField.Name = "designation";

            //set the parameter value

            paramDiscreteValue.Value = textBox1.Text;

            //add the parameter value in the ParameterField object

            paramField.CurrentValues.Add(paramDiscreteValue);

            //add the parameter in the ParameterFields object

            paramFields.Add(paramField);

            //set the parameterfield information in the crystal report

ParameterFieldInfo = paramFields;

            //preparing root for preview

            reportDocument.Load("D:\\rohit\\crystal reports\\CrystalReport1.rpt");              

ReportSource = reportDocument;

SetDatabaseLogon("userid","password","servername",                                              "database");

We are getting errors using Apply Params method in the SIX Crystal Reports Cass......


Help!!!#!! (and Thanks!!!)