Matrix Formatting

[SgtJarrow]

Anyone know if it is possible to display ALL columns that are the source of a matrix control???

I have something we call a Distribution Drive Report. This displays all promotional items sold over a period of time. What I am looking to do is create a "blank" at the beginning of the period. So I want to show all columns - even if there is no data for every row for that column.

Something like:

             1102  1103  1104  1105  1006
Cust1
Cust2
Cust3
Cust4
[code]

Right now, I get nothing...and even over the period, if I run the report, I may only see the following:

[code]
            1102  1103  1106
Cust1         1
Cust2              1      1
Cust3              1
Cast4         1
[code]

I want to include ALL columns - no matter what.  Either forcing this through SQL or SSRS matrix control.  Any ideas???

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer

 

[xlbo]

Best bet is to do it in the SQL - cross join with ISNULL(field,Default) might do the trick but depends on the nature of the query

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SgtJarrow]

Thanks. I'll move over to the SQL forum and see if anyone can help me there.

=======================================
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
CCNA, CCDA, MCSA, CNA, Net+, A+, CHDP
VB/Access Programmer