Showing posts with label reporting. Show all posts
Showing posts with label reporting. Show all posts

Wednesday, March 28, 2012

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 Smile

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

Friday, March 23, 2012

How to get the database location of a installed reporting service?

I have reporting service installed, but I didn't install it. I
cannot figure out where the reporting service database located. We
have two SQL servers and the databases reside on BOTH servers. Also
the resportserver.mdb and reportservertempdb.mdb files reside on both
servers (obviously) and both have fairly recent dates. It's quite
possible that someone else on my network has a Report Server running.
How can I figure out *which* database is mine'
Thank you.If you are running RS 2005 then on your report server you will have an app
called Reporting Services Configuration. When you run it, it shows a variety
of configuration options including the database.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<doug.masters@.gmail.com> wrote in message
news:1176912515.518742.324170@.o5g2000hsb.googlegroups.com...
>I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.|||On Apr 18, 11:52 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> If you are running RS 2005 then on your report server you will have an app
> called Reporting Services Configuration. When you run it, it shows a variety
> of configuration options including the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
Sorry, I forgot that little tidbit of info... Reporting Services
2000|||On Apr 18, 11:08 am, doug.mast...@.gmail.com wrote:
> I have reporting service installed, but I didn't install it. I
> cannot figure out where the reporting service database located. We
> have two SQL servers and the databases reside on BOTH servers. Also
> the resportserver.mdb and reportservertempdb.mdb files reside on both
> servers (obviously) and both have fairly recent dates. It's quite
> possible that someone else on my network has a Report Server running.
> How can I figure out *which* database is mine'
> Thank you.
OK, I've poked thru files & the registry to see if I can find ou the
path to the databses and no luck. Anyone know how to find this in
RS 2000?

Monday, March 19, 2012

How to get started?

I am looking to learn about reporting with SQL Server for my company

Currently we have an applicaiton running on SQL Server 2000 and have SQL Server 2000 Reporting Services installed. However, I have VB Express and Web Development Express 2005.

How do I get started here? What versions "work" with what? Do I need to either upgrade the DB to SQL 2005 or find VB.net 2003, or can I use what I have to get started?

jibip,

you will need "Reporting Add-In for Microsoft Visual Web Developer 2005 Express" if you want SSRS with your Web Development express. However, you will still need a BIDS environment (VS studio) for SSRS 2000.

In short, you will be a whole lot better just upgrading to SQL 2005 and installing Reporting Service, VB.NET is not a requirement, but hey if you are just starting out I would suggest going to VS 2005 and be done with it.

Ham

Monday, March 12, 2012

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
>

Wednesday, March 7, 2012

How to get only date component from a datetime column

Hi all,

I have a table containing a datetime column and it stores date with time ( I use GETDATE() to store the value ). For reporting purpose I need only the date component from this column without the time component. I do not want to use the datepart(yyyy, orderdt), datepart(mm, orderdt) and datepart(dd, orderdt).

Will following help

select CONVERT ( VARCHAR (10) , GetDATE(), 121 )

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.
>

Friday, February 24, 2012

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#.
>
>

Sunday, February 19, 2012

how to get driopdown for year

how can i display the dropdown for year values in sql reporting

i want to accept the value for year as parameter & also want user to select the value from dropdown that will display only the year values.

What product are you using?

Can you give more details about your situation.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.