- Posts: 26
- Thank you received: 0
- English support forums
- Can I do this with LimeSurvey?
- Generating Reports: which software would you suggest?
Generating Reports: which software would you suggest?
I am trying to create surveys for HR assessments. This means, participants will take a certain test and in the end, a report will be generated for each participant.
So, if 500 people take the test, 500 personalized reports, (i.e., with their individual performance on that test) will need to be generated.
Which software would you suggest for:
1. Creating the layout of the report (e.g., Page 1 will have name and logo, Page 2 will have Index, Page 3 will have two bar charts and some predefined text etc.)
2. Generating reports based on the format defined above?
Will it be one software or will it be two or more?
Look forward to your responses. Thanks for your time!
Ha a look at this old post , where
Frans Marcelissen, DigiPsy
BTW Frans's way & experience sounds much better
Thanks a lot for your responses! Will try to get help from my developer Partners in this regard, bsaed on your inputs...
fransmarcelissen wrote: I use R for this purpose. You can export the survey or read the data using rpc (which is what I do), read it into Rstudio, and generate a report, or do it directly using rapache. I generated thousands of reports in this way. If you need help, please let me know.
Frans Marcelissen, DigiPsy
I'm very interested on this solution. Please could you help me ? I would love to have a more detailed explanation for this solution(approach)
For several projects I have used a custom coded website and made use of " Highcharts ", a very nice JS library. I created the whole report as a website to which users get redirected after having submitted their responses and I also added a "print report" button which allows to call the browsers print option.
Using special print CSS you can create a printing optimized version of the report. Most browsers also report direct PDF printing.
I also created a more complex Limesurvey reporting dashboard based on highcharts, see " 4. Interactive dashboard showing statistics and charts based on Limesurvey survey data " at the bottom of the page.
The logo part could be interesting. Does each user have their own logo, or is it one logo for all reports? In Crystal Reports you can either import the logo as an image and show it using conditional formatting, or you can store the images in the database and show them in the report. (I wondering outloud, perhaps you could add an attribute field in token table and import the user image and store as binary in the DB?)
The biggest weakness is that Crystal Reports is more for in-house type reporting than web delivery/interactivity. It is great to go to the printer or PDF, but Crystal isn't the best to deploy on the web for consumables. If you need that, you would have to either build your own Crystal Reporting Application in .net or on Eclipse. You could also pay a ton of money and use the Crystal Server boxed product.
If cost is a concern, you could use JasperReports for local reporting and/or JasperServer for web delivery. Another option could be Microsoft Reporting Services if you are a MS shop. You can run LS on top of MSSQL and that goes right into Reporting Services. R and Shiny might also be another solution if you are ready to get a little more advanced.
Tammo ter Hark at Tools for Research
Proud developers of the TFR Responsive Limesurvey theme
Windows or Linux:
PSPP (basically a free, opensource version of SPSS)
You could also use the more common: MySQL, Microsoft Access, Microsoft Excel, Libre Office