04-25-2014 08:55 AM
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
Solved! Go to Solution.
04-25-2014 10:43 AM
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.
04-27-2014 08:42 AM
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 DevelopmentInfor CRM
04-28-2014 01:17 AM
04-28-2014 05:33 AM - edited 04-28-2014 05:33 AM
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!
04-28-2014 08:38 AM
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 DevelopmentInfor CRM
04-28-2014 08:41 AM
Thanks!
I just wanted to make sure nothing had changed from what we had been presented with.....
05-23-2014 09:18 PM
John, does that include LAN Crystal reports with the new Class Scripts? No Dynamic Parameters?
05-24-2014 02:10 AM
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 DevelopmentInfor CRM
05-24-2014 05:44 AM - edited 05-24-2014 05:58 AM
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!!!)