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!
|
|
Displaying Report Filter Values
Posted: 31 May 06 6:07 AM
|
fiogf49gjkf0d I've tried asking SLX support this one. Is there anyway to display the values of the filters on actual printed reports? These are the filters users define in the report view.
Its really tough to print a report for a manager, director, VP, CEO, etc and have them look at it and ask what time period was it for??????
Any ideas?
Thanks,
John G. |
|
|
|
Re: Displaying Report Filter Values
Posted: 31 May 06 6:14 AM
|
fiogf49gjkf0d As regards to Date filters in particular, I would create Formulas to find the Min and Max of the dates returned. Not ideal but a bit closer.
James |
|
|
|
Re: Displaying Report Filter Values
Posted: 31 May 06 6:24 AM
|
zoloft and pregnancy lawsuit zoloft pregnancy fiogf49gjkf0d Ehhh, thats a bandaid. But if the SLX report module is passing these parameters and values I'm supposing these values are already in the report as some parameter? How else would the report know what date range or user to report for?
I guess its a matter of whether those values are exposed or can be (by knowing what their names are)
Thanks,
John G. |
|
|
| |
|
Re: Displaying Report Filter Values
Posted: 01 Jun 06 12:12 AM
|
fiogf49gjkf0d I think the SLX filters are aplied to the data before it ever gets to crystal so you will have to use crystal parameters if you whant to display them in the reports.
Regards,
Brian Sgeers |
|
|
|
Re: Displaying Report Filter Values
Posted: 01 Jun 06 8:54 AM
|
fiogf49gjkf0d Thats the course of action I took.. Build the parameters into the report and tell users not to use the SLX filters. It actually works out better. Reason.. because I can specify more parameters and the report is more 'intelligent'. That is geared toward the requirements.
I also use SQL stored procedures with parameters where ever possible and practicle. I like putting as much processing on the server side and leaving the client to just displaying the report.
John G. |
|
|
|
Re: Displaying Report Filter Values
Posted: 02 Jun 06 6:21 AM
|
fiogf49gjkf0d You can disable the SLX filtering by selecting a main table that is not Account, Contact, Or Opportunity and leaving the Master User and Date Fields blank in the report manager. |
|
|
|
Re: Displaying Report Filter Values
Posted: 02 Jun 06 12:02 PM
|
domperidone vidal domperidone arrow fiogf49gjkf0d I have coem up with a potential solution for this for use with SLX v7.0 (still in beta)
SLX v7.0 has some API's to expose the SLX Report Filter (plugin) definitions *and* all the SLX Report U.I. and functionality is exposed as SLX ActiveX form and VBScript directly against the Crystal API. The net result will be that we can modify that code to pass the SLX filter information as Crystal Formulas and then present those formula values on the report Header if not blank.
I should not reveal much else about this as SLX v7.0 is still in beta, but wanted to share this so that people knew about a future option. |
|
|
|
Re: Displaying Report Filter Values
Posted: 04 Jun 06 9:49 AM
|
are abortions free how to have an abortion fiogf49gjkf0d That sounds like a very good possibility for a solution. Of course, being a beta who knows what will change between now and the release. Hopefully it will all stay the same with added functionaility.  |
|
|
|
Re: Displaying Report Filter Values
Posted: 05 Jun 06 1:22 PM
|
naltrexone buy where to buy low dose naltrexone fiogf49gjkf0d Well, you can do it now as well (with 6.2). The function Application.BasicFunctions.GetCrystalReport will return a loaded Crystal RDC object (with the report already loaded and connections to the current database already set). You can use this to your hearts content to pass in whatever values/forumulas etc you want. Of course, you will need to built your own sort of UI to provide some way for your users to launch the reports and provide the filter values - but you can do it.
I do hope to have an article on using the returned RDC object on this site at some point. |
|
|
|