I tried that, but I guess I didn't do it right. Does my table only need the following?
Month
'2003-01-01'
'2003-02-01'
'2003-03-01'
or do I have to do this pairing with every person I have?
My report has Month as the Horizontal Column and 4 Summary calculations as the Row (labels) and is grouped by Person. In order to maintain a visual appeal, I would like the report to create the entire 12 month crosstab, regardless of if there is data for that column-row intersection.
Current...
Is it possible to run an Update query using the OPENRECORDSET function?
Here is my SQL:
SELECT c.maxofpims_bacrr
FROM t_highrisk_summary_complete AS c INNER JOIN
OPENROWSET('MSDAORA','Edwina';'rrichardet';'rrichardet',
'update t_pimsdata
set riskrtg = c.maxofpims_bacrr...
The other crosstab reports are not linked subreports. They all use the same datasource. I had to create several crosstabs in order to break the results into varying criteria summaries.
Is it not possible to create selection criteria for each cross-tab?
I need to have selection criteria on a cross-tab report. I cannot use the Select Expert because there are other cross-tab reports on the same report. For this particular cross-tab I need it to only include records that have a status of 'CL'. I probably need to create 2 formulas, one a...
Is there a way to label the summarized fields in a crosstab report? I have the following report
2001-11 2001-12 Total
Purchases ($) 33 33 66
Company ($) 3 3 6
* 1.50 1.50 .75...
Thanks so much for your suggestions. I was able to get what I wanted by simply using multiple crosstabs. After I got the grouping part down, it was easy! Thanks again :-)
I'm not even sure if a cross-tab is the right solution, but I need a report that looks like this:
11-2001 12-2001 Total
Open Companies 20 10 30
Open Accounts 40 5 45
Active Companies 10...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.