The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Passing a value from 7.5 to Crystal
Posted: 10 Oct 08 1:32 PM
|
No response in the BP NG so here it goes:
Here is my script set as the opening action for a report in SLX 7.5 LAN. The report is launched from a button on RMA Detail.
sub Main
Dim strRMAID
strRMAID = application.BasicFunctions.CurrentViewID
msgbox "RMAID is " & strRMAID
application.BasicFunctions.ReportClearConditions
application.BasicFunctions.ReportAddCondition "RMA.RMAID","=",strRMAID,"String",""
end sub
I know this script runs because I get a messagebox
showing the correct RMAID value.
But the preview contains ALL records on the RMA table. I have confirmed
with SLXProfiler that the query runs with no WHERE clause.
Is this a 7.5 bug or am I missing something obvious? |
|
|
| |
| |
|
Re: Passing a value from 7.5 to Crystal
Posted: 15 Dec 08 12:20 PM
|
Now I am a little puzzled,
Seeing your message box in you script gave me an idea. I put the a msg box in my script. I don't get the message at runtime.
I have set the report to call the my script in the When Open.
My report is accessed via the standard SLX report selection. I using a script somehow not allowed from the standard report selector ?
|
|
|
|
Re: Passing a value from 7.5 to Crystal
Posted: 13 Jan 09 5:29 PM
|
The open scripts do not run whent he report is run from the Reports Manager. When in the Report Manager, use the built in filtering features to pass values to the report.
The script runs when you launch the script from a button or menu item. |
|
|
|
Re: Passing a value from 7.5 to Crystal
Posted: 14 Jan 09 7:16 AM
|
As a side conversation, has anyone been successful in accomplish the same result in 7.5 Web? i.e. Pass a recordID as a parameters to Crystal and run it? Can't find a way to accomplish this that works...
|
|
|
|
Re: Passing a value from 7.5 to Crystal
Posted: 26 Jan 09 11:18 AM
|
Argh.....
Let me expand on my issue. Inside a report is a sub report This sub report accesses data from a different data source. This sub report needs to have a parameter passed to it with the value from a field in the USERINFO table. That value is dependent on who ran the report. How do I pass to, or access from within the subreport, the needed value from the userinfo table based on who ran the report?
Confused?
I am.  |
|
|
|
Re: Passing a value from 7.5 to Crystal
Posted: 27 Jan 09 6:17 AM
|
Create a parameter in the sub report. Then when you link the sub report to the main report use the parameter field you created to pass in the value from the main report. You will see that parameter listed for linking as long as the data type is correct. I'm assuming here you have already gotten the value you wanted in the main report.
Then you can use the parameter(s) in the sub report to do whatever you need.
Maria |
|
|
|