|
|
You're in the
sql server data warehouse
group:Line Numbers in SQL
sql server data warehouse:
line number of the row is? i.e. in Oracle you can do something like (Been a year since I've used Oracle) select rownum, Field1, Field2 from blah Any help is appreciated. Thanks.
No, you could do something with a temp table and IDENTITY. I believe Yukon
has the rownumber function. What do you need it for? -- Ray Higdon MCSE, MCDBA, CCNA --- [quoted text, click to view] "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > Is there a function I can put into my select clause that tell me what the > line number of the row is? > > i.e. in Oracle you can do something like (Been a year since I've used > Oracle) > > select rownum, Field1, Field2 > from blah > > Any help is appreciated. Thanks. > >
It's the only way I can think of to alternate row colors in reporting
services.... [quoted text, click to view] "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > No, you could do something with a temp table and IDENTITY. I believe Yukon > has the rownumber function. What do you need it for? > > -- > Ray Higdon MCSE, MCDBA, CCNA > --- > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > Is there a function I can put into my select clause that tell me what the > > line number of the row is? > > > > i.e. in Oracle you can do something like (Been a year since I've used > > Oracle) > > > > select rownum, Field1, Field2 > > from blah > > > > Any help is appreciated. Thanks. > > > > > >
you should have a look at the subject "row style in matrix" in
microsoft.public.sqlserver.reportingsvcs Jean-Philippe. "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans le message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... [quoted text, click to view] > It's the only way I can think of to alternate row colors in reporting > services.... > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > No, you could do something with a temp table and IDENTITY. I believe Yukon > > has the rownumber function. What do you need it for? > > > > -- > > Ray Higdon MCSE, MCDBA, CCNA > > --- > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > Is there a function I can put into my select clause that tell me what > the > > > line number of the row is? > > > > > > i.e. in Oracle you can do something like (Been a year since I've used > > > Oracle) > > > > > > select rownum, Field1, Field2 > > > from blah > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > >
I don't seem to have a message with that title and the newsgroup is not in
Google groups yet... [quoted text, click to view] "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > you should have a look at the subject "row style in matrix" in > microsoft.public.sqlserver.reportingsvcs > Jean-Philippe. > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans le > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > It's the only way I can think of to alternate row colors in reporting > > services.... > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > No, you could do something with a temp table and IDENTITY. I believe > Yukon > > > has the rownumber function. What do you need it for? > > > > > > -- > > > Ray Higdon MCSE, MCDBA, CCNA > > > --- > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > message > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > Is there a function I can put into my select clause that tell me what > > the > > > > line number of the row is? > > > > > > > > i.e. in Oracle you can do something like (Been a year since I've used > > > > Oracle) > > > > > > > > select rownum, Field1, Field2 > > > > from blah > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > >
Nothing there, either..
Doesn't come up in search. [quoted text, click to view] "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message news:eKr4rHL9DHA.400@tk2msftngp13.phx.gbl... > See here - http://www.microsoft.com/sql/community/newsgroups/default.asp > > -- > Ray Higdon MCSE, MCDBA, CCNA > --- > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl... > > I don't seem to have a message with that title and the newsgroup is not in > > Google groups yet... > > > > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message > > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > > > you should have a look at the subject "row style in matrix" in > > > microsoft.public.sqlserver.reportingsvcs > > > Jean-Philippe. > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans > le > > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > > > It's the only way I can think of to alternate row colors in reporting > > > > services.... > > > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > > > No, you could do something with a temp table and IDENTITY. I believe > > > Yukon > > > > > has the rownumber function. What do you need it for? > > > > > > > > > > -- > > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > > --- > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > > > message > > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > > > Is there a function I can put into my select clause that tell me > > what > > > > the > > > > > > line number of the row is? > > > > > > > > > > > > i.e. in Oracle you can do something like (Been a year since I've > > used > > > > > > Oracle) > > > > > > > > > > > > select rownum, Field1, Field2 > > > > > > from blah > > > > > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
See here - http://www.microsoft.com/sql/community/newsgroups/default.asp
-- Ray Higdon MCSE, MCDBA, CCNA --- [quoted text, click to view] "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl... > I don't seem to have a message with that title and the newsgroup is not in > Google groups yet... > > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > > you should have a look at the subject "row style in matrix" in > > microsoft.public.sqlserver.reportingsvcs > > Jean-Philippe. > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans le > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > > It's the only way I can think of to alternate row colors in reporting > > > services.... > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > > No, you could do something with a temp table and IDENTITY. I believe > > Yukon > > > > has the rownumber function. What do you need it for? > > > > > > > > -- > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > --- > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > > message > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > > Is there a function I can put into my select clause that tell me > what > > > the > > > > > line number of the row is? > > > > > > > > > > i.e. in Oracle you can do something like (Been a year since I've > used > > > > > Oracle) > > > > > > > > > > select rownum, Field1, Field2 > > > > > from blah > > > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Nothing there? I just went to it, it's toward the bottom of the page, search
for "reporting services" -- Ray Higdon MCSE, MCDBA, CCNA --- [quoted text, click to view] "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message news:uVp1YYL9DHA.2712@tk2msftngp13.phx.gbl... > Nothing there, either.. > > Doesn't come up in search. > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > news:eKr4rHL9DHA.400@tk2msftngp13.phx.gbl... > > See here - http://www.microsoft.com/sql/community/newsgroups/default.asp > > > > -- > > Ray Higdon MCSE, MCDBA, CCNA > > --- > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > > news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl... > > > I don't seem to have a message with that title and the newsgroup is not > in > > > Google groups yet... > > > > > > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message > > > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > > > > you should have a look at the subject "row style in matrix" in > > > > microsoft.public.sqlserver.reportingsvcs > > > > Jean-Philippe. > > > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit dans > > le > > > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > > > > It's the only way I can think of to alternate row colors in > reporting > > > > > services.... > > > > > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > > > > No, you could do something with a temp table and IDENTITY. I > believe > > > > Yukon > > > > > > has the rownumber function. What do you need it for? > > > > > > > > > > > > -- > > > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > > > --- > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > > > > message > > > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > > > > Is there a function I can put into my select clause that tell me > > > what > > > > > the > > > > > > > line number of the row is? > > > > > > > > > > > > > > i.e. in Oracle you can do something like (Been a year since I've > > > used > > > > > > > Oracle) > > > > > > > > > > > > > > select rownum, Field1, Field2 > > > > > > > from blah > > > > > > > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
you should have a look at the subject "row style in matrix" in
[quoted text, click to view] > > microsoft.public.sqlserver.reportingsvcs That is what I'm looking up in that newsgroup. I can find the reporting services newsgroup. [quoted text, click to view] "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message news:%23yp%23tcL9DHA.548@TK2MSFTNGP11.phx.gbl... > Nothing there? I just went to it, it's toward the bottom of the page, search > for "reporting services" > > -- > Ray Higdon MCSE, MCDBA, CCNA > --- > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > news:uVp1YYL9DHA.2712@tk2msftngp13.phx.gbl... > > Nothing there, either.. > > > > Doesn't come up in search. > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > news:eKr4rHL9DHA.400@tk2msftngp13.phx.gbl... > > > See here - http://www.microsoft.com/sql/community/newsgroups/default.asp > > > > > > -- > > > Ray Higdon MCSE, MCDBA, CCNA > > > --- > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > message > > > news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl... > > > > I don't seem to have a message with that title and the newsgroup is > not > > in > > > > Google groups yet... > > > > > > > > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message > > > > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > > > > > you should have a look at the subject "row style in matrix" in > > > > > microsoft.public.sqlserver.reportingsvcs > > > > > Jean-Philippe. > > > > > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit > dans > > > le > > > > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > > > > > It's the only way I can think of to alternate row colors in > > reporting > > > > > > services.... > > > > > > > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > > > > > No, you could do something with a temp table and IDENTITY. I > > believe > > > > > Yukon > > > > > > > has the rownumber function. What do you need it for? > > > > > > > > > > > > > > -- > > > > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > > > > --- > > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote > in > > > > > message > > > > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > > > > > Is there a function I can put into my select clause that tell > me > > > > what > > > > > > the > > > > > > > > line number of the row is? > > > > > > > > > > > > > > > > i.e. in Oracle you can do something like (Been a year since > I've > > > > used > > > > > > > > Oracle) > > > > > > > > > > > > > > > > select rownum, Field1, Field2 > > > > > > > > from blah > > > > > > > > > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Ah, OK.
I use NNTP and searched and found it, this is the excerpt: (See below) You will need to add an expression the outer most row grouping on the matrix. The attached sample report demonstrates how to do this. Key Areas: * Matrix Properties Dialog : Groups Tab : Country Group has an expression on it that controls the number of rows: =System.Math.Ceiling(RowNumber(Nothing)/5) * Place a PageBreakAtEnd on the Matrix Properties Dialog : Groups Tab : Country Group. NOTE: There is a bug on this dialog in RTM version. The checkboxes to set PageBreakAt[Start | End] are missing. You will need to hand edit the RDL to get this to work. Before proceeding backup your RDL. The code snippet shows where the PageBreakAtEnd tag was added to the RDL: <Grouping Name="matrix1_Country"> <GroupExpressions> <GroupExpression>=System.Math.Ceiling(RowNumber(Nothing)/5)</GroupExpression [quoted text, click to view] > </GroupExpressions><PageBreakAtEnd>true</PageBreakAtEnd> <<<<<< Tag added here. </Grouping> -- Bruce Johnson [MSFT] Microsoft SQL Server Reporting Services This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Avi" <anonymous@discussions.microsoft.com> wrote in message news:B9A6926F-2CBD-4C40-9471-49422C3EA39E@microsoft.com... > Hi > Is there any way by which I can specify the number of rows to be displayed on one page in matrix? > Suppose I want only 10 rows to be displyed on one page irrespective of collapsed or expanded state of the groups. > How do I achieve this? > > -Avi -- Ray Higdon MCSE, MCDBA, CCNA --- [quoted text, click to view] "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message news:OeKWKlO9DHA.3704@tk2msftngp13.phx.gbl... > you should have a look at the subject "row style in matrix" in > > > microsoft.public.sqlserver.reportingsvcs > > That is what I'm looking up in that newsgroup. I can find the reporting > services newsgroup. > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > news:%23yp%23tcL9DHA.548@TK2MSFTNGP11.phx.gbl... > > Nothing there? I just went to it, it's toward the bottom of the page, > search > > for "reporting services" > > > > -- > > Ray Higdon MCSE, MCDBA, CCNA > > --- > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in message > > news:uVp1YYL9DHA.2712@tk2msftngp13.phx.gbl... > > > Nothing there, either.. > > > > > > Doesn't come up in search. > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > news:eKr4rHL9DHA.400@tk2msftngp13.phx.gbl... > > > > See here - > http://www.microsoft.com/sql/community/newsgroups/default.asp > > > > > > > > -- > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > --- > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> wrote in > > message > > > > news:%23k0kO%23K9DHA.4060@tk2msftngp13.phx.gbl... > > > > > I don't seem to have a message with that title and the newsgroup is > > not > > > in > > > > > Google groups yet... > > > > > > > > > > "Jean Philippe Vankemmel" <vankemjp@ifrance.com> wrote in message > > > > > news:%23zh0zZG9DHA.452@TK2MSFTNGP11.phx.gbl... > > > > > > you should have a look at the subject "row style in matrix" in > > > > > > microsoft.public.sqlserver.reportingsvcs > > > > > > Jean-Philippe. > > > > > > > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> a écrit > > dans > > > > le > > > > > > message de news:eDztD6e8DHA.2404@TK2MSFTNGP12.phx.gbl... > > > > > > > It's the only way I can think of to alternate row colors in > > > reporting > > > > > > > services.... > > > > > > > > > > > > > > "Ray Higdon" <sqlhigdon@nospam.yahoo.com> wrote in message > > > > > > > news:%233NMuic8DHA.1548@tk2msftngp13.phx.gbl... > > > > > > > > No, you could do something with a temp table and IDENTITY. I > > > believe > > > > > > Yukon > > > > > > > > has the rownumber function. What do you need it for? > > > > > > > > > > > > > > > > -- > > > > > > > > Ray Higdon MCSE, MCDBA, CCNA > > > > > > > > --- > > > > > > > > "Scott Meddows" <scott_meddows_no_spm@tsged-removeme.com> > wrote > > in > > > > > > message > > > > > > > > news:uTDWhna8DHA.1052@TK2MSFTNGP12.phx.gbl... > > > > > > > > > Is there a function I can put into my select clause that > tell > > me > > > > > what > > > > > > > the > > > > > > > > > line number of the row is? > > > > > > > > > > > > > > > > > > i.e. in Oracle you can do something like (Been a year since > > I've > > > > > used > > > > > > > > > Oracle) > > > > > > > > > > > > > > > > > > select rownum, Field1, Field2 > > > > > > > > > from blah > > > > > > > > > > > > > > > > > > Any help is appreciated. Thanks. > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
January 2003
March 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |