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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-04-14 : 12:09:40
|
| I just found out yesterday that my reports with its subreport can't be exported to excel. Only the main report can be exported. This kind of sucks. |
|
|
jhermiz
3564 Posts |
Posted - 2005-04-14 : 16:18:55
|
quote:
Originally posted by chriskhan2000
I just found out yesterday that my reports with its subreport can't be exported to excel. Only the main report can be exported. This kind of sucks.
Why do so many people use sub reports when you can avoid them?If you have a sub report it means you have a one to many relationship, or even your one to one relationship.So if you group by the parent, why cant you set the child records to the details section? And it doesn't stop there, you can tell RS that you have more then one details section by inserting detail groups.I've run into limitations with sub reports from the days of crystal reports. I try to avoid them by tightening my queries and making good use of grouping records.Why are you using sub reports ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
chriskhan2000
Aged Yak Warrior
544 Posts |
Posted - 2005-04-18 : 11:23:10
|
| Jeff reason why I use subreports is for referencing object fields. I can't seem to figure this out with the query level so only thing I can come up with is using object fields from main report field referencing subreport. However, I had been working with temp table and then updating it, so this subreport issue will probably go away. |
|
|
|
|
|
|
Subreport can't be exported to Excel!!