kwcowboy195612
asked on
Using one query to create multiple lists with different grade level in cognos
I am using one query to generate 5 lists within a table cells using grade level as the filters. My question is how to I make it work. My query has 4 columns. Year, Grade, Course, and Credit. I nee to filter on grade to create each seperate list.
You will need to explain this a WHOLE lot clearer to get the right help. Give us examples of the data in your table(s), and examples of what you expect to receive as output. Also, I don't get what you mean by 1 query giving you 5 lists? As I said, you need to provide more information. What you have stated is too vague.
ASKER
Data in the query below:
2009 English1 09 0.5
2009 English2 09 0.5
2010 Math 10 0.5
2010 History 10 0.5
2011 PE 11 0.5
2011 Math 11 0.5
2011 English2 11 0.5
2011 Reading 11 0.5
Lists are suppose to look like this:
Year Course Grade Credit Year Course Grade Credit Year Course Grade Credit
2009 English1 09 0.5 2010 Math 10 0.5 2011 Math 11 0.5
2009 English2 09 0.5 2010 History 10 0.5 2011 English2 11 0.5
2011 Reading 11 0.5
Since you have one query and if you use the query for these three lists, it would display all the value without a filter. So how do you make the lists about show using the data in the only query.
2009 English1 09 0.5
2009 English2 09 0.5
2010 Math 10 0.5
2010 History 10 0.5
2011 PE 11 0.5
2011 Math 11 0.5
2011 English2 11 0.5
2011 Reading 11 0.5
Lists are suppose to look like this:
Year Course Grade Credit Year Course Grade Credit Year Course Grade Credit
2009 English1 09 0.5 2010 Math 10 0.5 2011 Math 11 0.5
2009 English2 09 0.5 2010 History 10 0.5 2011 English2 11 0.5
2011 Reading 11 0.5
Since you have one query and if you use the query for these three lists, it would display all the value without a filter. So how do you make the lists about show using the data in the only query.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I had five queries and I was told to combine them but I have another issue and I will enter another ticket.