Recent content by narayanis

Thanks LB! Is it standard practice here to change a thread title to include [RESOLVED] at the beginning? I didn't see an option to edit my original post.

There are always two periods (current and prior). It is an integer field containing a 1 or 2. My column headers will be 'Current' and 'Past', so the field value corresponding to period 1 is in column A and the field value for the same show corresponding to period 2 is in column B. Since there...

Thanks for the quick response! I pondered that. So if I have five pieces of data, I insert five crosstabs into the report with the relevant summary for each, then use suppression to hide the extra bits? To complicate things, today I was given the additional requirement of a Variance column for...

I'm comparing aggregate data between a current period and a prior period. My stored proc does most of the work, so my results are like this (simplified for clarity): showdescr - period - headcount Gen Admission - 1 - 200 Gen Admission - 2 - 150 Can you point me to some resources that show the...