Viewing 15 posts - 826 through 840 (of 1,957 total)
Thanks Brandie.
June 21, 2013 at 5:37 am
steve.ledridge (6/20/2013)
As a side note, I also came up with some T-SQL that will generate HTML Charts using Google Charts.
That is very nice - thanks for sharing :w00t:
June 20, 2013 at 5:54 pm
GilaMonster (6/20/2013)
No, not at all.They're two ways of stating the same thing, they perform and execute identically.
Isn't it true to say that they can be functionally different, in that...
June 20, 2013 at 5:44 pm
Well, no that doesn't help in this case.
I understand the required result, but the sample data is lacking anything to ORDER by to get that result.
You cannot rely on...
June 20, 2013 at 12:29 am
It seems you have possibly over simplified your example - there is no way to ORDER the rows to give you the correct values.
As the solution will depend a lot...
June 19, 2013 at 6:26 pm
SQLDCH (6/19/2013)
Thanks MM.
You are welcome 🙂
June 19, 2013 at 6:22 pm
Put the two bottom tables inside a rectangle.
June 19, 2013 at 12:43 pm
Let's try something, attached is a working report with column numbering.
It uses inline XML data, so no need to connect to SQL to run it, just open the project and...
June 18, 2013 at 4:11 pm
Is your dataset called Dataset1? If not, you need to change that.
Can you paste here the exact expression you are using?
June 18, 2013 at 1:08 pm
mahler9 (6/18/2013)
June 18, 2013 at 9:54 am
Ah, it may be a new feature of 2012 then...sorry hadn't noticed that.
Maybe there will be another way...
June 18, 2013 at 9:41 am
SQL_Surfer (6/14/2013)
June 14, 2013 at 5:51 pm
I got something to work - try this:
Select your "SalesOrder" column/field in the matrix and insert a row "inside group - above" and add this expression (edited to suit...
June 14, 2013 at 5:39 pm
Sorry, I see now - you will have orders that span multiple rows and rows that span multiple orders...so the row_number won't help...but I have an idea...
I will let you...
June 14, 2013 at 5:19 pm
Yes, it sounds like adding something like
ROW_NUMBER() OVER(PARTITION BY ZN,Bin,Item ORDER BY [Order Number]) as [Column Number]
...but you still haven't said what order the columns (order numbers) are in,...
June 14, 2013 at 11:48 am
Viewing 15 posts - 826 through 840 (of 1,957 total)