PDA

View Full Version : Software to generate/veiw SQL reports ?



1101
19-01-2011, 10:29 AM
Hi there
Any suggestions for easy to use SQL report viewer that can generate/merge a single report from several SQL databases, all with identical fields
ie the different databases are just the different company city branches, but all on the same server.

Cheers

Erayd
19-01-2011, 10:42 AM
Which DBMS are we talking about here?

Do you know the necessary SQL dialect to write the queries yourself, or are you looking for something with a GUI query builder?

How many databases are you generating this report from? Are we talking single digits, or hundreds, or somewhere in between?

:pf1mobmini:

1101
19-01-2011, 10:52 AM
Sorry , I dont have alot of info on this. i was given minimum info & asked to
look into it.

Approx 10 databases, all using same software-just different database for each city branch.
Crystal Reports is installed, user finding it too hard to use.
He wants basic reports from all databases merged into one.

Erayd
19-01-2011, 11:13 AM
OK - and do you need a web interface for it, or is this just needed as a desktop application?

If you just need a basic desktop report and don't want to resort to scripting, then Access will handle this pretty easily, and provides a GUI for most common tasks.

Can you find out which DBMS is being used? Some allow for cross-database selects, and others don't. If yours does, it may make your life a bit simpler, depending on the tool you end up using.