Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2007-05-09 : 13:47:13
|
| Hi,I want to create a report from the multiple tables on SQL server, what is the best way to do it, I have crystal report 11 installed on my development PC, the application is vb6.Should I built the views in the database first, then just use crystal to format whatever I want. or should I create temp tables for reporting purpose?What is the normal / good way to do?The data need to extract from five different tables with relationaship.Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-05-09 : 13:53:46
|
| Some people will say to use a view, others will say just use a query.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-10 : 06:02:24
|
| Alternatively you can create procedure and have it as CR's datasourceMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
create reporting from tables?