Notifications
Clear all
Topic starter
All,
I'm constantly writing bizzarre SQL queries to pull data out of our CPS12 database and historically I've published them by excel, html and a plethora of other ways. This particular one, I was hoping I could do by Crystal Reports (in the EMR side of the house, not PM). I've successfully created the report in the crwrpt folder and can view it but I have no idea how to pass variables such as one from a drop down list where the user can select a particular clinician or date range etc. and have that data pass to a variable within the RPT file. Where can one find that educational?
Posted : March 17, 2015 10:55 am
These are very fundamental capabilities of Crystal. It is an incredible data extraction and presentation tool. Once you use it, you will never go back to Excel or anything else. There is no better way to learn than to sit down with Crystal, ask how can I do whatever, and then either search the web, open a reference work, or the click on the help files. Crystal is relatively intuitive, but there are clearly some initial hurdles you must overcome. I have used "The Complete Reference, Crystal Reports, McGraw Hill". My bias is to read the reference with no expectation of retention of information, just the knowledge that the information is there. If you need any specific help, feel free to contact me.
John W. Fitzgerald, MD
Posted : March 17, 2015 11:31 am
Create a Parameter (ex: OBSDate). Then in your selection criteria, set the OBSDATE = Parameter. When the report runs inside EMR it will prompt you to enter a date. There are more flavors to it if you want multiple values, default values or have to convert datatypes (ex: DateTime to Date), but the prompts work.
Posted : March 18, 2015 5:17 am
Topic starter
Thanks Guys, very much. I'll do some more playing. I've used Crystal successfully multiple times an I agree, it is fairly straight forward but my question was more about integrating the two. I don't imagine the crystal documentation is going to help much with tying it to Centricity conditions but I'll see if I can integrate James' comment. When identifying the variable, you don't have to declare it, enclose it in brackets or add some funky symbol to tell it to treat it as a pass through variable?
Posted : March 18, 2015 6:51 am
If you setup parameter fields and then use them within the report (usually on the Record "Selection forumula") you will be promted within centricity with a crystal report popup asking you to fill in the parameters. As long as you can run the report within crystal, you should be able to run it in EMR. (make sure you used the report user to log in to the database, not the db administrator)
Posted : March 24, 2015 7:45 am
