anyway of capturing parameters Crystal reports

[pectin232]

Individual Crystal reports are being launch by any user using a Java application. They use the Java web application and then goes through different screens, sets different radio buttons, etc and clicks on submit. That launches Crystal reports and the user is able to view the report, save it as PDF or print it. What I am wondering if there is a way to capture Crystal reports parameters when being requested. We have the parameters when the Java application passes or request the values... but not sure how Crystal reports responds to this internal requests. We need the 'invisible' parameters from business objects or from Crystal reports if possible.


2011-07-15 10:31:48,193 INFO [STDOUT] >> Creating Report for REPORT_TEMPLATE_ID=16321 Report out put Type =0 0 means .pdf
2011-07-15 10:31:48,193 INFO [STDOUT] Before callCreateReport for reportNameFromJSP = Frm_Employee_Status
2011-07-15 10:31:48,193 INFO [us.oh.state.odjfs.sacwis.webreporting.servlet.ReportServlet] ReportServlet.callCreateReport : Entering.
2011-07-15 10:31:48,193 INFO [STDOUT] reportName>>>>>>Frm_Employee_Status
2011-07-15 10:31:48,193 INFO [STDOUT] iReportDataMap>>>>>>>>>>> {EMPLOYEE_ID=281127, REGION_ID=1812072, STATUS_INFO=1812138,1812100, FROM_DATE=01/01/1900, COMMENTS=}

 

[Madawc]

I'm not familiar with Java, but any parameter that Crystal can use should be capable of being included in a formula field and displayed on the report.

If that's not it, then please explain again what the problem is.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[pectin232]

when Crystal reports run I am trying to see if I can capture the parameters being invoked by Business Objects server. If the user requests for [expample] UserID, address, phone, roleID, roleCode, etc etc.. I would like to see what crystal reports passes behind the scenes. Not sure if I am clear. I know what parameters are being called or used but there are some implementation issues so we are trying to determine if Crystal report is passing the correct parameters being called for by the JAVA application. The above is what the Java app requests from crystal. We determined the JAVA app is requesting the correct parameters but we are now trying to determine if Crystal is then the culprit of passing the wrong or incorrect data sets... or it might be bad data from incorrect views created and table joins inconsistencies.

 

[IanWaterman]

If crystal is using any paramters they will be visible in eth Filed Explorer under Paramters. These can be displayed by simply placing them in the Report header.

However, if CRystal is being given a bespoke SQL statement then you will not be able to display those parameters.

If you know which fields might be restricted like

UserID, address, phone, roleID, roleCode you can create some formula to detect if they are being filtered, example formula below can be placed in report header

@UserID

If maximum(USERID) = minmium(USERID) then USERID else 'Not filtered'

Data type in formual must be same, eg If USERID is a number

If maximum(USERID) = minmium(USERID) then totext(USERID, 0,"") else 'Not filtered'

Ian

 

[pectin232]

Thanks so much. I will request them to try that option.