How do I add additional columns?
I've got two tables that are linked. How do I add columns to the report. Some schools might only have one record in the database while others could have multiple.
April 18th, 2011 2:28pm

Additional columns can be added to the Dataset by re-writing the query to include other columns. Once these appear in the Dataset, refresh the fields and drag the columns to the report from the Dataset. I illustrate this in my webinar (next one to be held May 11-13th)__________________________________________________________________ William Vaughn Mentor, Consultant, Trainer, MVP http://betav.com http://betav.com/blog/billva http://www.hitchhikerguides.net Hitchhikers Guide to Visual Studio and SQL Server (7th Edition) Please click the Mark as Answer button if a post solves your problem!
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 2:50pm

To add more columns to a SSRS table just right click the table and choose add column... Then move the column name from the column list to the new table column. If you need to add more columns to a data set, you'd do that by in the query designer. Right click the data set name and choose query designer. Your 2nd sentence makes no sense... The number of records found for a particular school has nothing to do with the number of columns you have in a table... That is to say, columns and records have nothing to do with one and other.Jason Long
April 18th, 2011 2:53pm

I didn't explain it well. Using a INNER JOIN: Project.ProjectNumber = AdditionalFunding.ProjectNumber, some projects only have one record in additionl funding, while other could have mulitple. I'm not sure how to display if the project has multiple additional funding records. Also the reports selects all projects based on FYs.
Free Windows Admin Tool Kit Click here and download it now
April 18th, 2011 3:33pm

In that case create a new group on your table, based on the project number. Place any "project header" information in the group header and place the AdditionalFunding info in the details section. SSRS will display the necessary number of detail records under each progect number.Jason Long
April 18th, 2011 3:57pm

Of course they changed their mind. Currently the report is pulling a project row for each additional funding record. I want to only have one record in the report and add up all the additional funding values. Not sure how to make this happen.
Free Windows Admin Tool Kit Click here and download it now
April 19th, 2011 10:00am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics