Crystal Enterprise - creating dynamic parameters

[dev32]

Hi All,

My client has purchased CE 9, wants to use the built-in ePortfolio site. There will be many groups assigned to different folders, with the purpose of viewing the same report, with the results tailored to who the user is (Sales dept East office, Sales dept West office). Prior to viewing the report, they want the user to be able to filter the report even further with the use of dropdown boxes, with the dropdown boxes options tailored to the particular group (each group would see different options). I know there's a 3rd party product out there called "dynamic parameters". However, has anyone else out there built and then implemented something similar into the CE app?

thanks

 

[mdwyer]

We have a similar need, and I was able to develop a picklist that performs a real-time query to the database. It is table-driven, based on the parameter names, with the query logic built into View SQL tied to each enabled parameter. At this point, neither User nor Group are passed to the queries, but I think this could be done with a little more work.

My technique conditionally changes the <input> tag for a parameter to a <select>, and the query results are formatted in <option> tags (basically &quot;<option value=db_value>db_description&quot. The code is inserted into schedule.csp using a #include file.

If you're interested in seeing the code, write dsom8 AT hotmail.