I am new to reporting services and I have heard that there are reports
available to report on reporting services. IE. Which reports are run, how
long they run, how often they are run... Can somebody tell me where to
find those reports?
Thanks,
RonYes, these are the execution log reports which come as a sample on the RS
2000 installation CD. See MSDN for more details on how to use them:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmin/htm/arp_rslogfiles_v1_88gy.asp
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ron" <ron@.myalias.postalias> wrote in message
news:Xns96EDA8BD514E9WBT39212565@.207.46.248.16...
>I am new to reporting services and I have heard that there are reports
> available to report on reporting services. IE. Which reports are run, how
> long they run, how often they are run... Can somebody tell me where to
> find those reports?
> Thanks,
> Ron|||"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in
news:efmnDW6zFHA.3720@.TK2MSFTNGP14.phx.gbl:
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsadmi
> n/htm/arp_rslogfiles_v1_88gy.asp
Thanks!!!!!
Showing posts with label available. Show all posts
Showing posts with label available. Show all posts
Monday, March 26, 2012
Reporting Services Projects
I'm trying to find out if it's possible to install VS 2005 and only have the Business Intelligence Project type available? In other words, no Websites, VB.Net, etc...?
Thanks in advance.
If you don't install VS 2005 at all, and only install BI Development Studio during the SQL Server 2005 install, you will get the VS shell with BI project types only.
-- Robert
Friday, March 23, 2012
reporting services parameter problem
I have a report that uses as available values for a parameter a query. My problem is that the query return a list of available months, however, sometimes, i would like the user to choose null when they want to see all months in the report. but the query does not have a month null so null is not allowed.
Is there anything I can do? I cannot add a null record in the table itself.
thank you, dreyYou can either allow null for a parameter or use a UNION to add All Months to the available options. (Adding All Months tends to give a better end-user experience.) Note that the following query (because of the UNION) isn't valid in the graphical query designer. You'll be prompted to switch to the generic query designer. You'll have to modify the query to match your particular DB schema.
Is there anything I can do? I cannot add a null record in the table itself.
thank you, dreyYou can either allow null for a parameter or use a UNION to add All Months to the available options. (Adding All Months tends to give a better end-user experience.) Note that the following query (because of the UNION) isn't valid in the graphical query designer. You'll be prompted to switch to the generic query designer. You'll have to modify the query to match your particular DB schema.
SELECT MonthNumber, MonthName
FROM Months
UNION
SELECT -1, 'All Months'
Now you've got your parameter values populated. If you're using the 'All Months' option, you'll want to uncheck "Allow null values".
You should now modify your dataset query to:
SELECT column1, column2, column3
FROM table1
WHERE (MonthNumber = @.MonthNumber OR @.MonthNumber = -1)
If you select a month, you will get the appropriate data back for that month. If you select All Months, then MonthNumber = -1 will always be false (since -1 isn't a valid month number), but the second part will evaluate as true for all months.
Hope that helps.
Reporting services over internet
Is there any example how to make Report available over internet to our
customers?
How to get username and password from customers?
How to connect aspx page and report?Internet deployment is discussed in
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx.
On your last question, please refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_intro_7xb6.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:%23kb%23D2maEHA.972@.TK2MSFTNGP12.phx.gbl...
> Is there any example how to make Report available over internet to our
> customers?
> How to get username and password from customers?
> How to connect aspx page and report?
>
>
customers?
How to get username and password from customers?
How to connect aspx page and report?Internet deployment is discussed in
http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx.
On your last question, please refer to
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_intro_7xb6.asp.
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"TomislaW" <tomislav147@.hotmail.com> wrote in message
news:%23kb%23D2maEHA.972@.TK2MSFTNGP12.phx.gbl...
> Is there any example how to make Report available over internet to our
> customers?
> How to get username and password from customers?
> How to connect aspx page and report?
>
>
Reporting Services output other than PDF?
Can someone point me to a list \ description of the output formats available
with SQL Reporing Services? A structured text format in ACSII, PCL, or
something like that would be preferred. Thanks!If you look in the Reporting Services Books Online, you find this article
Exporting Reports
http://msdn2.microsoft.com/en-us/library/ms157153.aspx
It lists the standard formats and other information about exporting reports.
Kaisa M. Lindahl Lervik
"Mr. Wonderful" <MrWonderful@.discussions.microsoft.com> wrote in message
news:2FF99A10-C92E-4D2A-83B9-5A7F608647C4@.microsoft.com...
> Can someone point me to a list \ description of the output formats
> available
> with SQL Reporing Services? A structured text format in ACSII, PCL, or
> something like that would be preferred. Thanks!
with SQL Reporing Services? A structured text format in ACSII, PCL, or
something like that would be preferred. Thanks!If you look in the Reporting Services Books Online, you find this article
Exporting Reports
http://msdn2.microsoft.com/en-us/library/ms157153.aspx
It lists the standard formats and other information about exporting reports.
Kaisa M. Lindahl Lervik
"Mr. Wonderful" <MrWonderful@.discussions.microsoft.com> wrote in message
news:2FF99A10-C92E-4D2A-83B9-5A7F608647C4@.microsoft.com...
> Can someone point me to a list \ description of the output formats
> available
> with SQL Reporing Services? A structured text format in ACSII, PCL, or
> something like that would be preferred. Thanks!
Reporting Services output formats?
Can someone point me to a list \ description of the output formats available
with Reporting Services? I'm trying to help a customer that wants something
other than PDF output from their MS SQL Reporting Services - they'd prefer a
structured text format or something like that. Thanks!Hi,
Just open in the report manager folder and the config file you can see a
list of output formats, like CSV, Excel, PDF,archive etc...
Amarnath
"Mr. Wonderful" wrote:
> Can someone point me to a list \ description of the output formats available
> with Reporting Services? I'm trying to help a customer that wants something
> other than PDF output from their MS SQL Reporting Services - they'd prefer a
> structured text format or something like that. Thanks!
with Reporting Services? I'm trying to help a customer that wants something
other than PDF output from their MS SQL Reporting Services - they'd prefer a
structured text format or something like that. Thanks!Hi,
Just open in the report manager folder and the config file you can see a
list of output formats, like CSV, Excel, PDF,archive etc...
Amarnath
"Mr. Wonderful" wrote:
> Can someone point me to a list \ description of the output formats available
> with Reporting Services? I'm trying to help a customer that wants something
> other than PDF output from their MS SQL Reporting Services - they'd prefer a
> structured text format or something like that. Thanks!
Wednesday, March 21, 2012
Reporting Services Objects only during printing & multiselect ques
Hi all,
1)Is there a way to supress the textbox,image etc when the report is
displayed in browser and then make them available for printing on paper alone?
2) how to construct url to call reports that has multiselect parameters. In
other words how to pass values through url to a report for multiselect
parameters.
Any idea is greately appreciated.
Thanks.1. today there is no way to know how the report is rendered except by adding
a parameter in the report.
2. try using coma delimited values and convert this list into a table using
a function like the following code.
and use it like this:
select * from products P inner join dbo.ListToTableChar('P1', 'P2', 'P3',
'P4', ',') L on P.ProductID = L.str
create FUNCTION [ListToTableChar](@.list [ntext], @.delimiter [nchar](1) =N',')
RETURNS @.tbl TABLE (
[listpos] [int] IDENTITY NOT NULL,
[str] [varchar](4000) NULL,
[nstr] [nvarchar](2000) NULL
) AS
BEGIN
DECLARE @.pos int,
@.textpos int,
@.chunklen smallint,
@.tmpstr nvarchar(4000),
@.leftover nvarchar(4000),
@.tmpval nvarchar(4000)
SET @.textpos = 1
SET @.leftover = ''
WHILE @.textpos <= datalength(@.list) / 2
BEGIN
SET @.chunklen = 4000 - datalength(@.leftover) / 2
SET @.tmpstr = @.leftover + substring(@.list, @.textpos, @.chunklen)
SET @.textpos = @.textpos + @.chunklen
SET @.pos = charindex(@.delimiter, @.tmpstr)
WHILE @.pos > 0
BEGIN
SET @.tmpval = ltrim(rtrim(left(@.tmpstr, @.pos - 1)))
INSERT @.tbl (str, nstr) VALUES(@.tmpval, @.tmpval)
SET @.tmpstr = substring(@.tmpstr, @.pos + 1, len(@.tmpstr))
SET @.pos = charindex(@.delimiter, @.tmpstr)
END
SET @.leftover = @.tmpstr
END
INSERT @.tbl(str, nstr) VALUES (ltrim(rtrim(@.leftover)),
ltrim(rtrim(@.leftover)))
RETURN
END
"RSUser" <RSUser@.discussions.microsoft.com> wrote in message
news:3CB5899F-04E9-4172-9BBD-3ECCADA27B4D@.microsoft.com...
> Hi all,
> 1)Is there a way to supress the textbox,image etc when the report is
> displayed in browser and then make them available for printing on paper
> alone?
> 2) how to construct url to call reports that has multiselect parameters.
> In
> other words how to pass values through url to a report for multiselect
> parameters.
> Any idea is greately appreciated.
> Thanks.
>|||Hi
For multiselect I constructed a udf which will break my strin
delimited with comma and return a table datatype with a fiel
containing all values.It works fine in the dataset part in m
report.(Actually if i try to use report manager interface instead o
url access, i need not even construct udf; it simply works with th
sql like select x,y from table1 where x in (@.z))
My problem is i do not know how to construct the url which has to pas
comma separated values to report
The sample url which i try to use now and getting error is
http://localhost/reportserver?/foldername/rptname&rs:command=render&rc:parameters=false¶m1=value1&multiparam1=value1,value
Please correct the above url so that my multiselect report will wor
when i call from browser like this
Thanks
1)Is there a way to supress the textbox,image etc when the report is
displayed in browser and then make them available for printing on paper alone?
2) how to construct url to call reports that has multiselect parameters. In
other words how to pass values through url to a report for multiselect
parameters.
Any idea is greately appreciated.
Thanks.1. today there is no way to know how the report is rendered except by adding
a parameter in the report.
2. try using coma delimited values and convert this list into a table using
a function like the following code.
and use it like this:
select * from products P inner join dbo.ListToTableChar('P1', 'P2', 'P3',
'P4', ',') L on P.ProductID = L.str
create FUNCTION [ListToTableChar](@.list [ntext], @.delimiter [nchar](1) =N',')
RETURNS @.tbl TABLE (
[listpos] [int] IDENTITY NOT NULL,
[str] [varchar](4000) NULL,
[nstr] [nvarchar](2000) NULL
) AS
BEGIN
DECLARE @.pos int,
@.textpos int,
@.chunklen smallint,
@.tmpstr nvarchar(4000),
@.leftover nvarchar(4000),
@.tmpval nvarchar(4000)
SET @.textpos = 1
SET @.leftover = ''
WHILE @.textpos <= datalength(@.list) / 2
BEGIN
SET @.chunklen = 4000 - datalength(@.leftover) / 2
SET @.tmpstr = @.leftover + substring(@.list, @.textpos, @.chunklen)
SET @.textpos = @.textpos + @.chunklen
SET @.pos = charindex(@.delimiter, @.tmpstr)
WHILE @.pos > 0
BEGIN
SET @.tmpval = ltrim(rtrim(left(@.tmpstr, @.pos - 1)))
INSERT @.tbl (str, nstr) VALUES(@.tmpval, @.tmpval)
SET @.tmpstr = substring(@.tmpstr, @.pos + 1, len(@.tmpstr))
SET @.pos = charindex(@.delimiter, @.tmpstr)
END
SET @.leftover = @.tmpstr
END
INSERT @.tbl(str, nstr) VALUES (ltrim(rtrim(@.leftover)),
ltrim(rtrim(@.leftover)))
RETURN
END
"RSUser" <RSUser@.discussions.microsoft.com> wrote in message
news:3CB5899F-04E9-4172-9BBD-3ECCADA27B4D@.microsoft.com...
> Hi all,
> 1)Is there a way to supress the textbox,image etc when the report is
> displayed in browser and then make them available for printing on paper
> alone?
> 2) how to construct url to call reports that has multiselect parameters.
> In
> other words how to pass values through url to a report for multiselect
> parameters.
> Any idea is greately appreciated.
> Thanks.
>|||Hi
For multiselect I constructed a udf which will break my strin
delimited with comma and return a table datatype with a fiel
containing all values.It works fine in the dataset part in m
report.(Actually if i try to use report manager interface instead o
url access, i need not even construct udf; it simply works with th
sql like select x,y from table1 where x in (@.z))
My problem is i do not know how to construct the url which has to pas
comma separated values to report
The sample url which i try to use now and getting error is
http://localhost/reportserver?/foldername/rptname&rs:command=render&rc:parameters=false¶m1=value1&multiparam1=value1,value
Please correct the above url so that my multiselect report will wor
when i call from browser like this
Thanks
Reporting Services Management
What tools are available to manage which users are currently running what
reports, parameters selected, load on server etc. Basically I'm trying to
figure out how I determine if Reporting Services is slow, what report/user is
causing it, or if it's just a lot of people asking for reports and I need to
look at scaling the server.
I'm interested in historical stuff, but I'm also interested in real time
this is what's happening where with what components. For instance is
retrieval slow or is it rendering that's slowing the report down, slamming
the cpu etc.
I see the DTS package for the logs and am installing that, but is there
anything more immediate like current activity in SQL server?Larry,
Your first stop should be the Execution Log. Check "Report Server Execution
Log" topic in the documentation. Among many other things, the Execution Log
will tell you how much time is spend in querying the data, processing and
rendering the report. In addition, in Report Manager you can see the current
activity (Running Jobs).
Warning.. shameless self-promotion :-) Accidentally, my book includes a
whole chapter (Chapter 16) on the RS performance and scalability.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:8947D670-D575-4FD1-A724-9A7A0147DF29@.microsoft.com...
> What tools are available to manage which users are currently running what
> reports, parameters selected, load on server etc. Basically I'm trying to
> figure out how I determine if Reporting Services is slow, what report/user
is
> causing it, or if it's just a lot of people asking for reports and I need
to
> look at scaling the server.
> I'm interested in historical stuff, but I'm also interested in real time
> this is what's happening where with what components. For instance is
> retrieval slow or is it rendering that's slowing the report down, slamming
> the cpu etc.
> I see the DTS package for the logs and am installing that, but is there
> anything more immediate like current activity in SQL server?sql
reports, parameters selected, load on server etc. Basically I'm trying to
figure out how I determine if Reporting Services is slow, what report/user is
causing it, or if it's just a lot of people asking for reports and I need to
look at scaling the server.
I'm interested in historical stuff, but I'm also interested in real time
this is what's happening where with what components. For instance is
retrieval slow or is it rendering that's slowing the report down, slamming
the cpu etc.
I see the DTS package for the logs and am installing that, but is there
anything more immediate like current activity in SQL server?Larry,
Your first stop should be the Execution Log. Check "Report Server Execution
Log" topic in the documentation. Among many other things, the Execution Log
will tell you how much time is spend in querying the data, processing and
rendering the report. In addition, in Report Manager you can see the current
activity (Running Jobs).
Warning.. shameless self-promotion :-) Accidentally, my book includes a
whole chapter (Chapter 16) on the RS performance and scalability.
--
Hope this helps.
---
Teo Lachev, MVP [SQL Server], MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
---
"Larry Charlton" <LarryCharlton@.discussions.microsoft.com> wrote in message
news:8947D670-D575-4FD1-A724-9A7A0147DF29@.microsoft.com...
> What tools are available to manage which users are currently running what
> reports, parameters selected, load on server etc. Basically I'm trying to
> figure out how I determine if Reporting Services is slow, what report/user
is
> causing it, or if it's just a lot of people asking for reports and I need
to
> look at scaling the server.
> I'm interested in historical stuff, but I'm also interested in real time
> this is what's happening where with what components. For instance is
> retrieval slow or is it rendering that's slowing the report down, slamming
> the cpu etc.
> I see the DTS package for the logs and am installing that, but is there
> anything more immediate like current activity in SQL server?sql
Monday, March 12, 2012
reporting services in SQL server 2005 express edition
I want to know if reporting services are available in sql server 2005 express edition that is running along side visual web developer 2005 express edition because i cant see reporting services in the configuration tools. This is Urgent, that is of course if you have the time.
Thanks .
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
"Reporting Services features are not yet available in SQL Server 2005 Express Edition."
|||
aus_nexxus:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx
"Reporting Services features are not yet available in SQL Server 2005 Express Edition."
That is not correct Microsoft have now added advanced features for SQL Server Express which includes all but the Agent and database Mirroring with trade offs. Try the link below for details. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/compare/default.aspx
|||So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.|||
So if Reporting Services features are not yet available in SQL Server 2005 Express Edition, does that mean i can not run reportviewer reports in remote proccessing mode.
It is available with the Advanced features download link I posted. Hope this helps.
|||Okay. So what happens to my applications database if i upgrade from sql server 2005 express edition to sql server 2005 express edition with Advanced services. I feel i need to enhance my reports with SQL server reporting services urgently.
Please remember that iam running the 2005 express edition with visual web developer 2005 express edition.
|||Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.|||Yes thanks. So help full|||
Nothing happens to your application you need to read what is in that link relevant to the advanced features. Hope this helps.
OH?
1. I had problems with User Instances..."could not create user instance..."
2. Ensured user instances was on in SQL Server...the app complained about user instances not supported.
3. Tried to run the ASP.NET Configuration tool against my application...it complains about user instances...
4. Uninstalled everything; reinstalled SQL Server Express with Advanced Features followed by VWD and Languages (as before)
5. It no longer complains about user instances...but it now tells me I have not created the security database that was created by default before and when I look in the apps folder...nada database...even my own is gone (thank goodness only a trial base) yet all my previously written files are there.
6. Based on 5 above, it tells me to run the command line utility called aspnet_sqlreg...when I look up the docs on this little gem, it says that it MUST NOT BE USED WHEN USER INSTANCES is enabled.
7. So here I sit, looking for help...find my issue quite quickly, only to fine a curt answer with links to features and stating...NO problems.
Nope. NO problems here!!!
Any more thoughts on this?
|||P.S. to my last post.
Sorry for being a Newbie, finding and exploring features I need/want.
|||
P.S. to my last post.
Sorry for being a Newbie, finding and exploring features I need/want.
No problem I am here to help, so here is the it is free but you need to this or it will not run list from Microsoft I knew there must be such list so go through it and let me know if you need more help.
http://msdn2.microsoft.com/en-us/library/ms365166.aspx
Reporting Services in SQL Express?
Is SSRS available in SQL Express? The feature matrix here:
says that the Report Server is available. However, SSRS was not an available option in the setup I used.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
says that the Report Server is available. However, SSRS was not an available option in the setup I used.
Any help is greatly appreciated!The version of SQL Server 2005 Express Edition including Report Server is not yet available. We are working on it but have not announced a release date.|||It will be availabe before June 2006.
Reporting Services in sql express
When this will be available, I just started a project and I have to make some projects, the database will be sql express because the user cant buy the other editions.I dont know if MS plans to put that in express seeing how RS is a hugeaddition to the SQL Server family and belongs in the strongerversions. Could be wrong...
|||Yes they do, look at the msft sql compare features page.
|||Well shut my mouth. They also have a reports plugin for VWD. For free even hehe.
|||Yes its called report viewer. but its only for viewing reports that you have already designed with report designer.
|||Yes they do, look at the msft sql compare features page.
|||Well shut my mouth. They also have a reports plugin for VWD. For free even hehe.
|||Yes its called report viewer. but its only for viewing reports that you have already designed with report designer.
Saturday, February 25, 2012
Reporting Services Data Source Types
Could someone explain to me the difference between the types of data sources available to reporting services, and the advantages and disadvantages of each please.
Shared Private DynamicCan you store a data source connection string in a configuration file to be used by a report?
Thank you
Hi,
shared -- can be used with other reports
private -- is only used by this report
dynamic -- never heard of that, I guess that means that the data source can be defined by an expression which will evaluate at runtime how the connection string has to look like.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks, but can you store a connectionstring in a config file and use it as the data source?
|||No, never saw that implemented. You could access the connectionstring programmatically in the datasource, but not in the regular GUI.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Reporting Services Data Source Types
Could someone explain to me the difference between the types of data sources available to reporting services, and the advantages and disadvantages of each please.
Shared
Private
Dynamic
Can you store a data source connection string in a configuration file to be used by a report?
Thank you
Hi,
shared -- can be used with other reports
private -- is only used by this report
dynamic -- never heard of that, I guess that means that the data source can be defined by an expression which will evaluate at runtime how the connection string has to look like.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||Thanks, but can you store a connectionstring in a config file and use it as the data source?
|||No, never saw that implemented. You could access the connectionstring programmatically in the datasource, but not in the regular GUI.HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
Subscribe to:
Posts (Atom)