Showing posts with label services. Show all posts
Showing posts with label services. Show all posts

Thursday, March 29, 2012

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

Thursday, March 22, 2012

Adding a column to a Fact table in Analysis Services 2000

How do you add a column to a fact table?

I added a column to the SQL table that the cube is based on "FactVoyage". I then went to Analysis Manager refreshed everything, and edited the cube. the table "FactVoyage" shows on the Schema tab, but the new column does not appear. I presume there is some trick apart from deleting the Table and reinserting it?

Thanks

Ignore that! There is something totally dodgey with the datasource so I need to fix that first

Tuesday, March 20, 2012

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.

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
>

Monday, March 19, 2012

Add user to Local Group Error

Guys,

I need help installing SQL Server 2005. I meet all of the pre-req's and setup seems to run normally until it starts installing the services and database engine. I receive the following error:

SQL Server Setup was unable add user NT AUTHORITY\NETWORK SERVICE to local group SQLSERVER2005DTSUser$server.

It repeats the error for for the other groups that are created with SQL install.

Am i missing something that's obvious? I couldn't find anything in the documentation or anywhere else.

Here are a couple of things to try:

1. Check the installation log files, located at %Program Files%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more details on the error.

2. Try to add the service manually to the local groups using the Computer Management Admin tool. Then re-run setup.

Paul

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')

Sunday, March 11, 2012

Add services to SSIS IServiceProvider model?

Is there any mechanism for being able to add custom services into the SSIS service provider model so that they can be used by components at design and runtime? i.e. if I can currently access service implementations such as the IDtsConnectionService from the Initialize method of a custom component (or in a UI type editor), is there a way to add a service of my own?

Thanks

Interesting - we've never thought about this. What kind of services do you plan to add there? Note that the services are for design time only, they are no available at runtime.|||

Thankyou for the response - actually design-time only services would still be useful in this case - I'm writing custom components against a JD Edwards Oracle database, but I'm having to interpret the data dictionary schema for business users to assist them in writing their queries (it has to be available offline).

I currently have metadata available to the components so that they can present meaningful field information to users before it is mapped onto the underlying schema, but it would be extremely useful if my components could utilise a service that wrapped this metadata functionality for them.

Add role to Analysis Services Database

Does anyone know if there is a way to use a SSIS task to add a role to SSAS cube? At the moment I use Management Studio, Right Click "Roles" under the cube and go through New Role wizard, but I'd like to be able to include this in a SSIS package instead.

Thanks

Richard

You can do it through the Script task, employing the AMO (Analysis Management Objects) library. I recommend creating the role in SSMS first but instead of submitting the change to the system, clicking the Script button at the top of the New Role dialog box to view the XMLA\ASSL script it creates. The script can be a guide for your AMO development (as AMO is just a wrapper for the XMLA\ASSL languages).

Good luck,

Bryan

|||

Following along with what Bryan had mentioned you could script a role using Management Studio to use as a template then use and expression variable and an Analysis Services Execute DDL Task in SSIS to accomplish this as an ongoing solution. The Analysis Services Execute DDL Task will allow you to customize and execute the role creation/modification command and avoid having to use the script task.

Hope that helps!

|||

Thanks! Wow. Cool. Kind of got it to work but don't know quite how!

In SSMS scripting the role worked nicely and was able to run it in a query window and it did exactly what was needed.

I'm pretty useless at VB.NET so trying the Script Task in SSIS, I hit design script, added AMO as a reference and pasted the SSMS script where it says "Add your code here" inside of Public Sub Main(). Of course it doesn't work that simply. But is there a really simple answer to what I need or am I going to have to go off and learn some VB.NET ?

So then I tried Execute DDL task, and muddled my way around it. I save the original script as a .xmla file in the file system. Then in DDL task under DDL selected File Connection as SourceType and connected to this file. Executed task and it did what was needed.

I guess this is good enough as it works, but I wouldn't mind understanding better what I am doing!!

Thanks

Richard

|||

Here is a code sample from a past project where we created a role for each entry in a table. (Just sharing that last part so you understand the database query in the code.)

Code Snippet

' Microsoft SQL Server Integration Services Script Task

' Write scripts using Microsoft Visual Basic

' The ScriptMain class is the entry point of the Script Task.

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Math

Imports Microsoft.SqlServer.Dts.Runtime

Imports Microsoft.AnalysisServices

Public Class ScriptMain

Public Sub Main()

Dim server As New Microsoft.AnalysisServices.Server

Try

' CONNECT TO THE SQL SERVER ANALYSIS SERVICES (SSAS) SERVER

server.Connect("localhost")

' THE SSAS DATABASE TO CONNECT TO

Dim database As New Microsoft.AnalysisServices.Database

database = server.Databases.FindByName(Dts.Variables("AnalysisServicesDatabaseName").Value.ToString)

' GET A LIST OF ROLES TO CREATE

' Connection String comes from the 'METADATA' Connection Manager

Dim myConnection As New SqlConnection(Dts.Connections.Item(0).ConnectionString.ToString())

Dim myCommand As SqlCommand = New SqlCommand("SELECT ID FROM dbo.Roles (NOLOCK) WHERE ID > 0", myConnection)

myConnection.Open()

' FILL THE DATAREADER

Dim dr As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

' LOOP THROUGH THE DATAREADER AND BUILD A ROLE

If (dr.HasRows) Then

While (dr.Read())

CreateRole("Role for ID ", dr("ID").ToString, database)

End While

End If

' CLOSE THE DATAREADER

dr.Close()

' CLOSE THE SQL SERVER DB CONNECTION

myConnection.Close()

Dts.TaskResult = Dts.Results.Success

Catch ex As Exception

Dts.Events.FireError(1, ex.TargetSite.ToString, ex.Message, "", 0)

Finally

' DISCONNECT THE SSAS SERVER

server.Disconnect()

End Try

Dts.TaskResult = Dts.Results.Success

End Sub

Private Sub CreateRole(ByVal rolePrefix As String, ByVal dsNumber As String, ByVal asDatabase As Database)

Try

' WILL CREATE A ROLE IN THE ASSIGNED DB WITH THE NAME AND KEY VALUE

Dim newRole As Role

' CREATE THE NEW ROLES NAME

newRole = asDatabase.Roles.Add(rolePrefix + " " + dsNumber)

newRole.Description = "Role for " + rolePrefix + " " + dsNumber

newRole.Update()

Catch ex As Exception

Throw New Exception(ex.Message.ToString())

End Try

End Sub

End Class

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.

Thursday, March 8, 2012

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.

Tuesday, March 6, 2012

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

Saturday, February 25, 2012

Add events as one batch

Hi,

Can I add collection of events to notification services from my .NET application?

Current implementation in my code:

Code Snippet

// create a new event and event collector

Event myEvent = new Event(application, eventClassName);

EventCollector eventCollector = new EventCollector(application, EVENT_CREATOR);

// Set field values of the event.

.

.

.

// add the event

eventCollector.Write(myEvent);

// commit the 1-event batch

eventCollector.Commit();

Let me know how can I commit collection of events at once rather than one by one.

Please give me your suggestions on this whether this can not be achieved or NOT.

Thanks in advance

Yogendran

Ah... Guys do you know where I can get the answer for this question?

Please help me.

Do you think this cann't be done?

Regards

Yogendran

Friday, February 24, 2012

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

add date range filter - brand newbie to reporting services

I've used report wizard to create a report - one of the fields in the report is a date field. I simply want a From Date: and To Date: filter which enables a user to select a range of dates to filter results. I know how to do this in .Net, but am not sure how to achieve this in RS. If anyone could shed some light, or point me to an thread which describes a similar process, I'd appreciate it.

thx

If you are using Visual Studio then for the data source your query should be just like a stored procedure with a parm...

Select col1, col2

From tbl1

Where col1 = @.parm1

When you open the report in Report Manager it should have a space for you to type in the value.

Now if you are using Report Builder then I don't know as I'm here looking for that answer myself.

|||

If you are using the report builder you just put the following the filter column for the date field.

Between @.SDate and @.EDate

Then go to your report parameters (right click on the upper left corner of the layout)

Click on each parameter SDate and EDate and set the type to Date/Time. It defaults as a string.

Hope this helps.

Jen