Search results for query: *

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...

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...

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...