|
|
You're in the
sql server reporting services
group:TOP 10
sql server reporting services:
I can't really do it on the SQL side aaron
You can do this by adding a "filter" to the group to only get "TOP N"
based on some field. Not sure on the exact semantics, but this should be close: Right-click on the group cell, and select "Edit Group". Then go to the "Filters" tab, choose the DataSet Field or expression you want to evaluate; then choose "Top N" as the Operator...then in the Value field, enter the number you want (i.e., 10 if you want the TOP 10).
Make sure to use =10 (which evaluates to an integer) instead of the string
constant 10 as filter value of the TopN filter. -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "kbr" <kbrandl@gmail.com> wrote in message news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > You can do this by adding a "filter" to the group to only get "TOP N" > based on some field. Not sure on the exact semantics, but this should > be close: > > Right-click on the group cell, and select "Edit Group". Then go to the > "Filters" tab, choose the DataSet Field or expression you want to > evaluate; then choose "Top N" as the Operator...then in the Value > field, enter the number you want (i.e., 10 if you want the TOP 10). >
thanks guys, i am so glad i can do this in RS, instead of needing to do this
on the DB side!!!! [quoted text, click to view] "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > Make sure to use =10 (which evaluates to an integer) instead of the string > constant 10 as filter value of the TopN filter. > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "kbr" <kbrandl@gmail.com> wrote in message > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > You can do this by adding a "filter" to the group to only get "TOP N" > > based on some field. Not sure on the exact semantics, but this should > > be close: > > > > Right-click on the group cell, and select "Edit Group". Then go to the > > "Filters" tab, choose the DataSet Field or expression you want to > > evaluate; then choose "Top N" as the Operator...then in the Value > > field, enter the number you want (i.e., 10 if you want the TOP 10). > > > >
Yes, it may be more convenient to do filtering in the report, but you have
to consider that the RS processing engine has to retrieve all the data and then apply the filter. This is less efficient than filtering the data on the database and therefore not transmitting and processing them. -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] <aaron_kempf@hotmail.com> wrote in message news:%234puRVv5EHA.1404@TK2MSFTNGP11.phx.gbl... > thanks guys, i am so glad i can do this in RS, instead of needing to do this > on the DB side!!!! > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > > Make sure to use =10 (which evaluates to an integer) instead of the string > > constant 10 as filter value of the TopN filter. > > > > -- > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > > > > "kbr" <kbrandl@gmail.com> wrote in message > > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > > You can do this by adding a "filter" to the group to only get "TOP N" > > > based on some field. Not sure on the exact semantics, but this should > > > be close: > > > > > > Right-click on the group cell, and select "Edit Group". Then go to the > > > "Filters" tab, choose the DataSet Field or expression you want to > > > evaluate; then choose "Top N" as the Operator...then in the Value > > > field, enter the number you want (i.e., 10 if you want the TOP 10). > > > > > > > > >
yeah... better than that changing my report to be a union with a different
TOP 10 clause for each section tho I am using MDX and i tihnk that it would be hard to do this via MDX MDX/OLAP is fast enough anyways, who cares if it's pulling 15 records and showing 10 right? -aaron [quoted text, click to view] "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message news:eUJsqZv5EHA.3124@TK2MSFTNGP11.phx.gbl... > Yes, it may be more convenient to do filtering in the report, but you have > to consider that the RS processing engine has to retrieve all the data and > then apply the filter. This is less efficient than filtering the data on the > database and therefore not transmitting and processing them. > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > > <aaron_kempf@hotmail.com> wrote in message > news:%234puRVv5EHA.1404@TK2MSFTNGP11.phx.gbl... > > thanks guys, i am so glad i can do this in RS, instead of needing to do > this > > on the DB side!!!! > > > > > > > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > > news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > > > Make sure to use =10 (which evaluates to an integer) instead of the > string > > > constant 10 as filter value of the TopN filter. > > > > > > -- > > > This posting is provided "AS IS" with no warranties, and confers no > > rights. > > > > > > > > > "kbr" <kbrandl@gmail.com> wrote in message > > > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > > > You can do this by adding a "filter" to the group to only get "TOP N" > > > > based on some field. Not sure on the exact semantics, but this should > > > > be close: > > > > > > > > Right-click on the group cell, and select "Edit Group". Then go to > the > > > > "Filters" tab, choose the DataSet Field or expression you want to > > > > evaluate; then choose "Top N" as the Operator...then in the Value > > > > field, enter the number you want (i.e., 10 if you want the TOP 10). > > > > > > > > > > > > > > > >
Yes, filters in RS are very useful for your scenario. However, they would
not make sense if the query retrieves one million rows and then filter for the top 10 rows in the report. -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] <aaron_kempf@hotmail.com> wrote in message news:%23$iofgv5EHA.824@TK2MSFTNGP11.phx.gbl... > yeah... better than that changing my report to be a union with a different > TOP 10 clause for each section tho > > I am using MDX and i tihnk that it would be hard to do this via MDX > > MDX/OLAP is fast enough anyways, who cares if it's pulling 15 records and > showing 10 right? > > -aaron > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > news:eUJsqZv5EHA.3124@TK2MSFTNGP11.phx.gbl... > > Yes, it may be more convenient to do filtering in the report, but you have > > to consider that the RS processing engine has to retrieve all the data and > > then apply the filter. This is less efficient than filtering the data on > the > > database and therefore not transmitting and processing them. > > > > -- > > This posting is provided "AS IS" with no warranties, and confers no > rights. > > > > > > <aaron_kempf@hotmail.com> wrote in message > > news:%234puRVv5EHA.1404@TK2MSFTNGP11.phx.gbl... > > > thanks guys, i am so glad i can do this in RS, instead of needing to do > > this > > > on the DB side!!!! > > > > > > > > > > > > > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > > > news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > > > > Make sure to use =10 (which evaluates to an integer) instead of the > > string > > > > constant 10 as filter value of the TopN filter. > > > > > > > > -- > > > > This posting is provided "AS IS" with no warranties, and confers no > > > rights. > > > > > > > > > > > > "kbr" <kbrandl@gmail.com> wrote in message > > > > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > > > > You can do this by adding a "filter" to the group to only get "TOP > N" > > > > > based on some field. Not sure on the exact semantics, but this > should > > > > > be close: > > > > > > > > > > Right-click on the group cell, and select "Edit Group". Then go to > > the > > > > > "Filters" tab, choose the DataSet Field or expression you want to > > > > > evaluate; then choose "Top N" as the Operator...then in the Value > > > > > field, enter the number you want (i.e., 10 if you want the TOP 10). > > > > > > > > > > > > > > > > > > > > > > > > >
rob;
I am having the darnedest time getting this to work. I want to show the top 10 projects for each project type. I go to 'edit group' and I set the TopN clause =10 This notation basically works-- i just can't figure out how to do it for each gorup. Doing this via MDX keeps on crapping out and I'm not going to change my MDX at this stage. I need to be able to filter for the top 10 for each projectType.. It's just not working.. I've seen other posts that look like the same diagnosis.. I just dont' understand what I'm doing wrong. [quoted text, click to view] Robert Bruckner [MSFT] wrote:
> Yes, filters in RS are very useful for your scenario. However, they would > not make sense if the query retrieves one million rows and then filter for > the top 10 rows in the report. > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > <aaron_kempf@hotmail.com> wrote in message > news:%23$iofgv5EHA.824@TK2MSFTNGP11.phx.gbl... > > yeah... better than that changing my report to be a union with a different > > TOP 10 clause for each section tho > > > > I am using MDX and i tihnk that it would be hard to do this via MDX > > > > MDX/OLAP is fast enough anyways, who cares if it's pulling 15 records and > > showing 10 right? > > > > -aaron > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > > news:eUJsqZv5EHA.3124@TK2MSFTNGP11.phx.gbl... > > > Yes, it may be more convenient to do filtering in the report, but you > have > > > to consider that the RS processing engine has to retrieve all the data > and > > > then apply the filter. This is less efficient than filtering the data on > > the > > > database and therefore not transmitting and processing them. > > > > > > -- > > > This posting is provided "AS IS" with no warranties, and confers no > > rights. > > > > > > > > > <aaron_kempf@hotmail.com> wrote in message > > > news:%234puRVv5EHA.1404@TK2MSFTNGP11.phx.gbl... > > > > thanks guys, i am so glad i can do this in RS, instead of needing to > do > > > this > > > > on the DB side!!!! > > > > > > > > > > > > > > > > > > > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in > message > > > > news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > > > > > Make sure to use =10 (which evaluates to an integer) instead of the > > > string > > > > > constant 10 as filter value of the TopN filter. > > > > > > > > > > -- > > > > > This posting is provided "AS IS" with no warranties, and confers no > > > > rights. > > > > > > > > > > > > > > > "kbr" <kbrandl@gmail.com> wrote in message > > > > > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > > > > > You can do this by adding a "filter" to the group to only get "TOP > > N" > > > > > > based on some field. Not sure on the exact semantics, but this > > should > > > > > > be close: > > > > > > > > > > > > Right-click on the group cell, and select "Edit Group". Then go > to > > > the > > > > > > "Filters" tab, choose the DataSet Field or expression you want to > > > > > > evaluate; then choose "Top N" as the Operator...then in the Value > > > > > > field, enter the number you want (i.e., 10 if you want the TOP > 10). > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
rob;
I am having the darnedest time getting this to work. I want to show the top 10 projects for each project type. I go to 'edit group' and I set the TopN clause =10 This notation basically works-- i just can't figure out how to do it for each gorup. Doing this via MDX keeps on crapping out and I'm not going to change my MDX at this stage. I need to be able to filter for the top 10 for each projectType.. It's just not working.. I've seen other posts that look like the same diagnosis.. I just dont' understand what I'm doing wrong. [quoted text, click to view] Robert Bruckner [MSFT] wrote:
> Yes, filters in RS are very useful for your scenario. However, they would > not make sense if the query retrieves one million rows and then filter for > the top 10 rows in the report. > > -- > This posting is provided "AS IS" with no warranties, and confers no rights. > > <aaron_kempf@hotmail.com> wrote in message > news:%23$iofgv5EHA.824@TK2MSFTNGP11.phx.gbl... > > yeah... better than that changing my report to be a union with a different > > TOP 10 clause for each section tho > > > > I am using MDX and i tihnk that it would be hard to do this via MDX > > > > MDX/OLAP is fast enough anyways, who cares if it's pulling 15 records and > > showing 10 right? > > > > -aaron > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in message > > news:eUJsqZv5EHA.3124@TK2MSFTNGP11.phx.gbl... > > > Yes, it may be more convenient to do filtering in the report, but you > have > > > to consider that the RS processing engine has to retrieve all the data > and > > > then apply the filter. This is less efficient than filtering the data on > > the > > > database and therefore not transmitting and processing them. > > > > > > -- > > > This posting is provided "AS IS" with no warranties, and confers no > > rights. > > > > > > > > > <aaron_kempf@hotmail.com> wrote in message > > > news:%234puRVv5EHA.1404@TK2MSFTNGP11.phx.gbl... > > > > thanks guys, i am so glad i can do this in RS, instead of needing to > do > > > this > > > > on the DB side!!!! > > > > > > > > > > > > > > > > > > > > > > > > "Robert Bruckner [MSFT]" <robruc@online.microsoft.com> wrote in > message > > > > news:eW0J0eL5EHA.2676@TK2MSFTNGP12.phx.gbl... > > > > > Make sure to use =10 (which evaluates to an integer) instead of the > > > string > > > > > constant 10 as filter value of the TopN filter. > > > > > > > > > > -- > > > > > This posting is provided "AS IS" with no warranties, and confers no > > > > rights. > > > > > > > > > > > > > > > "kbr" <kbrandl@gmail.com> wrote in message > > > > > news:1103329622.391824.131290@z14g2000cwz.googlegroups.com... > > > > > > You can do this by adding a "filter" to the group to only get "TOP > > N" > > > > > > based on some field. Not sure on the exact semantics, but this > > should > > > > > > be close: > > > > > > > > > > > > Right-click on the group cell, and select "Edit Group". Then go > to > > > the > > > > > > "Filters" tab, choose the DataSet Field or expression you want to > > > > > > evaluate; then choose "Top N" as the Operator...then in the Value > > > > > > field, enter the number you want (i.e., 10 if you want the TOP > 10). > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
Don't see what you're looking for? Try a search.
|
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 |