| Sign In/My Account | View Cart |
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.
|
||
| Privacy Policy > View Sample Newsletter > |
800-889-8969 or 707-827-7019 Monday-Friday 7:30am-5pm PT ©2011, O'Reilly Media, Inc. All trademarks and registered trademarks appearing on oreilly.com are the property of their respective owners. |
|