Generic Report Writer

Question

0.00/5 (No votes)

See more:

Hi all,
Does anyone know of a report writer that has an interface that can list all your tables/columns in a database and build up a query based on what you've selected and produce a csv file or something at the end?

Either open source or stand alone...?

Any ideas would be appreciated. I'd write something myself, but don't have much time and didn't want to reinvent the wheel if someone's done it already.

Thanks in advance

Julian

Posted 14-Sep-10 4:00am

julian@giant

Updated 14-Sep-10 4:01am

v2

Add a Solution

Comments

Sunasara Imdadhusen 14-Sep-10 10:20am

You can use Crystal Report or Microsoft's Data Report control to design excellent report with drag and drop.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Answer 1 · 2010-09-14T05:49:00

Have a look at Report Builder[^].

You can design your model and then a dataview over that model exposing all the tables. You can drag-drop the fields in tables, apply sorting, filtering etc. Once report is ready, you can print, export into various format.

Sample article explaining the creation step-by-step: Using Report Builder to build reports[^]

julian@giant · Answer 2 · 2010-09-14T06:12:00

Solution 2

Hi, thanks Sandeep, I think Report Builder is SQL Server specific, am I right in saying that?

We need to connect to an Alpha DB, so I was after a report writer that could connect to any database.

Cheers

J

Posted 14-Sep-10 6:12am