Spiceworks Reports

[timbo343]

Is there anyone on here that uses the Spiceworks reporting feature.

 

Is it me or is it soooo chuffing awful.

 

We have hacked an instance of Spiceworks to serve as our Accident Database. I thought it would provide us with betterreports than what we have been doing in Access - how wrong was I. The first aiders love how simple it is though in terms of logging accidents, much easier than when it was in access however the real issue i have is generating and configuring reports to make them look at least, half decent!

 

When we export them to PDF, it produces pages upon pages of data which could be formatted to look like a proper report - has anyone managed to to this?

 

Export to XLS and creating Pivot Tables doesn't make sense on what i want to achieve as we requiire the description field.

 

I've installed SQLite ODBC driver to connect my machine to the spiceworks database however this is just bringing the information from SPICEWORKS to Access so i have to re-create all the reports again, plus i'm not able to do some of the custom FORM searches either as i cannot access the individual tables like i could in ACCESS.

 

Is anyone able to help?

[FishCustard]

You can run SQL queries against the Spiceworks database directly: https://community.spiceworks.com/support/desktop/troubleshooting/sql-reports

[timbo343]

I know SQL commands can work however i've asked the question already on Spiceworks but noone has come up with the answer i am looking for - https://community.spiceworks.com/topic/2188922-reports-from-helpdesk-tickets-pdf-layouts?page=1#entry-8190326. There is a jpg on this page, this is what we already have in access however i would like it to look nearly the same in spiceworks but i don't think it's possible.

 

I have a feeling that we are going to have to revert back to the access database.

[FishCustard]

You can add a SQL DB as a data source in Access can't you? Can you then just use the exact same Access reports but talk directly to the SQL DB?

[timbo343]

Thats what ive done but spiceworks doesnt have the individual tables for location / cause of accident / injury etc.

 

All these are in onr big table called tickets.

[timbo343]

Maybe i need to rethink hoe im going to do it [emoji848]

[FishCustard]

Either way you'll have to redesign the reports, but at least if you connect the DB to Access you can use the system(s) you're familiar with.

[timbo343]

Access is connected to spiceworks however im unable to create a list box of all the custom fields we have as im unable to find the tables that house these.

 

It would seem these are all stored in tickets as columns rather than tables.