Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2004
    Alpine Califormia

    Unanswered: Two Data Sources in RS

    Hi all I have yet another question. I need to have two dataset for a report that has two tables in it, now the reason being is because one table is to give totals for the shool year and the other table is to give totals for the summer school. so its going to be different totals in both tables. And each table has its own dataset. The user wants to see both totals for summer school and year round school. How do I do that??? Any advice would be greatly appreciated.
    Last edited by desireemm; 07-08-09 at 02:27.

  2. #2
    Join Date
    Nov 2004
    Provided Answers: 4
    Perhaps you could give us the DDl -scripts for both tables, some example data and the required result.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  3. #3
    Join Date
    Jun 2004
    Long Island
    I assume you want to UNION the results of each result set to one result set ?

    select classID, sum(whatever) from table1
    where schedule = 'regular'
    group by ClassID
    select classID, sum(whatever) from table2
    where schedule = 'summer'
    group by ClassID
    Last edited by PMASchmed; 07-08-09 at 08:17.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts