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!
|
|
Dynamic parameters in Crystal XI
Posted: 12 May 08 10:41 AM
|
With the new version of crystal I created a report with a dynamic parameter that pulls values from a simple custom table (no stored procedures, views or cascading parameters).
Sometimes users are prompted with a login screen before the parameter window appears, some do not get prompted.
If I make the parameter static then no one is prompted but this field is updated by power users and can change frequently. it is a pain to update the static parameter contantly.
Any help is greatly appreciated. |
|
|
|
Re: Dynamic parameters in Crystal XI
Posted: 16 May 08 11:23 AM
|
| I'm not 100% sure I understand your problem. What is the login screen that your users are seeing? Is it the select a database screen? If so, it could be the database provider you're using within your report. |
|
|
|
Re: Dynamic parameters in Crystal XI
Posted: 19 May 08 7:53 AM
|
I am using the SalesLogix OLE DB provider and the report is run directly from the Reports section in SalesLogix. I guess I could use a different provider but then I would be bypassing the SLX security which I cannot do.
|
|
|
|
Re: Dynamic parameters in Crystal XI
Posted: 22 Sep 09 9:54 PM
|
Paul,
I have the same issue. I would love to feed the credentials it needs so I can run the dynamic parameter. I'd also love to see if I can add a parameter on-top of the dymanic parameter to control what results appear in the list of available choices.
I posted this someplace else in the forum but I went into alot more detail (overly wordy) then what was needed. If anyone has figured out a method to get around the authentication or to feed it the credentials and to restrict values pulled from a dynamic parameter, your thoughts are definately appreciated. |
|
|
|
Re: Dynamic parameters in Crystal XI
Posted: 01 Oct 09 8:03 AM
|
Another solution could be to use Crystal RDC object from a form used to define the parameters. Those parameters can be added to a selection string and passed to the report call from a button. This would remove the parameters from the report and add them to the report filter. May even speed up the report. See example code below
sub XtalReportCall(strReportName,strSelectionFormula,strCaption)
Dim Report
Dim strAccountID
Dim strUserID
Dim objReportMV
'SalesLogix Report family and name example
' strReportName = "Account:Account Detail" '
'Get RDC Object
set Report = Application.BasicFunctions.GetCrystalReport(strReportName)
Report.DiscardSavedData
strAccountID = application.BasicFunctions.CurrentAccountID
strUserID = application.BasicFunctions.CurrentUserID
'Use RDC to set conditions
'strSelectionFormula example
' strSelectionFormula = "{ACCOUNT.ACCOUNTID} ='" & strAccountID & "' "'and {OPPORTUNITY.STATUS} in ['Open', 'Open - Referral']"
Report.RecordSelectionFormula = strSelectionFormula
set objReportMV = Application.MainViews.Add("System:SLX Crystal Report Viewer",0,False)
objReportMV.Caption = strCaption
objReportMV.height = 600
objReportMV.width = 800
objReportMV.Show
Application.BasicFunctions.ProcessWindowMessages
objReportMV.DetailsView.Script.Display Report
set objReportMV = nothing
set Report = nothing
End Sub |
|
|
|
Re: Dynamic parameters in Crystal XI
Posted: 24 Sep 10 10:39 AM
|
Has anyone determine why only certain users are prompted for the login information from a report launched via SLX and others do not?
|
|
|
|