Wednesday, November 29
Group Number in SQL Reporting Services
Found this after lot of searching.
I was grouping data in a table in a SQL report. I could successfully add row numbers to the details of the group but was unable to add row numbers to group header.
Something like this
1 ClaimID1
2 ClaimID2
3 ClaimID3
=RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)
I was grouping data in a table in a SQL report. I could successfully add row numbers to the details of the group but was unable to add row numbers to group header.
Something like this
1 ClaimID1
1
2
3
2 ClaimID2
1
2
3
4
5
3 ClaimID3
1The following expression helped adding the row number for the groups
=RunningValue(Fields!ClaimID.Value, CountDistinct, Nothing)
Friday, November 3
javascript Trim method
Javascript has no trim() method that is required all the time.
This script will strip starting and ending spaces for you..
This script will strip starting and ending spaces for you..
72 // JScript File
73 //javascript left & right trim similar to stringObj.Trim() in C#
74 function trimAll(sString) 75 { 76 while (sString.substring(0,1) == ' ')
77 { 78 sString = sString.substring(1, sString.length); 79 } 80 while (sString.substring(sString.length-1, sString.length) == ' ')
81 { 82 sString = sString.substring(0,sString.length-1); 83 } 84 return sString;
85 } 
Subscribe to Posts [Atom]