Well I am not an "EPIC" person, but I am certified in Ambulatory and Inpatient and decent with SQL query writing.
We do not have the EPIC crystal integration yet... but soon. All our reports are via the BOE servers.
First there are a couple of down sides to dynamic parameters. Displaying the choices of the parameter in the header can be tricky. I use a sub-report. If you are exporting your reports to Excel, (which I do a lot of) then getting the parameter choices to display with out messing up the header is... just plain not going to happen.
Now I would start with reading up on these two sites first. They are not totally dedicated to dynamic parameters but are a good place to start.
Site 1
Site 2
OK lets start with the crash course in setting up the parameter.(I can't take credit for all of this, I have learned a lot from my coworkers, and I am poaching almost all of their 'guide')
1.Connect to your BOE server, launch Business View Manger
2.Create new Data Foundation - (test your select statement first)
a.File - New - Data Foundation.
b.You will be prompted to select A Dynamic Data
Connection - choose DataConnection1.
c.At the Insert Data Tables window, highlight Add Command and click the Add button.
d.Paste your SQL Query into the box.
e.You have to create a new parameter list item.
f.Click the Create button in the Parameter list frame.
g.Enter a Name, and Prompting text, click Ok, click Ok, click Close.
h.Save in the 1 Data Foundations folder with a name that ends with _DF.
i.Close the new Data Foundation.
3.Create new Business Element -
a.File - New - Business Element.
b.You will be prompted to select a Data Foundation, choose the Data Foundation you just created.
c.On the Insert Business Fields window, open the Command in the Data Foundation, highlight each field, and click Add to insert the fields from your Data Foundation.
d.Click close after all fields are added.
e.Save in the 2 Business Elements folder with a name that ends with _BE.
f.Close the new Business Element.
4.Create new Business View -
a.File - New - Business View.
b.You will be prompted to select a Business Element, choose the Business Element you just created, click Add, and then Close.
c.Save in the 3 Business Views folder with a name that ends with _BV
5.Create new List Of Values
a.File - New - List of Values.
b.You will be prompted to select a Business View, choose the Business View you just created
c.On the Create List of Values window -
i.Enter a name that ends with _LOV.
ii.Move the ‘Code’ or ‘ID’ field from the left to the List of Values Fields window on the right.
iii.Choose the ‘Name’ field in the Description Field drop down box.
iv.Leave all other options as they are.
v.Click OK, and then select the 4 List Of Values folder to save in.
6.Create new List of Values Prompt Group -
a.Start a new report in Crystal Reports.
b.Create a new Parameter Value.
c.Name the parameter with the same name you used for the List of Values and add “- Prompt Group” at the end.
d.Choose Dynamic in the List of Values field.
e.Enter the appropriate Prompt Group Text.
f.Choose the Existing radio button for the data source, and choose the new _LOV you just created.
g.Click the row showing the Value, Description and Parameters in the middle of the window, then set the options as required in the bottom section of the window.
h.Click OK.
Now once the parameter is all set up, select, "Dynamic" from the List of Values drop down and "Existing" as the data source when creating the new parameter and select your Prompt Group from the drop down list. You will need to have Crystal connected to the server to be able to access the dynamic parameters on the server. I usually just open the repository explorer and this prompts the server log in window.
Well, I hope this helps.