Visual Report Builder

Hi Everyone,

I'm looking for a library that allows end-users to create simple reports using the Eloquent Models visually. Ideally, this library would not require any coding from my end-user. Simple tables are fine, but graphs would also be nice to have. I'm fairly new to Laravel (within the last three or so months), so I apologize if there is a glaringly obvious choice here that I've missed in my Google searches.

Thanks! Marc

jlrdw

2 years ago

Best Answer

Level 75

I would say most reporting is SQL / PDO. Like Accounts Receivable reports. Most average users would have no idea how to do a report. There are visual database relations designers, but you still have to write some SQL.

It's best to pre-design several reports that will be ran say monthly and let the user click to run the report. You can have certain parameters the user enters.

I have never needed charts to tell me figures, for example, one month your expenses are 9000.00, your income 14000.00, I can pitcure that without a chart. But yes Accounting software like Quickbooks do have charts, but really not needed.

You can also chart in Nova and there is a series on Laracasts on charts. But I myself would not let or even trust an end user creating a report, but running a report is fine.

Just my opinion and suggestions.

onairmarc

2 years ago

Level 5

@jlrdw I completely agree with your opinion. That was my thought as well. Perhaps my original post could have been a bit more refined. I do plan on building out some standard reports for the end user. Some will accept user input, and some won't. Perhaps I'm looking for a report-building library that would make building the actual report easier to manage/maintain.

I'm open to any suggestions that you may have. Using Laravel has already tremendously improved my productivity, so part of the goal here is to learn what additional tools in Laravel exist for different use cases such as this.

Thanks!

jlrdw

2 years ago

Level 75

@onairmarc reports are normally summary reports or detail reports. Usually summary reports are the most common, but it's still SQL normally with joins and group by.

I have exported and used Microsoft Access in the past to help design reports for MySQL, another I have used is SQLeo.

But if you haven't yet take the free laravel training to start with.

1 like

Please or to participate in this conversation.