Showing results for 
Search instead for 
Do you mean 
Community Home Request Access Read Blogs Share Your Ideas Search Community View My Settings
Reply
Highlighted
Copper Contributor
Posts: 25
Registered: ‎09-27-2013
Accepted Solution

Saleslogix 8.1 Web upgrade - Error running Reports

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

Gold Super Contributor
Posts: 3,087
Registered: ‎03-19-2009

Re: Saleslogix 8.1 Web upgrade - Error running Reports

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.

--
RJ Ledger - rjledger@rjlSystems.net +1 603.369.3047 x101

".. Innovators in Mobility - Experts in Workflow Automation..."
http://www.rjlSystems.net - blog: www.rjlSystems.net/blog.html
Moderator
Posts: 440
Registered: ‎05-07-2008

Re: Saleslogix 8.1 Web upgrade - Error running Reports

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.

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

Copper Contributor
Posts: 25
Registered: ‎09-27-2013

Re: Saleslogix 8.1 Web upgrade - Error running Reports

Thanlks RJLedger,

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

Nickel Contributor
Posts: 90
Registered: ‎03-20-2009

Re: Saleslogix 8.1 Web upgrade - Error running Reports

[ Edited ]

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!

Jim Pemberton
Vice President of Engineering
Simplesoft Solutions, Inc
Award Winning Infor CRM Business Partner
Moderator
Posts: 440
Registered: ‎05-07-2008

Re: Saleslogix 8.1 Web upgrade - Error running Reports

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.

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

Nickel Contributor
Posts: 90
Registered: ‎03-20-2009

Re: Saleslogix 8.1 Web upgrade - Error running Reports

Thanks!

 

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

Jim Pemberton
Vice President of Engineering
Simplesoft Solutions, Inc
Award Winning Infor CRM Business Partner
Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Saleslogix 8.1 Web upgrade - Error running Reports

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

RJ Samp
Moderator
Posts: 440
Registered: ‎05-07-2008

Re: Saleslogix 8.1 Web upgrade - Error running Reports

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 

John Perona

Director, Infor CRM Development

Infor CRM

Infor CRM

Silver Contributor
Posts: 835
Registered: ‎03-24-2009

Re: Saleslogix 8.1 Web upgrade - Error running Reports

[ Edited ]

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!!!)

RJ Samp