# Project: Report Generator

**URL:** <https://forums.librehealth.io/t/project-report-generator/1820>\
**Category:** Google Summer of Code\
**Tags:** gsoc2018, ehr, gsoc2018-project\
**Created:** [January 4, 2018, 5:47pm UTC](https://forums.librehealth.io/t/project-report-generator/1820 "2018-01-04T17:47:56Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [January 4, 2018, 5:47pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/1 "2018-01-04T17:47:56Z")

</div>

**Background**

The current system has a few standard reports and offers no ability to change them except by someone versed in the code.

We need to have a report generator for the users. The users need to be able to use a drag and drop approach to creating their own reports. The user will need the Ability specify the type of output for the report generator CSV, PDF are a couple of examples.

**Technical requirements**

1. Mysql
2. PHP
3. Jquery
4. Html
5. CSS

**Submission**

1. The student will need to submit a series of PR’s for the report generator.

**Mentors:** @aethelwulffe @tony @teryhill

---

<div class="post-metadata">

**Author:** ![aethelwulffe](https://forums.librehealth.io/user_avatar/forums.librehealth.io/aethelwulffe/32/63_2.png) [@aethelwulffe](https://forums.librehealth.io/u/aethelwulffe)\
**Post date:** [January 13, 2018, 8:16pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/2 "2018-01-13T20:16:30Z")

</div>

Adaptability: I think the right approach to make it self-maintaining is for it to parse the table schemas and make those elements available. This will immediately give some minimal utility for making simple one-table reports. Add column order sorting and exports, and you have something useful already. Add direct editing capability, and you have a tool.

---

<div class="post-metadata">

**Author:** ![dhruv-chauhan](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/d/e47774/32.png) [@dhruv-chauhan](https://forums.librehealth.io/u/dhruv-chauhan)\
**Post date:** [January 18, 2018, 6:43pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/3 "2018-01-18T18:43:39Z")

</div>

Hi, I would like to take up this project. I’d like the mentors to give me a start on this one.

---

<div class="post-metadata">

**Author:** ![Abhinav](https://forums.librehealth.io/user_avatar/forums.librehealth.io/abhinav/32/626_2.png) [@Abhinav](https://forums.librehealth.io/u/Abhinav)\
**Post date:** [January 19, 2018, 12:24pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/4 "2018-01-19T12:24:55Z")

</div>

Hi!! I am interested in your project and fit for it because I recently created a website for my college…that’s why i am in hot working state!! I kindly request mentors to provide me with detailed information and guidelines at my email [abhinavsingh22@hotmail.com](mailto:abhinavsingh22@hotmail.com) so that I could start working for it from now only.

Thank You !!

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [January 19, 2018, 3:49pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/5 "2018-01-19T15:49:09Z")

</div>

It is up to the GSoC participant to formulate the proposal based on the project. You will choose the tools, and out line a time line and scope of work.

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 13, 2018, 4:15pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/6 "2018-02-13T16:15:02Z")

</div>

Hello @teryhill I want to know more about the project means its specifications and begin with the project under your guidance. Please help

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 4:31pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/7 "2018-02-13T16:31:08Z")

</div>

We are looking for a “Drag and Drop” report generating tool. The software currently has no means for the user to design and implement their own reports. We would like to have a report repository where the user can build , store and execute their reports .

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 13, 2018, 4:34pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/8 "2018-02-13T16:34:22Z")

</div>

Means can it have its own UI and woking type? How can I start with it? Should I use any framework or language or any specific?

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 4:38pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/9 "2018-02-13T16:38:30Z")

</div>

The code base is in PHP, JS, HTML, CSS . IT is preferred that the code be native PHP when possible. This could be built as a self contained module. I would suggest that you use the Chat for this as you will be limited to the number of reply’s you can make here. [https://chat.librehealth.io/channel/gsoc](https://chat.librehealth.io/channel/gsoc)

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 13, 2018, 4:43pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/10 "2018-02-13T16:43:04Z")

</div>

Okay sure. I have started with this project and will update you with this regularly.I will try to make a better application to use and include all desired features. Looking forward for your guidance.

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 4:45pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/11 "2018-02-13T16:45:27Z")

</div>

Would be glad to look at your proposal and project design. We do require that you contribute code before we can evaluate your proposal for GSoC so look at the issues on github.

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 13, 2018, 4:48pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/12 "2018-02-13T16:48:25Z")

</div>

@teryhill I have cloned the repo and started writing code for it. Should I pull and push the code in the GitHub repository directly?  
And one more thing can I change the UI of the report generator section?

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 5:13pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/13 "2018-02-13T17:13:09Z")

</div>

yes use github. We don’t currently have a report generation section for LibreHealthEHR

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 5:15pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/14 "2018-02-13T17:15:45Z")

</div>

Use branches for github

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 13, 2018, 5:15pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/15 "2018-02-13T17:15:56Z")

</div>

@teryhill I will give you the regular updates on this as I will work continuously and with true hard work for this project. And also I will push the code in GitHub repo as the tasks are done.

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 13, 2018, 5:18pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/16 "2018-02-13T17:18:10Z")

</div>

This is a GSoC project, you must submit a proposal to do the work. There are others that want to do this also. Look at the current issues on the github account and see if you want/can fix any of them.

---

<div class="post-metadata">

**Author:** ![pri2si17](https://forums.librehealth.io/user_avatar/forums.librehealth.io/pri2si17/32/1320_2.png) [@pri2si17](https://forums.librehealth.io/u/pri2si17)\
**Post date:** [February 13, 2018, 5:46pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/17 "2018-02-13T17:46:57Z")

</div>

HI @NirmalKumarJoshi , its good that you are planning to do this project. But listen to what @teryhill is saying. You need to submit a proposal for this and then you can proceed according to your drafted proposal. So that is another process, not go into it right now. What we want from you is :

1. Become an active member of community. (Ask where you get stuck and help others if they face any issue.)
2. Show us your tech skills. For this you can clone our github repo and start fixing issues listed in issue tracker.

After that, you need to submit proposal for whatever you want (lets consider this only), and if that proposal got selected, work on it. Hope this clears. 🙂

---

<div class="post-metadata">

**Author:** ![aethelwulffe](https://forums.librehealth.io/user_avatar/forums.librehealth.io/aethelwulffe/32/63_2.png) [@aethelwulffe](https://forums.librehealth.io/u/aethelwulffe)\
**Post date:** [February 13, 2018, 6:42pm UTC](https://forums.librehealth.io/t/project-report-generator/1820/18 "2018-02-13T18:42:14Z")

</div>

Report generator will have to be a native JS application, unless it is an external builder tool. I would not want to tell a hard-core C++ dev that they could not build an external tool for creating the form code. Power and speed are very important. Compiled C is a lot better for this sort of thing than a web-resource…but there are many approaches that can be used.

This is not necessarily a nail. It could be thought of as a screw or a bolt. If you use screwdrivers or wrenches instead of a hammer, please use that tool. 🕶

Also important to note: This is CLOSELY associated with the need for a REPORT GENERATOR. EDIT: I mean FORM GENERATOR…

---

<div class="post-metadata">

**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\
**Post date:** [February 18, 2018, 1:24am UTC](https://forums.librehealth.io/t/project-report-generator/1820/19 "2018-02-18T01:24:35Z")

</div>

Issue 998 has some things that can be done to prepare for this project. @NirmalKumarJoshi

---

<div class="post-metadata">

**Author:** ![NirmalKumarJoshi](https://forums.librehealth.io/letter_avatar_proxy/v4/letter/n/9e8a1a/32.png) [@NirmalKumarJoshi](https://forums.librehealth.io/u/NirmalKumarJoshi)\
**Post date:** [February 23, 2018, 9:58am UTC](https://forums.librehealth.io/t/project-report-generator/1820/20 "2018-02-23T09:58:33Z")

</div>

I am working on it. I will update you soon.

[Next page](https://forums.librehealth.io/t/project-report-generator/1820.md?page=2)
