We've expanded our news coverage and improved our search! Visit
oreilly.com for the latest or search for all things across O'Reilly!
Article:
 |
|
Creating Cross Tab Queries in SQL Server
|
| Subject: |
|
CrossTab query issue |
| Date: |
|
2007-12-10 11:11:54 |
| From: |
|
jeffrhoads
|
|
|
|
Hello - I have created a crosstab query that I am using for an Aging Invoices Report. It's working great up until, for example, there are no invoices that fall into either of the categories (i.e. 91-120 days category) - the report then fails since it has the 4 columns on the report (1 for each of these: 30-60, 61-90, 91-120 and 121+ days). Is there a way I can return the column regardless of whether any data is selected or not? If the aging amount is zero (0.00) I still want the column returned so the report doesn't fail.
Thank you in advance for any help you can provide.
Regards,
JR
|
