April 6, 2011 at 2:50 am
I have a matrix on my report and need to find out which column number in the inner group level is being generated as I want to use it as the index number in array variables in code. I can find the column number in the outer row grouping and display it, but whenever I try and use that report item I get an error. I'm trying to use an expression that uses this value as a function argument at the first row grouping level.
e.g.
ColGroupA ColGroupB
a1 a2 a3 b1 b2 b3
colcnt 1 2 3 4 5 6 this is the row where I work out which column I am in
detail 1
detail 2
summary =Code.xxx(ColCnt) Expression at inner group total level using colcnt in argument
Does anyone have any thoughts on this? Many thanks.
Sue
April 6, 2011 at 12:50 pm
There are lots of people on here willing to help but we need something to go on. We are not familiar with your project and we can't see you screen. The explanation you presented it totally unclear what you are trying to do. Please view the link in my signature to understand how to go about posting a question in such a way that somebody will be able to help you.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy