Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

anyway of capturing parameters Crystal reports

Status
Not open for further replies.

pectin232

Technical User
Jan 22, 2011
67
US
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=}
 
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.

[yinyang] Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP [yinyang]
 
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.
 
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

 
Thanks so much. I will request them to try that option.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top