locked
How do I add additional columns? RRS feed

  • Question

  • 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.

    Monday, April 18, 2011 6:24 PM

Answers

  • 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
    • Marked as answer by Craig Giles Tuesday, April 19, 2011 1:15 PM
    Monday, April 18, 2011 7:57 PM

All replies

  • 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

    “Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)”

    Please click the Mark as Answer button if a post solves your problem!

    Monday, April 18, 2011 6:50 PM
  • 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
    Monday, April 18, 2011 6:53 PM
  • 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.

    Monday, April 18, 2011 7:32 PM
  • 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
    • Marked as answer by Craig Giles Tuesday, April 19, 2011 1:15 PM
    Monday, April 18, 2011 7:57 PM
  • 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.

    Tuesday, April 19, 2011 1:59 PM