# HOW TO allow for user-created/modified reports?

**URL:** <https://forum.servoy.com/t/how-to-allow-for-user-created-modified-reports/930>\
**Category:** Classic Servoy\
**Created:** [December 31, 2003, 6:54pm UTC](https://forum.servoy.com/t/how-to-allow-for-user-created-modified-reports/930 "2003-12-31T18:54:58Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![chris](https://avatars.discourse-cdn.com/v4/letter/c/958977/32.png) [@chris](https://forum.servoy.com/u/chris)\
**Post date:** [December 31, 2003, 6:54pm UTC](https://forum.servoy.com/t/how-to-allow-for-user-created-modified-reports/930/1 "2003-12-31T18:54:58Z")

</div>

We are considering using Servoy to connect to a SQL database tracking manufacturing operations (BellHawk). The managers want to be able to create quick and easy reports showing trends of machine usage, productivity, etc, WITHOUT calling up a developer each time to configure the report. In Servoy, how would I, as the developer, set up their solution so all of it is locked except a reporting file in which managers can make their reports?

I’m coming from FM in which I’d use the SQL plugin to pull the data in (this file would be locked) and then export the data out to another table that would be open for users to play with, create reports, mess up, etc.

Thank you!

---

<div class="post-metadata">

**Author:** ![Jan\_Aleman](https://avatars.discourse-cdn.com/v4/letter/j/4af34b/32.png) [@Jan\_Aleman](https://forum.servoy.com/u/Jan_Aleman)\
**Post date:** [December 31, 2003, 7:25pm UTC](https://forum.servoy.com/t/how-to-allow-for-user-created-modified-reports/930/2 "2003-12-31T19:25:59Z")

</div>

Have a look at the report sections in the demo crm, the buttons at the bottom give you access to various ways of building dynamic reports. NOTE: they are just implemented as very basic demos to demonstrate it CAN be done, they are not entirely error free and user friendly but if you integrate it into your solution that could be done fairly easily.

---

<div class="post-metadata">

**Author:** ![chris](https://avatars.discourse-cdn.com/v4/letter/c/958977/32.png) [@chris](https://forum.servoy.com/u/chris)\
**Post date:** [December 31, 2003, 8:05pm UTC](https://forum.servoy.com/t/how-to-allow-for-user-created-modified-reports/930/3 "2003-12-31T20:05:10Z")

</div>

Thank you - but the crm solution seems to show how users can construct custom queries and that’s pretty cool - but the question I had is about forms/layouts - about users manipulating form parts, putting their logo in different places, summarizing data in different ways. As I understand, users can select fields using the SELECT statement and can probably do all sub-summarizing also using SQL statements (is this the case?), but what about formatting?

Thank you.