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 |
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
 Posted - 2008-09-07 : 20:49:11
|
| I have a report with two tables; the second table returns many rows and one of the columns is number of events (eventcount). I then have the first table which has three columns for a summary. The 3 columns are, so I expect only one row to be returned:=Sum(Fields!EventCount.Value, "TotalSepDuration")=Min(Fields!EventCount.Value, "TotalSepDuration")=Max(Fields!EventCount.Value, "TotalSepDuration")I originally had the dataset name in the table properties for the first table set to TotalSepDuration which is my dataset for the second table however the first table then returns the same number of rows as returned in the second table with repeated data. I then changed the dataset for the first table to another dataset that is unrelated however only returns one row and now my first table only returns one row with the correct data.Is there a better way. This seems like a crappy solution?I tried first however this gives an error. You dont seem to be able to have no dataset name in properties for a table and sometimes you may not have another dataset that only returns one row.I am using VS2005 and reporting services. |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-08 : 01:20:56
|
| If I have understood you correctly, you should be able to do all your aggregate functions(Sum, Max,Min) using 1 table & 1 footer.Are you putting your aggregate functions (ie Sum, Min & Max) in the table footer? If not, try this. To add a table footer, right-mouse click on a row & the option is there. |
 |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-09-08 : 01:22:38
|
| Also - don't show any detail rows in your summary table- just the footer |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-09-09 : 02:19:13
|
| Maybe I was not being clear, I need a new table with summary details from another table due its location in the report. I dont want the summary to be in the same table (footer or header). Is there any other solutions? |
|
|
|
|
|
|
Dataset references