Generating Reports: which software would you suggest?

More
3 years 6 months ago #118046 by nandan
nandan created the topic: Generating Reports: which software would you suggest?
Hello,

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!

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago - 3 years 6 months ago #118054 by Ben_V
Ben_V replied the topic: Generating Reports: which software would you suggest?
I think there is no software(s) you can use for this, but you have to write your own script or plugin...

Ha a look at this old post , where

DenisChenu wrote: - Use a JS system ( www.jqplot.com/ or www.highcharts.com/ or www.jscharts.com/ or ...)
- Do a plugin using 'afterSurveyComplete' event

.

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last Edit: 3 years 6 months ago by Ben_V.
The following user(s) said Thank You: nandan

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #118070 by fransmarcelissen
fransmarcelissen replied the topic: Generating Reports: which software would you suggest?
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
The following user(s) said Thank You: Ben_V, r0bis, nandan

Please Log in or Create an account to join the conversation.

More
3 years 6 months ago #118079 by Ben_V
Ben_V replied the topic: Generating Reports: which software would you suggest?
@nandan: Sorry, probably I misunderstood your question if related to some office side task and not to the display of an advanced report for the respondent. I know a quiet big research organization doing something similar using Crystal Reports... The few I know about the process is that it's an old LS installation, they are under IIS server and are sending direct queries to the db to generate a complete report.

BTW Frans's way & experience sounds much better ;)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)

Please Log in or Create an account to join the conversation.

More
3 years 5 months ago #119091 by nandan
nandan replied the topic: Generating Reports: which software would you suggest?
Awfully late reply, so apologies first!

Thanks a lot for your responses! Will try to get help from my developer Partners in this regard, bsaed on your inputs...

Please Log in or Create an account to join the conversation.

More
3 years 4 months ago #120370 by ordogz
ordogz replied the topic: Generating Reports: which software would you suggest?

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


Hello !

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)

Thank you

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #122420 by ordogz
ordogz replied the topic: Generating Reports: which software would you suggest?
Dear fransmarcelissen, If could you help me with some advice regarding this generation of reports, I would appreciate it . Thank you

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #122426 by Mazi
Mazi replied the topic: Generating Reports: which software would you suggest?
Which tool to select for such reports mainly depends on how complex your reports are and how complex the process of querying the underlying report data is.

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.


Best regards/Beste Grüße,
Dr. Marcel Minke
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)survey-consulting.com'"

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #122796 by Gordon55M
Gordon55M replied the topic: Generating Reports: which software would you suggest?
You can do this with Crystal Reports fairly easily if you allow the database to accept remote connections (assuming the DB is outside of your local machine). You'll need to download the MySQL connector for windows to make it work as I recall. Simple charting, crosstabs, and page control can all be done with Crystal Reports.

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.

Please Log in or Create an account to join the conversation.

More
3 years 2 months ago #122799 by tammo
tammo replied the topic: Generating Reports: which software would you suggest?
We decided to make something dedicated for our customer. This was a lot of work, but now we could do this faster..

www.toolsforresearch.com/40000-responden...h-decent-work-survey

Tammo


Tammo ter Hark at Tools for Research
Proud developers of the TFR Responsive Limesurvey template
toolsforresearch.com/limesurvey-responsive-template

Please Log in or Create an account to join the conversation.

More
3 years 1 month ago #122907 by jared
jared replied the topic: Generating Reports: which software would you suggest?
So how is everyone getting data "out" of Limesurvey programmatically? Specifically, question names and responses? Are you using RPC "export_responses". If so does anyone have an example they'd be willing to share? Just something to get me pointed in the right direction.

Thanks!

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #128121 by drbray
drbray replied the topic: Generating Reports: which software would you suggest?
You can export responses as CSV to your local machine and then import the data into a variety of different programs that will give you the ability to generate reports, run data analysis, etc. Some of these programs...
Windows or Linux:
SPSS
PSPP (basically a free, opensource version of SPSS)
Linux-specific:
GRETL
You could also use the more common: MySQL, Microsoft Access, Microsoft Excel, Libre Office
The following user(s) said Thank You: nandan

Please Log in or Create an account to join the conversation.

More
2 years 10 months ago #128125 by Ben_V
Ben_V replied the topic: Generating Reports: which software would you suggest?
you may read this post ;)

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The following user(s) said Thank You: nandan

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #168082 by r0bis
r0bis replied the topic: Generating Reports: which software would you suggest?
I also use R and the library from github that gets data directly from the survey into R is limer on github. This is a very powerful way of generating reports. Help and many examples are available but the overall learning curve is significant if you have no idea about R, but very rewarding.

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!