How to get the Top 10 Categories in Chart

Hi,

I would like to know how to get the Top 10 Categories from Reporting Services chart without using the scripting in T-SQL to query from db.

Is there a function like Ranking and then we filter the Ranking to be less than or equal 10 ?

Please kindly direct me in step by step to the way on how to achieve this as I am quite new in Reporting Services

Thank you

best regards,

Tanipar

An example of top N in a report can be seen in the execution log samples provided by MS. (These reports allow you to view stats on who is using which report in reporting services)

Set a filter (right click - properties - filters) on your table/grouping/whatever
to be something like

expression
=Sum(Fields!Executions.Value)

operator
top N

value
=10|||

Hi,

Thank you

But after I follow your instruction I got the following error message, any idea what happen :

An error occured during local report processing

An error has occured during report processing

The processing of SortExpression for the list 'List1' cannot be performed. The comparison failed. Please check the data type returned by the SortExpression

I have ensure the one that the field that I sum is the numbers.

Please let me know if you have any idea on this.

Thanks

best regards,

Tanipar

|||

Hi,

After moving the TopN condition into the grouping, now I encounter another error :

An error has occured during report processing.

Failed to evaluate the FilterValue.

Can anyone help me ?

Many Thanks!

best regards,

Tanipar

|||I have this work already. Many thanks for your help !!!

how to get the rowNumber in a matrix?

I am working with reporting services recently.

when using a matrix, I want to get the row number to dynamically set the row color.

but i can not get it by using the rownumber function,

can anyone help me with it?

thank you very much.

The row number doesn't really help you in a matrix because you are always dealing with grouped data in a matrix. You have to follow the approach discussed in the following blog article: http://blogs.msdn.com/chrishays/archive/2004/08/30/GreenBarMatrix.aspx

-- Robert

How to Get RS Tools for Visual Studio 2003?

The overall question: How do I get the Reporting Services tools for Visual
Studio 2003 if my web hosting company owns the SQL Server?
I am a lone developer with a laptop and a web hosting company. I have Visual
Studio 2003 installed on my laptop (Windows XP Pro). My web host provides me
with .NET, SQL Server 2000, and now Reporting Services. I want to begin to
learn and use Reporting Services.
In searching Microsoft's web site, it seems that I can only obtain the tools
that go into Visual Studio to develop RS reports if I have my own SQL Server
2000. I own a copy of SQL Server 2000 Professional, but I cannot install it
on XP Pro. It requires a server version of Windows. I do have MSDE
installed, but Reporting Services (RSEval.exe) refuses to install on this
version. I don't have access to high priced things like an MSDN universal or
enterprise subscription. I don't qualify for academic versions.
There must be a way for developers like me to get the tools necessary to
create these reports. Any ideas?You do not need to install the server to use the tools (setup will warn you
but you can ignore it). The evaluation version should work fine for you.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rick" <rrgrimm@.hotmail.com> wrote in message
news:OjYVHZ2pEHA.2696@.TK2MSFTNGP15.phx.gbl...
> The overall question: How do I get the Reporting Services tools for Visual
> Studio 2003 if my web hosting company owns the SQL Server?
> I am a lone developer with a laptop and a web hosting company. I have
> Visual Studio 2003 installed on my laptop (Windows XP Pro). My web host
> provides me with .NET, SQL Server 2000, and now Reporting Services. I want
> to begin to learn and use Reporting Services.
> In searching Microsoft's web site, it seems that I can only obtain the
> tools that go into Visual Studio to develop RS reports if I have my own
> SQL Server 2000. I own a copy of SQL Server 2000 Professional, but I
> cannot install it on XP Pro. It requires a server version of Windows. I do
> have MSDE installed, but Reporting Services (RSEval.exe) refuses to
> install on this version. I don't have access to high priced things like an
> MSDN universal or enterprise subscription. I don't qualify for academic
> versions.
> There must be a way for developers like me to get the tools necessary to
> create these reports. Any ideas?
>

How to get Reporting Services faster...

Ok,
I have written our invoice printing software using the rs.render on
Bryan Keller' blog (of Microsoft) to directly send the Invoice with RS
straight to the printer as an EMF. It is painfully slow, but I found
that the speed almost tripples using my development computer which uses
dual Xeon Intel processing. Unfortunately, I don't want to give up my
development machine for the shipping department.
I guess, when rendering graphics (which in this mannor is an Image
file), there is no workaround without the proper hardware. You will
need faster Image rendering processor.
The company isn't using my application yet because they may want me to
re-write it without Reporting Services because of this problem. So,
they continue to use the old asp app someone wrote a couple of years
ago which sends to dot-matrix printers (instead of my fancy, but slow
way to the NICE laser jets).
If anyone knows something I don't, after unbelieveable research and
problems with this, PLEASE let me in on your secret.
Thanks,
TrintThe difference in speed might be RAM, not processor. Is there a big
difference in RAM between the two machines? If so, upgrading RAM is a lot
cheaper than creating a new solution (or buying a new machine).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1123497399.592828.55160@.o13g2000cwo.googlegroups.com...
> Ok,
> I have written our invoice printing software using the rs.render on
> Bryan Keller' blog (of Microsoft) to directly send the Invoice with RS
> straight to the printer as an EMF. It is painfully slow, but I found
> that the speed almost tripples using my development computer which uses
> dual Xeon Intel processing. Unfortunately, I don't want to give up my
> development machine for the shipping department.
> I guess, when rendering graphics (which in this mannor is an Image
> file), there is no workaround without the proper hardware. You will
> need faster Image rendering processor.
> The company isn't using my application yet because they may want me to
> re-write it without Reporting Services because of this problem. So,
> they continue to use the old asp app someone wrote a couple of years
> ago which sends to dot-matrix printers (instead of my fancy, but slow
> way to the NICE laser jets).
> If anyone knows something I don't, after unbelieveable research and
> problems with this, PLEASE let me in on your secret.
> Thanks,
> Trint
>

How to get number of pages per group

I am creating an invoice print using Reporting Services and have
managed to figure out how to reset the Page number for each group
change.
Now, I need to figure out how many pages will print for each group
change. The report is rendered for many invoices (each invoice is a
group change) and each invoice may or may not have multiple pages.
I need to hide the page footer until the last page of the invoice.
Any ideas on how to do that?
Thanks!can't you adapt your sql query ? add an extra field (that uses a count by
grouping). And add that count field in your group footer...
just a mind spinning ;)
"Sher" wrote:
> I am creating an invoice print using Reporting Services and have
> managed to figure out how to reset the Page number for each group
> change.
> Now, I need to figure out how many pages will print for each group
> change. The report is rendered for many invoices (each invoice is a
> group change) and each invoice may or may not have multiple pages.
> I need to hide the page footer until the last page of the invoice.
> Any ideas on how to do that?
> Thanks!
>|||can't you adapt your sql query ? add an extra field (that uses a count by
grouping). And add that count field in your group footer...
just a mind spinning ;)
"Sher" wrote:
> I am creating an invoice print using Reporting Services and have
> managed to figure out how to reset the Page number for each group
> change.
> Now, I need to figure out how many pages will print for each group
> change. The report is rendered for many invoices (each invoice is a
> group change) and each invoice may or may not have multiple pages.
> I need to hide the page footer until the last page of the invoice.
> Any ideas on how to do that?
> Thanks!
>

How to get non-html format data to open in a new window

I am totally new to reporting services and am struggling with how to
accomplish something. I have an aspx page that needs to display the
html format version of a report on the bottom portion of the page and
then provide a drop down list from which the user can select another
format and an export button. When the user clicks a new format (pdf,
csv, etc) and then the export button, I need for the report to pop open
in a new window. I have succeeded in getting the report to come out on
the bottom part of the page but have no idea how to get the other
formats to pop open in a new page. I am coding in vb - can someone
point me in the right direction.You could use window.open(URL) method to open in a new window
"lisa.bogart@.eds.com" wrote:
> I am totally new to reporting services and am struggling with how to
> accomplish something. I have an aspx page that needs to display the
> html format version of a report on the bottom portion of the page and
> then provide a drop down list from which the user can select another
> format and an export button. When the user clicks a new format (pdf,
> csv, etc) and then the export button, I need for the report to pop open
> in a new window. I have succeeded in getting the report to come out on
> the bottom part of the page but have no idea how to get the other
> formats to pop open in a new page. I am coding in vb - can someone
> point me in the right direction.
>

How to get list of item in Report Server

hi,
I'm new to reporting services, and i'm using custom authorization.
I need to create a windows application which will connect to the report
server and gets list of all files and folders from the root directory and set
policies.
I want to know how to retrieve all the folders and files from root directory.
I included the reporting service component and created an object for that,
after that how i should retrieve the list of folders from the report server.
I would like to know how to resolve this, send me the way how to retrieve
either in VB or in C#.There are 2 techniques available:
1) There is a List method (List...). Call it from the root path "/" and
then recurse each to build the tree. Each item has an item type (Folder,
DataSource, Report, etc)
a. I'm going from memory, but I think it's either ListChildren or
ListItems
2) FindItems from the root path "/" and assemble from there.
a. Again, I'm going from memory.
Look to MSDN or SQL Server BOL for the methods.
BTW, you wouldn't be the same Uday that worked for a company called
PowerCerv years ago would you? I know the name is common, but I'm curious.
-Tim
"uday" <uday@.discussions.microsoft.com> wrote in message
news:D5BE2C9D-7617-42B2-B915-467F8B706948@.microsoft.com...
> hi,
> I'm new to reporting services, and i'm using custom authorization.
> I need to create a windows application which will connect to the report
> server and gets list of all files and folders from the root directory and
> set
> policies.
> I want to know how to retrieve all the folders and files from root
> directory.
> I included the reporting service component and created an object for that,
> after that how i should retrieve the list of folders from the report
> server.
> I would like to know how to resolve this, send me the way how to retrieve
> either in VB or in C#.
>
>