Recent content by rrichardet

Where would this function be inserted?

Please submit the solution so that we can all learn! Thanks.

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