Solved

IFS Cloud Crystal Report error

  • 8 February 2023
  • 5 replies
  • 579 views

Userlevel 5
Badge +15

Hello,

I am currently getting the error: “Error in retrieving the parameters” when attempting to view a quick report that is a crystal report.
 

 

Does anyone know where to look to fix this? The logs don’t provide any helpful information.

Logs:
 

Application - POST: [object Object]

Application - CMD(1): Execute Form_ViewReportCommand for 1 record(s).

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"SQL"]}})

Application - CMD(1): > "FALSE"

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"QUERY"]}})

Application - CMD(1): > "FALSE"

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"MS_REPORT"]}})

Application - CMD(1): > "FALSE"

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"DASHBOARD"]}})

Application - CMD(1): > "FALSE"

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"CR"]}})

Application - CMD(1): > "TRUE"

Application - CMD(1): navigate({"url":"page/QuickReportViewer/Crystal;$filter=QuickReportId eq ${QuickReportId}"})

Application - CMD(1): > "OK"

Application - CMD(1): if({"expression":{"==":[{"var":"record.QrTypeDb"},"WEB_REPORT"]}})

Application - CMD(1): > "FALSE"

Application - CMD(1): Done Form_ViewReportCommand.

Application - PATCH: [object Object]

Any help would be greatly appreciated

Thanks,
Bryan

icon

Best answer by Charith Epitawatta 9 February 2023, 01:29

View original

5 replies

Userlevel 7
Badge +31

Hi @bdoucette,

 

Hope this helps!

 

Userlevel 1
Badge +6

@bdoucette : What action did you perform to resolve the problem?

Badge +1

Although not specified in the documentation you also need to install the CRDotNetRuntime.msi from the Crystal Installer before you run the CRWebSetup installer. If you don’t do this first then you will get the error in retrieving parameters error.

Badge +4

@bdoucette : Can you please mention what you did to fix the issue? Thank You.

Userlevel 5
Badge +15

Hi @Nilusha and @ovjose 

This error is a pretty generic one. Could be an error with how you built the report, crystal web service engine, the data you are pulling from the report (for some reason crystal views have to have an additional ‘_A’ at the end of them or else they wont work), you arent pulling the correct view associated with the operational report, etc.

My fix was to correct the _A issue, but yours is probably different. Nilusha you would know more since you’re an IFS Employee.

 

Thanks,
Bryan

Reply