Adding a script in Reporting Services

Hi.
I need to display a date with his serial week number of the year (from 1-52
weeks).
I wrote a class method that will receive this date and will return the
corresponding week number, and made a dll file out of it.
I added this dll as a reference to my report using Report->Report
Properties->Add Reference.
Now to the tricky part, how do I embed this code in my report?
I found some documented material that I need to uncomment the
<customAssembies> in the rsconfig file. I looked into my config file but no
such <customAssembies> exists.
Does anyone have an example of how to use external dll and to successfully
embed them in the report?
I will highly appreciate any word of wisdom...
Thanks,
GuyGuy,
I didn't figure out your dll question but I believe this will solve
your date problem.
=DatePart(DateInterval.WeekOfYear,Today)
or
=DatePart("ww",Today)
Hope this helps.
Here's a link to the Visual Basic Run-time Library Members
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
Steve|||Steve, thanks a lot.
You have been very helpful.
I also realized how to create GetWeekOfYear( ) in VB.Net and to embed this
function in my report as Code.GetWeekOfYear( ).
I would to rephrase my request for assistance:
1. I created a class in C# and the class method as GetWeekOfYear( ) and
create a dll file of this class.
2. I added this reference to an existing report using the Report->Add
reference command from the Menu toolbar.
3. According to MSDN documentation I need to uncomment the
<CustomAssemblies> in the RSReportingServer.config
However, I didn't find any <CustomAssemblies> in the
RSReportingServer.config, therefore I can't refer to my dll file which
contains the GetWeekOfYear( ) method.
I will appreciate any help in adding and using dll in the Reporting Services
(which is not written in VB.Net which is the natural language in this
environment).
Thanks,
Guy
"sjeffrey@.gmail.com" wrote:
> Guy,
> I didn't figure out your dll question but I believe this will solve
> your date problem.
> =DatePart(DateInterval.WeekOfYear,Today)
> or
> =DatePart("ww",Today)
> Hope this helps.
> Here's a link to the Visual Basic Run-time Library Members
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vblr7/html/vaoriVBRuntimeLibraryKeywords.asp
> Steve
>|||Why not simply have a reference date table that contains a record for every
date and the week numbers in the record? Then you solve the problem with a
join at the data source. This reference date table has plenty of benefits
as mentioned in other recent posts.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"GuyR" <GuyR@.discussions.microsoft.com> wrote in message
news:4B1CFD27-5D6C-44BA-A07B-D2F186EC4876@.microsoft.com...
> Hi.
> I need to display a date with his serial week number of the year (from
> 1-52
> weeks).
> I wrote a class method that will receive this date and will return the
> corresponding week number, and made a dll file out of it.
> I added this dll as a reference to my report using Report->Report
> Properties->Add Reference.
> Now to the tricky part, how do I embed this code in my report?
> I found some documented material that I need to uncomment the
> <customAssembies> in the rsconfig file. I looked into my config file but
> no
> such <customAssembies> exists.
> Does anyone have an example of how to use external dll and to successfully
> embed them in the report?
> I will highly appreciate any word of wisdom...
> Thanks,
> Guy
>sql

added two more user parameters

I have a stored procedure that works fine in reporting services. It grabs the total of Yes's and No's by dates . But then i went ahead and added 2 more parameters to the proc, and now the totals are all wrong. I dont understand how that can mess everything up. Here is the previous stored proc, that gives the correct sum.

Code Snippet

ALTER PROCEDURE [dbo].[Testing_Questions_ALL_YESOrNO]

@.Question char(80)

AS

BEGIN

SELECT

Qry_Questions.Question

, Qry_Questions.Date

, Qry_Questions.response

, B.Total

FROM Qry_Questions

INNER JOIN Qry_Sales_Group

ON dbo.Qry_Questions.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.Qry_Sales_Group.SalesPerson_Purchaser_Code

INNER JOIN

( Select COUNT(qq.response)as Total, Question, Date, response

FROM Qry_Questions qq

Where qq.response in ('Yes','No')

GROUP by qq.[Question] , qq.Date,qq.response ) B

ON Qry_Questions.Date = B.Date AND

Qry_Questions.Question =B.Question and

Qry_Questions.response=B.response

WHERE Qry_Questions.[Response Type]='YesNo' and Qry_Questions.Question=@.Question

GROUP BY Qry_Questions.question,Qry_Questions.Date,Qry_questions.Response,B.Total

ORDER BY Qry_Questions.Question, Qry_Questions.Date

END

SET NOCOUNT OFF

Here is the edited version which only has two new parameters added to the proc. The edits are highlighted.

Code Snippet

ALTER PROCEDURE [dbo].[Testing_Questions_ALL_YESOrNO_Totals]

(@.Region_Key int=null,@.QuestionCode char(5),@.Question char(80))

AS

BEGIN

SELECT

Qry_Questions.Question

, Qry_Questions.Date

, Qry_Questions.response

, B.Total

FROM Qry_Questions

INNER JOIN Qry_Sales_Group

ON dbo.Qry_Questions.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS = dbo.Qry_Sales_Group.SalesPerson_Purchaser_Code

INNER JOIN

( Select COUNT(qq.response)as Total, Question, Date, response

FROM Qry_Questions qq

Where qq.response in ('Yes','No')

GROUP by qq.[Question] , qq.Date,qq.response ) B

ON Qry_Questions.Date = B.Date AND

Qry_Questions.Question =B.Question and

Qry_Questions.response=B.response

WHERE Qry_Questions.[Response Type]='YesNo'

AND REGION_KEY=@.Region_Key

AND LEFT(Qry_Questions.[Question Code],2)IN (@.QuestionCode)

AND Qry_Questions.Question=@.Question

GROUP BY Qry_Questions.question,Qry_Questions.Date,Qry_questions.Response,B.Total

ORDER BY Qry_Questions.Question, Qry_Questions.Date

END

SET NOCOUNT OFF

Looks to me like when you're calling the SPROC, you're not passing in all of the Region_Key's or all of the possible Question_Code's. The SPROC syntax looks fine, assuming you're sure that the LEFT function is working correctly.

To find out exactly what's wrong, I would recommend isolating your changes one by one. Test the SPROC with only the Region_Key param and see what you get. If it's right, test with only the Question_Code param. Then try together. Problems like this are frequently caused by you not realizing that there are NULLs or blanks in your data, and so when you pass certain parameters, it will exclude other rows and therefore throw off your totals.

Hope that helps.
|||Just to add to above post, you have defined QuestionCode as char(5) in the param list, yet inside the proc you are doing left(question code, 2). You may be truncating some data and comparing with incorrect data.

|||

It's actually giving me a number way too big. A Sum way more then when i take the paramaters out. The Stored procedure works fine for another report i have with the same detail. But when i added these two additional parameters, for some reason it gives me a number way higher then if it didnt have any parameters at all.

|||Could you post the DDL and input params for the updated SP. I am hoping RegionKey is coming out of Qry_sales_Group and is it part of key or does it have multiple rows for the same value?
|||

I got it to work. I figured out that the sub query needed to be changed for this report because i was totaling based on region and question this time.

Code Snippet

INNER JOIN

( Select COUNT(qq.response)as Total, Question, Date, response

FROM Qry_Questions qq

INNER JOIN Qry_Sales_Group

ON Qry_Sales_Group.SalesPerson_Purchaser_Code = qq.sales_person_code COLLATE SQL_Latin1_General_CP1_CI_AS

Where qq.response in ('Yes','No')and Region_Key=@.Region_Key

GROUP by qq.[Question] , qq.Date,qq.response ) B

Thanks for the help. I went and piece every little piece til i relized it wasnt seperating them by regions.

added article to current transactional repl. How to replicate additional article?

Hi, I already have transactional replication setup between two servers
(production server to reporting server).
I have created a new table witha primary key and have added this table as
an article to the publication.
How can i get my setup to take an initial snapshot of the table and apply it
to the reporting server?
Any help most appreciated!
thanks
John
John,
you will need to run the snapshot agent then synchronize. The whole process
from start to finish is:
exec sp_addarticle @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.source_table = 'tEmployees'
exec sp_addsubscription @.publication = 'tTestFNames'
, @.article = 'tEmployees'
, @.subscriber = 'RSCOMPUTER'
, @.destination_db = 'testrep'
Start snapshot agent, start distribuition agent.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Thanks Paul,
Are you saying that I have to take a snapshot of the whole database all over
again?
I thought I could take a snapshot of just the article that has been newely
added to the publication?
In actual fact, the 'Last Action' column on my agent (subsicriber' is saying
"The initial snapshot for article 'myTable' is not yet available"
Many thanks!
John
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:OQ2XvSVEGHA.4000@.TK2MSFTNGP10.phx.gbl...
> John,
> you will need to run the snapshot agent then synchronize. The whole
> process from start to finish is:
> exec sp_addarticle @.publication = 'tTestFNames'
> , @.article = 'tEmployees'
> , @.source_table = 'tEmployees'
> exec sp_addsubscription @.publication = 'tTestFNames'
> , @.article = 'tEmployees'
> , @.subscriber = 'RSCOMPUTER'
> , @.destination_db = 'testrep'
> Start snapshot agent, start distribuition agent.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||John,
if you add a new table and subscription to that table, running the snapshot
agent won't create a complete snapshot - just the new article.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Add/Remove Column/Row Groups dynamically in Reporting Services

Hi
Presently I'm working with OLAP and Reporting Services. In which users
are allowed to drag and drop the dimensions and the measures from the
list available for the cube , On droping of the dimension/measure on
Row/Column. I need to generate the matrix. Is it possible in RS, If it
menas, give me idea on this else notes for how to proceed with this.
Regards
Santhimurthy DessingouIf you're using SQL Server 2005, you could probably do this with the new
Report Builder tool, you just need to create a Report Model with all the
dimensions and measures you need.
Alternatively, try searching for a thread called "RS/MDX - Column Parameter
/ Field name in dataset problem"
Or if you use Google groups, you find it at
http://groups.google.no/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/642b5c0d703335b6/568564e89b6bc038?lnk=st&q=Re%3A+RS%2FMDX+-+Column+Parameter+%2F+Field+name+in+dataset+problem&rnum=1&hl=no#568564e89b6bc038
It's a suggestion on how to create a dynamic report. It's limited by a given
number of columns, but it might be possible to elaborate on the ideas to get
what you want.
Kaisa M. Lindahl Lervik
<santhimurthyd@.gmail.com> wrote in message
news:1140600388.351554.135920@.g44g2000cwa.googlegroups.com...
> Hi
> Presently I'm working with OLAP and Reporting Services. In which users
> are allowed to drag and drop the dimensions and the measures from the
> list available for the cube , On droping of the dimension/measure on
> Row/Column. I need to generate the matrix. Is it possible in RS, If it
> menas, give me idea on this else notes for how to proceed with this.
> Regards
> Santhimurthy Dessingou
>

Add user to R\O Database

I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I? This is a 40 GB database so that would take quite some time to do.
Do you have any suggestions?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***"Toni" <teibner@.SQLallina.com> wrote in message
news:evNCYtFSGHA.5736@.TK2MSFTNGP10.phx.gbl...
>I have a SQL 2000 Enterprise Edition sp4 production database that is log
> shipping to 2 servers (one for DR purposes and the other for reporting).
> On the reporting server, the database is in Read-Only mode. I need to
> add another user to the database so they can run reports. How can I do
> this with the database in read-only mode? I can't take it out of
> read-only because I'll have to set up log shipping all over again, won't
> I? This is a 40 GB database so that would take quite some time to do.
> Do you have any suggestions?
The only way is to add that user to a role that has access... you could
create a server role that has SELECT permissions for all objects, but I'm
not sure that a new role's access would be grand-fathered into an r/o db.
Unfortunately, the only built-in role that leaves you with is sysadmin...
but it's worth a try.
-Mark

> Thank you.
> Toni
> *** Sent via Developersdex http://www.codecomments.com ***

Add User to Log-Shipped Database

I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I?
This is a 40 GB database so that would take quite some time to do.
Do you have any suggestions?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***
You need to add a login for that user on the originating server, add a user for that login on the
originating server and then add the same login on the reporting machine (making sure that the SID
matches).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Toni" <teibner@.SQLallina.com> wrote in message news:uv9UQ5OSGHA.256@.TK2MSFTNGP14.phx.gbl...
>I have a SQL 2000 Enterprise Edition sp4 production database that is log
> shipping to 2 servers (one for DR purposes and the other for reporting).
> On the reporting server, the database is in Read-Only mode. I need to
> add another user to the database so they can run reports. How can I do
> this with the database in read-only mode? I can't take it out of
> read-only because I'll have to set up log shipping all over again, won't
> I?
> This is a 40 GB database so that would take quite some time to do.
> Do you have any suggestions?
> Thank you.
> Toni
> *** Sent via Developersdex http://www.codecomments.com ***
|||The sid! Of course! I made the sid match and everything is perfect!
I'll make sure to put this in my documentation so I don't forget.
Thank you so much!
Toni
*** Sent via Developersdex http://www.codecomments.com ***

Add User to Log-Shipped Database

I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I?
This is a 40 GB database so that would take quite some time to do.
Do you have any suggestions?
Thank you.
Toni
*** Sent via Developersdex http://www.codecomments.com ***You need to add a login for that user on the originating server, add a user
for that login on the
originating server and then add the same login on the reporting machine (mak
ing sure that the SID
matches).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Toni" <teibner@.SQLallina.com> wrote in message news:uv9UQ5OSGHA.256@.TK2MSFTNGP14.phx.gbl...

>I have a SQL 2000 Enterprise Edition sp4 production database that is log
> shipping to 2 servers (one for DR purposes and the other for reporting).
> On the reporting server, the database is in Read-Only mode. I need to
> add another user to the database so they can run reports. How can I do
> this with the database in read-only mode? I can't take it out of
> read-only because I'll have to set up log shipping all over again, won't
> I?
> This is a 40 GB database so that would take quite some time to do.
> Do you have any suggestions?
> Thank you.
> Toni
> *** Sent via Developersdex http://www.codecomments.com ***|||The sid! Of course! I made the sid match and everything is perfect!
I'll make sure to put this in my documentation so I don't forget.
Thank you so much!
Toni
*** Sent via Developersdex http://www.codecomments.com ***

Add User to Log-Shipped Database

I have a SQL 2000 Enterprise Edition sp4 production database that is log
shipping to 2 servers (one for DR purposes and the other for reporting).
On the reporting server, the database is in Read-Only mode. I need to
add another user to the database so they can run reports. How can I do
this with the database in read-only mode? I can't take it out of
read-only because I'll have to set up log shipping all over again, won't
I?
This is a 40 GB database so that would take quite some time to do.
Do you have any suggestions?
Thank you.
Toni
*** Sent via Developersdex http://www.developersdex.com ***You need to add a login for that user on the originating server, add a user for that login on the
originating server and then add the same login on the reporting machine (making sure that the SID
matches).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Toni" <teibner@.SQLallina.com> wrote in message news:uv9UQ5OSGHA.256@.TK2MSFTNGP14.phx.gbl...
>I have a SQL 2000 Enterprise Edition sp4 production database that is log
> shipping to 2 servers (one for DR purposes and the other for reporting).
> On the reporting server, the database is in Read-Only mode. I need to
> add another user to the database so they can run reports. How can I do
> this with the database in read-only mode? I can't take it out of
> read-only because I'll have to set up log shipping all over again, won't
> I?
> This is a 40 GB database so that would take quite some time to do.
> Do you have any suggestions?
> Thank you.
> Toni
> *** Sent via Developersdex http://www.developersdex.com ***

Add Temp Parameters to a function

I am writing a set of functions and then a stored procedure to allow me to view some data in Reporting Services. I have written the first part of the function as shown ;

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

GO

ALTER FUNCTION [dbo].[fnWTRTerrierData]

(@.vch_site_ref nvarchar (3), @.dt_src_date datetime)

RETURNS @.WeeklyTerrierRSPI TABLE

(Areacode varchar(2),siteref nvarchar(3),

estatename nvarchar(100), Securitised nvarchar(255),

unitref nvarchar(15), unittype nvarchar(30),

unittype_count int, tenantname nvarchar(100),

tenantstatus nvarchar(25), tenantstatus_count int,

unitstatus nvarchar(15), unitstatus_count int,

floortotal float, floortotocc float,

initialvacarea float, initialvacnet float,

TotalRent float, NetRent float,

FinalRtLsincSC float, DiscEndDate datetime,

ErvTot float, Leaseterm int,

leasestart datetime, rentreview nvarchar(255),

leaseend datetime, breakclause datetime,

tenancyterm datetime, landact nvarchar(255),

datadate datetime)

AS

BEGIN

INSERT @.WeeklyTerrierRSPI

SELECT Areacode, siteref, estatename, Securitised, unitref, unittype, unittype_count, tenantname,

tenantstatus, tenantstatus_count, unitstatus, unitstatus_count, floortotal, floortotocc,

initialvacarea, initialvacnet, TotalRent, NetRent, FinalRtLsincSC, DiscEndDate, ErvTot,

Leaseterm, leasestart, rentreview, leaseend, breakclause, tenancyterm, landact, datadate

FROM dbo.src_terrier

WHERE (datadate = @.dt_src_date) AND (siteref = @.vch_site_ref)

RETURN

END

I have then written a stored procedure which picks up the result set from the function and ultimately will deliver it to Reporting Services. The problem I have is that as soon as I run the CREATE PROCEDURE script, I get an error saying ;

Msg 216, Level 16, State 1, Procedure spWTRWeeklyTerrierData, Line 16

Parameters were not supplied for the function 'fnWTRTerrierData'.

How can I add parameters to the function sufficently so that I can run the Create procedure element of my code?

Regards

Post your Stored Procedure codes.|||

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[spWTRWeeklyTerrierData]

(@.vch_site_ref nvarchar(3), @.dt_src_date datetime)

AS

BEGIN

SET NOCOUNT ON;

SELECT fnWTRTerrierData.Areacode, fnWTRTerrierData.siteref, fnWTRTerrierData.estatename, fnWTRTerrierData.Securitised, fnWTRTerrierData.unitref, fnWTRTerrierData.unittype, fnWTRTerrierData.unittype_count, fnWTRTerrierData.tenantname,fnWTRTerrierData.tenantstatus, fnWTRTerrierData.tenantstatus_count, fnWTRTerrierData.unitstatus, fnWTRTerrierData.unitstatus_count, fnWTRTerrierData.floortotal, fnWTRTerrierData.floortotocc, fnWTRTerrierData.initialvacarea, fnWTRTerrierData.initialvacnet, fnWTRTerrierData.TotalRent, fnWTRTerrierData.NetRent, fnWTRTerrierData.FinalRtLsincSC, fnWTRTerrierData.ErvTot, fnWTRTerrierData.tenancyterm, fnWTRTerrierData.landact, fnWTRTerrierData.datadate

FROM fnWTRTerrierData

RETURN

END

|||

Looking at a stored procedure I pulled over from a SQL 2000 DB, I took out the elements that seems to resemble the function side

BEGIN

SET NOCOUNT ON;

RETURN

END

But I am still met with the same parameters message when I try to execute the SQL code to create the SP.

Regards

|||

ALTER FUNCTION [dbo].[fnWTRTerrierData]

(

@.vch_site_ref nvarchar (3),

@.dt_src_date datetime

)

Your table function is expecting 2 input parameter which you did not supply.
You will need to supply these 2 value to the function
for example

SELECT ...
FROM fnWTRTerrierData ('?', '2006-01-01')

Add Reporting Services to Trusted Accounts

I installed SQL 2005 SP2 and RS add-in for Sharepoint to a WSS 3.0 site.

I get the error: 'A connection to the server cannot be established' when I try to use the sharepoint account set up for this purpose. It is in the farm administrators, and has the required permissions when I check the database. Are there any other recommended troubleshooting tips that I can do? Thanks.

Dan

FYI - I resolved the problem by adding the account to the local group WSS_RESTRICTED_WPG. This account needs to be in the Local Administrator's group, and the groups starting with WSS.

add Reporting Services to an existing cluster

We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:

start /wait c:\<path-to-setup>\setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmm\xxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmm\xxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1

My question are for:

IP: do i just put the virtual ip and name here, or every ip in the node?

INSTALLSQLDIR: is c drive correct here, or what is this?

INSTALLSQLDATADIR: is c drive correct here, or what is this?

RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?

RSPASSWORD: same as above

SQLBROWSERACCOUNT: what goes here?

SQLBROWSERPASSWORD: same as above

Thanks so much for any help.

I have a erlated question. Would I add Reporting Services like they way you add Integration Services? Using Add/Remove programs? If so, When I try that the choice of Reporting Services is blanked out, not available as a choice to install. How could I get that? Thanks!|||

Reporting Service cannot be installed as a virtual service, i.e., it is not a cluster-component. It can be only installed as a standalone instance. You can add it to an installed instance if that instance does not include Reporting Service. Or you can install it in another new instance. So the command line should be like

start /wait setup.exe /qb ADDLOCAL=RS_Server,RS_Web_Interface INSTANCENAME="xxxxx" RSACCOUNT="<domain\account>" RSPASSWORD="<strong password>" SQLBROWSERACCOUNT="<doemain\account>" SQLBROWSERPASSWORD="<strong password>" RSAUTOSTART=1 SQLBROWSERAUTOSTART=1

See BOL for more information related to command line or template.ini file for more sample command lines.

add Reporting Services to an existing cluster

We have set up SQL Server 2005 failover cluster with 2 nodes, on Windows 2003. I'm now trying to add Reporting Services. I don't see any documentation for how to do this. Is it similar to adding Analysis Services? If I use this command I'm not sure what to put in several paramaters:

start /wait c:\<path-to-setup>\setup.exe /qn VS=<my-virtual-server-name> INSTALL=RS_Server INSTANCENAME=MSSQLSERVER ADDLOCAL=RS_Server ADDNODE=n GROUP="Cluster Group" IP="111.11.11.11,<my-virtual-server-name" ADMINPASSWORD=xxxx SAPWD=xxxx INSTALLSQLDIR=c INSTALLSQLDATADIR=c RSACCOUNT=mmm\xxxxx RSPASSWORD=<domain-user-psswd> SQLBROWSERACCOUNT=<mmm\xxxxx> SQLBROWSERPASSWORD=<domain-user-psswd> SQLREPORTING=1

My question are for:

IP: do i just put the virtual ip and name here, or every ip in the node?

INSTALLSQLDIR: is c drive correct here, or what is this?

INSTALLSQLDATADIR: is c drive correct here, or what is this?

RSACCOUNT: is this correct, not in the example in document ms144259 and what should go here?

RSPASSWORD: same as above

SQLBROWSERACCOUNT: what goes here?

SQLBROWSERPASSWORD: same as above

Thanks so much for any help.

I have a erlated question. Would I add Reporting Services like they way you add Integration Services? Using Add/Remove programs? If so, When I try that the choice of Reporting Services is blanked out, not available as a choice to install. How could I get that? Thanks!|||

Reporting Service cannot be installed as a virtual service, i.e., it is not a cluster-component. It can be only installed as a standalone instance. You can add it to an installed instance if that instance does not include Reporting Service. Or you can install it in another new instance. So the command line should be like

start /wait setup.exe /qb ADDLOCAL=RS_Server,RS_Web_Interface INSTANCENAME="xxxxx" RSACCOUNT="<domain\account>" RSPASSWORD="<strong password>" SQLBROWSERACCOUNT="<doemain\account>" SQLBROWSERPASSWORD="<strong password>" RSAUTOSTART=1 SQLBROWSERAUTOSTART=1

See BOL for more information related to command line or template.ini file for more sample command lines.

add reference reporting service to asp.net application

Hi friends,
I am developing the program reporting services using asp.net.
And I just need to add the reference of reporting services for .net,
so how can i do this?
Have you installed the client tools on your dev box? Also, I normally point to the report on the RS server. Also, in sharepoint there are some webparts that will display your reports on a sharepoint site. Let us know which method you prefer, and we can explain better.|||

Hello Kishor_kurapati,

Go to the Project menu -> Add Web Reference.

In the URL box, navigate to the WSDL location on the report server, typicallyhttp://servername/reportserver/reportservice.asmx

This will give you the reporting service proxy class that you can make calls against.

I have some screenshotshere.

Add many users to Reporting Services

I am looking for a script, query or utility that can add many user's at a
time to a role assignemnt in reporting services.
In the gui - I have tried space delimited, comma delimited... and always get
an error.
trying to add
domain\user1 domain\user2...
ThanksThe easiest way to manage this is by using Windows groups.
You can add windows groups to roles in reporting services.
-Sue
On Fri, 25 May 2007 12:35:00 -0700, Brett S.
<BrettS@.discussions.microsoft.com> wrote:

>I am looking for a script, query or utility that can add many user's at a
>time to a role assignemnt in reporting services.
>In the gui - I have tried space delimited, comma delimited... and always ge
t
>an error.
>trying to add
>domain\user1 domain\user2...
>Thanks

Add Group in Sql Reporting Service 2005

i have made one document print. in i want to give group on document id. i have taken a table for it and added a group in it but the issue is there when the document have only 1 or 3 items the footer part come up. and i want to fix it in page footer. but reporting service i have not found that how to fix group footer in the page end. i have tried with list also but still its not resolved. if anybody can help as early as possible......................thax

what data do you need in the footer? Based on that I can give suggestions.

Shyam

Add Date to Report Name and add server name too

Hi

I am new to MS Reporting Services so do forgive the noobish question.

I am trying to add a date to the emailed excel file. Is there someway to do this? I have schedules a daily file, eg file ReportDocument.xls. Is there someway to make it ReportDocument10/06/2006, ReportDocument10/07/2006, ReportDocument10/07/2006 etc? I've been looking around and I can't find an answer to this.

Any help would be appreciated. Thanks

Thanks

Adrian

You could just enter the date/time the file was created in the subject line. Would that be enough?

Subject = @.ReportName was executed at @.ExecutionTime

|||

Thanks

But I was referring to the excel file attachment name being appended with a date, not the subject line with date being appended. I've looked through the MSDN forum and apparently no one has an answer to this.

|||

Hi,

Besides Subject = @.ReportName was executed at @.ExecutionTime is there any other constants that I could use in the subject text box? I tried @.ServerName and @.ReportServerUrl, it did not work.

Thanks,

Philippe

|||

Sorry Adrian, but I don't think this functionality exists in the current version of Reporting Services with the email subscription.

You could setup a file share subscription and have an application that is polling the folder for new files.

Hope this helps.

Jarret

|||How can I extract just the date (and not time) from @.ExecutionTime.

Thanks,
Ashwin

Add Date to Report Name

Hi

I am new to MS Reporting Services so do forgive the noobish question.

I am trying to add a date to the emailed excel file. Is there someway to do this? I have schedules a daily file, eg file ReportDocument.xls. Is there someway to make it ReportDocument10/06/2006, ReportDocument10/07/2006, ReportDocument10/07/2006 etc? I've been looking around and I can't find an answer to this.

Any help would be appreciated. Thanks

Thanks

Adrian

You could just enter the date/time the file was created in the subject line. Would that be enough?

Subject = @.ReportName was executed at @.ExecutionTime

|||

Thanks

But I was referring to the excel file attachment name being appended with a date, not the subject line with date being appended. I've looked through the MSDN forum and apparently no one has an answer to this.

|||

Hi,

Besides Subject = @.ReportName was executed at @.ExecutionTime is there any other constants that I could use in the subject text box? I tried @.ServerName and @.ReportServerUrl, it did not work.

Thanks,

Philippe

|||

Sorry Adrian, but I don't think this functionality exists in the current version of Reporting Services with the email subscription.

You could setup a file share subscription and have an application that is polling the folder for new files.

Hope this helps.

Jarret

|||How can I extract just the date (and not time) from @.ExecutionTime.

Thanks,
Ashwin

Add Date to Report Name

Hi

I am new to MS Reporting Services so do forgive the noobish question.

I am trying to add a date to the emailed excel file. Is there someway to do this? I have schedules a daily file, eg file ReportDocument.xls. Is there someway to make it ReportDocument10/06/2006, ReportDocument10/07/2006, ReportDocument10/07/2006 etc? I've been looking around and I can't find an answer to this.

Any help would be appreciated. Thanks

Thanks

Adrian

You could just enter the date/time the file was created in the subject line. Would that be enough?

Subject = @.ReportName was executed at @.ExecutionTime

|||

Thanks

But I was referring to the excel file attachment name being appended with a date, not the subject line with date being appended. I've looked through the MSDN forum and apparently no one has an answer to this.

|||

Hi,

Besides Subject = @.ReportName was executed at @.ExecutionTime is there any other constants that I could use in the subject text box? I tried @.ServerName and @.ReportServerUrl, it did not work.

Thanks,

Philippe

|||

Sorry Adrian, but I don't think this functionality exists in the current version of Reporting Services with the email subscription.

You could setup a file share subscription and have an application that is polling the folder for new files.

Hope this helps.

Jarret

|||How can I extract just the date (and not time) from @.ExecutionTime.

Thanks,
Ashwin

Add Date to Report Name

Hi

I am new to MS Reporting Services so do forgive the noobish question.

I am trying to add a date to the emailed excel file. Is there someway to do this? I have schedules a daily file, eg file ReportDocument.xls. Is there someway to make it ReportDocument10/06/2006, ReportDocument10/07/2006, ReportDocument10/07/2006 etc? I've been looking around and I can't find an answer to this.

Any help would be appreciated. Thanks

Thanks

Adrian

You could just enter the date/time the file was created in the subject line. Would that be enough?

Subject = @.ReportName was executed at @.ExecutionTime

|||

Thanks

But I was referring to the excel file attachment name being appended with a date, not the subject line with date being appended. I've looked through the MSDN forum and apparently no one has an answer to this.

|||

Hi,

Besides Subject = @.ReportName was executed at @.ExecutionTime is there any other constants that I could use in the subject text box? I tried @.ServerName and @.ReportServerUrl, it did not work.

Thanks,

Philippe

|||

Sorry Adrian, but I don't think this functionality exists in the current version of Reporting Services with the email subscription.

You could setup a file share subscription and have an application that is polling the folder for new files.

Hope this helps.

Jarret

|||How can I extract just the date (and not time) from @.ExecutionTime.

Thanks,
Ashwin

Add Date to Report Name

Hi

I am new to MS Reporting Services so do forgive the noobish question.

I am trying to add a date to the emailed excel file. Is there someway to do this? I have schedules a daily file, eg file ReportDocument.xls. Is there someway to make it ReportDocument10/06/2006, ReportDocument10/07/2006, ReportDocument10/07/2006 etc? I've been looking around and I can't find an answer to this.

Any help would be appreciated. Thanks

Thanks

Adrian

You could just enter the date/time the file was created in the subject line. Would that be enough?

Subject = @.ReportName was executed at @.ExecutionTime

|||

Thanks

But I was referring to the excel file attachment name being appended with a date, not the subject line with date being appended. I've looked through the MSDN forum and apparently no one has an answer to this.

|||

Hi,

Besides Subject = @.ReportName was executed at @.ExecutionTime is there any other constants that I could use in the subject text box? I tried @.ServerName and @.ReportServerUrl, it did not work.

Thanks,

Philippe

|||

Sorry Adrian, but I don't think this functionality exists in the current version of Reporting Services with the email subscription.

You could setup a file share subscription and have an application that is polling the folder for new files.

Hope this helps.

Jarret

|||How can I extract just the date (and not time) from @.ExecutionTime.

Thanks,
Ashwin