Force Row population??

[DugzDMan]

I'm trying to create a report on customer usage. Basically, the report will have Time Frame, Jurisdiction, Usage, and a few other items.

Here's an example:

Time Frame  Jurisdiction   Usage  ...
Current           1         123
Current           2         456
31-60             1         234
31-60             2         345
61-90             1         234
61-90             2         345
...

The problem comes in when an account does not have both jurisdictions or all time frames. It might be something like this:

Time Frame  Jurisdiction   Usage  ...
Current           1         123
61-90             1         234
61-90             2         345
...

What I need to do is make sure there is an entry for each possibility, even if it is just 0.

Like this:

Time Frame  Jurisdiction   Usage  ...
Current           1         123
Current           2         0
31-60             1         0
31-60             2         0
61-90             1         234
61-90             2         345
...

I would think this would be fairly easy to do, but I couldn't figure it out.

Thanks for any help you can provide!!!
Doug

 

[skrandel]

You need 2 dataproviders.

1 for your data and 1 for the master list of time-frames and jurisdictions.

Your report should use the dimensions from 1 query and the measure from the other.

Steve Krandel
BASE Consulting Group

http://www.baseconsulting.com

 

[DugzDMan]

What all do I need to do in order to make sure they are compatible? Right now, I'm getting an error (DMB0008 - Variables are not compatible) when trying to add the items to a table.

Thanks!

 

[DugzDMan]

Maybe I am doing this wrong, but I am getting the same value throughout the column.

Instead of being like this:

Time Frame  Jurisdiction   Usage  ...
Current           1         123
Current           2         0
31-60             1         0
31-60             2         0

It is like this:

Time Frame  Jurisdiction   Usage  ...
Current           1         123
Current           2         123
31-60             1         123
31-60             2         123

Am I just forgetting to do something? I've tried this a few ways and keep getting the dame results.

Thanks for the help!!!!

 

[DugzDMan]

OK, I've messed with it some more, but can't get it to come out the way I "want" it to. I can get it to show me all times frames and jurisdictions, etc. The only problem is it displays a null value when there isn't a match between the two tables. This is fine when it is one the usage columns, I can just set it to display 0. But, when it is a character field, I need it to display the same field all the way through (i.e. ABC for each each time frame/jurisdiction combo for ABC). Also, ABC might be EFG or something else. Basically, in a block I'll need the information repeated, on the next block, it will change.

Am I just going about this the wrong way??

Thanks for the help!