| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 115443 | 2011-01-18 21:29:00 | Software to generate/veiw SQL reports ? | 1101 (13337) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 1170818 | 2011-01-18 21:29:00 | 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 |
1101 (13337) | ||
| 1170819 | 2011-01-18 21:42:00 | 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: |
Erayd (23) | ||
| 1170820 | 2011-01-18 21:52:00 | 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. |
1101 (13337) | ||
| 1170821 | 2011-01-18 22:13:00 | 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. |
Erayd (23) | ||
| 1 | |||||