Howdy,
I'm trying to create a crosstab type report that will display account activity (rows) by department (columns). I want to display the account and department even when there is no amount activity in a period.
Here's what I've tried.
I have the account and department values in two seperate tables, left outer joined to a report that has account and department values associated with a month's amount activity. I have the report checked to display null values and the crosstab checked and not to supress null values. None of this will display when a account/department shows no activity.
I've looked into isNull, but do not know (can't find) a good SQL statement that will help me out, and I don't really know which field to attach it to.
It seems like there is a solution to get these to display, based on the numerous threads in various forums that I've been looking at, but nothing has worked.
I started to do a manual crosstab, but got so close on the crosstab that I'm fixated on that solution at this point. If I can't make any progress with a formula or helpful tip, I guess I'll start over again trying to do a mock crosstab.
Long story short,
1. (Is there) what is the easiest way to get summarized fields to display a Null value when the column and row values are pulled from data tables?
1.b If there is a null formula to do so, what is the syntex (or can someone provide a link to such)?
2. If there isn't a way to do so in Crosstab, where can I find the best guide on how to draft a mock cross tab?
Thanks for your help!
-John
I'm trying to create a crosstab type report that will display account activity (rows) by department (columns). I want to display the account and department even when there is no amount activity in a period.
Here's what I've tried.
I have the account and department values in two seperate tables, left outer joined to a report that has account and department values associated with a month's amount activity. I have the report checked to display null values and the crosstab checked and not to supress null values. None of this will display when a account/department shows no activity.
I've looked into isNull, but do not know (can't find) a good SQL statement that will help me out, and I don't really know which field to attach it to.
It seems like there is a solution to get these to display, based on the numerous threads in various forums that I've been looking at, but nothing has worked.
I started to do a manual crosstab, but got so close on the crosstab that I'm fixated on that solution at this point. If I can't make any progress with a formula or helpful tip, I guess I'll start over again trying to do a mock crosstab.
Long story short,
1. (Is there) what is the easiest way to get summarized fields to display a Null value when the column and row values are pulled from data tables?
1.b If there is a null formula to do so, what is the syntex (or can someone provide a link to such)?
2. If there isn't a way to do so in Crosstab, where can I find the best guide on how to draft a mock cross tab?
Thanks for your help!
-John