Can You Create A Subscription With A Dynamic Date

May 15, 2007

Hello,



I am curious if you can create a subscription for a report that resides on reports manager with a dynamic date? We have a couple of reports on reports manager that require a date value and I tried to use getdate() for the value but it will not except it. Is there a way to have a subscription do something like this so the end user doesn't have to change the date parameter each time? Thanks in advance.



John

View 4 Replies


ADVERTISEMENT

Dynamic Parameter Values For Subscription

Jan 26, 2008

I have been trying to add in date functions for parameters in a report subscription and they are not accepted. I have a report with 2 parameters, @start and @end. I have default parameters set wtihin the report of Now - month for @start and Now for @end. Can my users create a subscriotion using something like "=DateAdd("D", -1, Now)" for the parameters rather than the default?

View 8 Replies View Related

How To Get Mobile Subscription To Sync With Dynamic Snapshot

Feb 8, 2007

Hello Everyone,

I have a publication on a Sql 2000 (SP4) server. This publication has dynamic filtering enabled. What I want to do is create an interface which will generate a new dynamic snapshot based on filtering input from users. So far I can create the dynamic snapshot easy enough and I can see the filtered results on a Sql 2000 subscriber. However, there seems to be no way to configure a mobile database to point to the dynamic snapshot. This is easy to configure in a Sql 2000 subscription - the options are right there are on the properties page. Yet, it seems like the mobile database only points to the required unfiltered snapshot through the IIS proxy.

Is there any way to force the mobile database to use the dynamic snapshot instead?

Thanks,

Mike



View 6 Replies View Related

Dynamic Create Table, Create Index Based Upon A Given Database

Jul 20, 2005

Can I dynamically (from a stored procedure) generatea create table script of all tables in a given database (with defaults etc)a create view script of all viewsa create function script of all functionsa create index script of all indexes.(The result will be 4 scripts)Arno de Jong,The Netherlands.

View 1 Replies View Related

SSRS -- Data Driven Subscription And Pivoting For Dynamic Parameter Mapping

Feb 12, 2007

Hi,

For the Data Driven Subscription in SSRS we are using the following stored procedure

In Step 3 - Create a data-driven subscription



create procedure spRSGetReportSettings

(

@ReportID as integer

) as

begin

set nocount on

declare @t as table(y int not null primary key)

declare

@cols as nvarchar(max),

@y as int,

@sql as nvarchar(max)

set @cols=stuff(

(select N',' + quotename(y) as [text()]

from (select ParameterName as y from Reportsettings where reportid=1) as Y

order by y

For XML Path('')),1,1,N'');

set @sql=N'select * from

(select reportid,parametername, parametervalue from ReportSettings where reportid= ' + Cast(@ReportID as varchar(5)) +' ) as D

pivot(min(parametervalue) for parametername in(' + @cols +N')) as p'

exec sp_executesql @sql

end



Basically the idea is to maintain a single report parameter setting table for multiple reports.

Structure of the table is as given below

ReportID, ParameterName, ParameterValue.

Using Pivot we can generate the ParameterName/ParameterValue combinations for each report. This stored procedure is working fine in query editors(Management Studio)

But, in SSRS it is giving any results.

In Step 4 - Create a data-driven subscription,

Get the value from the database drop down, I am not getting any database columns.

Please help.

Kumar

View 3 Replies View Related

Cannot Create New Subscription

Apr 18, 2008

I get rsInternalError...

It used to work, but I noticed that my existing email subscriptions stopped working around November...I only have a few...no one complained until now. We also just finished migrating to Exchagne 2k7. I changed the smtp settings in SSRS and the existing subscriptions seem to be mailing again.(one came today to a user who commented on it)(The email subscription issue is probably a totally separate issue related to major config changes in our mail routing etc.)

However, I cannot create any new subscriptions without getting an error. I'm not sure when it started(maybe after SP2?)...a user complained that they could run reports but couldn't generate a PDF for a long running report >15 mins at least and I started investigating the issue.

I looked on some lists and did notice that the SSRS account was not a in the MASTER and MSDB RSExecRole. The role existed in both dbs, but the account wasn't added...not sure if it ever was or if something changed...it is added now. I've restarted the server, etc.

The log entries include(what's kind of weird is that the security log is clean, using windows auth only on sql server, audit failed logins, but tracing the errors below says something about an access denied on 'xp_sqlagent_notify'

Application Log:
Event ID: 108 Report Server (MSSQLSERVER) cannot load the Report Server DocumentLibrary extension.


ReportServer____...Log
w3wp!library!1!04/18/2008-14:53:21:: Call to GetSystemPermissionsAction().
w3wp!library!6!04/18/2008-14:53:21:: Call to GetPermissionsAction(/Microsoft Operations Manager Reporting/Microsoft Windows Base Operating System/Disk Performance Analysis).
w3wp!library!6!04/18/2008-14:53:21:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
w3wp!extensionfactory!6!04/18/2008-14:53:21:: e ERROR: Exception caught instantiating Report Server DocumentLibrary report server extension: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.TypeInitializationException: The type initializer for 'Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider' threw an exception. ---> Microsoft.ReportingServices.Diagnostics.Utilities.OperationNotSupportedNativeModeException: The operation is not supported on a report server that runs in native mode.
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandle& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean fillCache)
at System.RuntimeType.CreateInstanceImpl(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean fillCache)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.RuntimeType.CreateInstanceImpl(BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at System.Activator.CreateInstance(Type type, BindingFlags bindingAttr, Binder binder, Object[] args, CultureInfo culture, Object[] activationAttributes)
at Microsoft.ReportingServices.Diagnostics.ExtensionClassFactory.CreateExtensionObject(Extension extConfig).
w3wp!library!5!04/18/2008-14:53:21:: Call to GetReportParametersAction(/Microsoft Operations Manager Reporting/Microsoft Windows Base Operating System/Disk Performance Analysis).
w3wp!library!5!04/18/2008-14:53:22:: Call to ListSchedulesAction().
w3wp!library!5!04/18/2008-14:53:22:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

ReportServerWebApp____...log

w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!5!4/18/2008-14:52:53:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!extensionfactory!7!4/18/2008-14:53:22:: w WARN: The extension Report Server Email does not have a LocalizedNameAttribute.
w3wp!extensionfactory!7!4/18/2008-14:53:22:: w WARN: The extension Report Server FileShare does not have a LocalizedNameAttribute.
w3wp!ui!7!4/18/2008-14:53:22:: e ERROR: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListSchedules(String Site, Schedule[]& Schedules)
at Microsoft.ReportingServices.WebServer.ReportingService2005.ListSchedules(Schedule[]& Schedules)
w3wp!ui!7!4/18/2008-14:53:22:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An internal error occurred on the report server. See the error log for more details. ---> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. ---> System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.ListSchedules(String Site, Schedule[]& Schedules)
at Microsoft.ReportingServices.WebServer.ReportingService2005.ListSchedules(Schedule[]& Schedules)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.ListSchedules()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.ListSchedules()
at Microsoft.ReportingServices.UI.SharedScheduleDropDown.EnsureSchedulesAreLoaded()
at Microsoft.ReportingServices.UI.SharedScheduleDropDown.SharedScheduleDropDown_Load(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Control.LoadRecursive()

View 1 Replies View Related

Cannot Create New Subscription?

Oct 6, 2005

Hi,

View 4 Replies View Related

Can Not Create New Subscription

Jan 24, 2007

Hi, I have a report that I would like to send out to users automatically every day at 10AM. For some reason on reporting server under the report I would to email, I see 3 folders...Data Source, History & Subscription but I am not able to click on "New Subscription" option in order to create new subscription.

First I created "Shared Schedule" specifing day, time etc information. And then I am tring to create Subscription but the option is disabled.

Is there any service pack I am missing or I am following the wrong procedure.

Please advice.

- Payal

View 1 Replies View Related

Reporting Services :: Data Driven Subscription With Dynamic Email Attachment File Name

Feb 11, 2010

I have report which accepts a card number and fromdate and todate as parameters to the report. This report needs to be sent on a quarterly basis to each of the customer mail id to which their card number is linked. I am getting all this information from a database and sending as an attachment to the customer. Now I would need making these filename's which are attached to be dynamic based on the input parameters.

In datadriven subscriptions, the option of include report has only true or false values and another option was to take from a database. I tried putting the dynamic file name in the database and getting the value from the database but no success, the subscription itself is failing here. I guess I am doing something wrong here by binding the report name from the value which I am getting from DB to the actual report name.

If report name = Mytransactions, and the parameters passed are Card = 123,fromdate = 1/1/2010,todate = 31/3/2010.

Now in the attachment the file name should be something like "Mytransactions_123_January1st2010_March31st2010".
How to make the filename dynamic.

View 9 Replies View Related

Can't Create Subscription Or Schedule

May 20, 2008

When clicking New Subscription (or Manage Shared Schedules) I get the following error:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help






For more information about this error navigate to the report server on the local server machine, or enable remote errors

I can't find any information about this error. Does anyone know what is wrong?

View 13 Replies View Related

Error In Create Subscription Wizard

Dec 4, 2005

When creating a subscription, if there is an error detected at the end - it creates the subscription but might not create the sql agent job, and it doesn't give you a chance to correct the error.

View 3 Replies View Related

Cannot Create Data-driven Subscription

Nov 17, 2006

Hi,

I'm using SQL Server 2005 Developer Edition, which I understand supports Data-driven subscriptions (DDS).

When I try and click on on the DDS button for a report I get the following message:

"Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."

1. I have set the data source to use stored credentials.

2. I'm using one simple string parameter

3. Its not a linked report

Any ideas?

regards,

avner

View 15 Replies View Related

Unable To Create SQL Server Mobile Subscription

May 1, 2006

I have been following Creating a Mobile Application with SQL Server Mobile:

http://msdn2.microsoft.com/en-us/library/ms171908.aspx

I have successfully created the snapshot.

When performing the following:

Configure the publication for Web synchronization






In SQL Server Management Studio, in Object Explorer, expand the (local) computer node.


Right-click the Replication folder, and then choose Configure Web Synchronization

There is no option when Right-clicking the Replication folder under my local server, however there IS an option for Configuring Web Synchronization on the Replication folder under SQL Server Mobile. (Unfortunately the Configure the publication for Web Synchronization is listed BEFORE the SQLServer Mobile Task, so it is pretty confusing) So, assuming this is what the author meant, I successfully configured the Web Server and the SQLMobile shows under my default web site.



When I attempt to create a Subscription under SQLServer Mobile, I get the following error:



- Synchronizing Data (Error)



Messages

Unexpected HTTP status returned. [ 415,status = ]
HRESULT 0x80004005 (28632)


The operation could not be completed.


Am I missing something? Should the web configuration be done on my local SQL Server, not the SQLServer Mobile replication directory? If so, how come I do not have that option as suggested in the directions?

I have checked and rechecked permissions. As I mentioned, the snapshot is successfully created (verified by Right-clicking the publication and viewing the snapshot agent status)



View 9 Replies View Related

Possible To Create Subscription Delivered To A Netware Share?

Jun 14, 2007

I am running SQL Server 2005 Reporting Services. I created a subscription delivered by "Report Server File Share" and the UNC path points to a share on a Netware server. I get the following error when the schedule runs:

Failure writing file Completed.pdf : The network path was not found

The UNC path is \rmh5vol1deptimsoperhiscommon.

I can create the same subscription, but have it write to a Windows file share and everything works fine.

Does SQL Server 2005 Reporting Services support writing to a Netware share?

View 3 Replies View Related

Cannot Create Subscription On Linked Report In SSMS

Apr 7, 2008

I deployed a report I created to Reporting Services using Management Studio. From here I could create subscriptions, if I choose. I created a linked report in a different folder from the original report. I defined all the parameters for this linked report. I cannot create subscriptions for the linked report - the context menu items are grayed out.

Anyone know why this might be happening and what I can do to correct it?

View 1 Replies View Related

Why Can You Not Create A Query Notification Subscription In TSQL?

Sep 13, 2006

The title says it all. You can do it from a ADO.Net client so why not from TSQL.

It all uses the service broker stuff so why not?

View 5 Replies View Related

Increment By Date In A Subscription

Jul 30, 2007

Hi,

Is there a way to auto-increment by date in a data-driven subrscription? I only see a few options and increment by date is not one of them? If not, does anyone have a workaround to publish reports that are increment by date?

Thanks,
J

View 4 Replies View Related

Create Subscription For Rpt Service With Windows Integrated Security !!!

Sep 29, 2005

hi All,

View 8 Replies View Related

Replication :: Failing To Create Subscription For One Node But Working For Other Nodes

Oct 12, 2015

Merge replication fails on one node with error. The merge process could not update the list of subscriptions.

(Source: MSSQL_REPL, Error number: MSSQL_ REPL-2147201010)
Cannot insert duplicate key row in object 'dbo.sysmergepublications' with unique index 'nc1sysmergepublications'.

The duplicate key value is . (Source: MSSQLServer, Error number: 2601)The subscription could not be created.

(Source: MSSQLServer, Error number: 14057) works fine on other subscribers.

View 4 Replies View Related

Reporting Services :: How Subscription ID Will Create In Report Server Database

Oct 19, 2015

We migrated ssrs from 2008 to ssrs 2014.after that we need to move only subscriptions to  New 2014 report server DB.

How to proceed that.

I am trying to insert record in DB. But subscription ID is not identity column. How to do this.

Can I place old Subscription IDS in  New 2014 reporting DB?

View 2 Replies View Related

Adding Date To Filename In Report Subscription

Apr 26, 2007

My company sends reports on a daily basis to our customers. Now I want to save all the sent reports on disc with the date in the filename. I have set up a subscription which daily saves the files where I want them. However, I haven't found a way to add the date easily. I already have a parameter when creating the report, it is called Date. Does anybody know if I can use a parameter or something else?



Thank's

View 10 Replies View Related

Reporting Services :: Setting SSRS Parameters In Subscription For Date Ranges

Jun 4, 2015

I have an SSRS report with parameters for Created On Start and Created On End. Users run this manually and choose the date range to display records for.

I would like to set up two different subscriptions

1) to send weekly on Monday morning for "last weeks" records and
2) to send monthly to send "last month's" records.

View 2 Replies View Related

Reporting Services :: SSRS Custom Start Date Subscription Parameter

Jun 3, 2015

Is it possible to have a custom start date parameter on a report? I would like to have a cumulative daily report for the week, Friday to Thursday. The final daily to run on the Friday, then the next week begins.  I have a enddate, which is today()-1 (for previous day); I need a start date to be variable.

In other words,

On a Monday, report pulls data from last Friday to Sunday;
On a Tuseday, report pulls data from last Friday to Monday,
On a Wednesday, report pulls data from Friday to Tuesday, etc,
until on Friday, the report pulls data from last Friday to Thursday.

View 4 Replies View Related

Dynamic SQL- Create Table

Sep 26, 2001

Is it possible to create a temp table using exec. e.g

exec('create table #temp1 (xyz int, abc int)')

when I run the above statement, I dont get an error but nothing happens.

The reason I need to create it dynamically is that in my stored proc, I am passed a number. This number determines how many columns my temp table should have.
thanks
Zoey

View 2 Replies View Related

Dynamic SQL Create Table

Oct 13, 2005

The following dynamic SQL script works for creating a table on the fly but if I change the select @tmpTblNm = 'tmpABC' to select @tmpTblNm = '#tmpABC'
it will not create the temp table. Can anyone help on creating a temp table dynamiclly?

declare @tmpTblNm varchar(40),
@str varchar(1000)

select @tmpTblNm = 'tmpABC'
select @str = ''

-- Create a temp table to hold the current page of data
-- Add an ID column to track the current row
select @str = 'Create Table '+ @tmpTblNm +
' ( row_id int IDENTITY PRIMARY KEY,
customerID int,
customerName varchar(40),
address1 varchar(40),
city varchar(25) )'

exec (@str)

View 1 Replies View Related

Dynamic Create Table

Apr 2, 2007

Hi guru !!

I want to create a table that can created dynamicly based on front end application.table should handle insertion and edit also. please help me to get out of this situation.

thanks
shekhar

View 2 Replies View Related

How To Create Dynamic Controls In Wpf + C#

Nov 5, 2007

Hi,

i want to create dynamic controls using wpf and c#.

can any body send me some code snippet.

for example:-

one of my window page have 100s of fields like textbox, checkbox and date controls in a group inside different grid and panel.

now if admin has made that amoung 100 fields user should be able to see only 20 or 30 fields.

how will i do so, just making the fileds invisible won't work, coz all the fields should be visible from top of the form,

means i want to push all the visible fields at the top.

what are the best way to do so.

need it urgent

thanx a lot


View 3 Replies View Related

Create Dynamic Table From CSV

Apr 3, 2007

Hi,

I'm trying to import a csv file directly to my database every month. The contents of the file stays the same, however the format of the columns may vary. For example, 1 month I can have the following:

Time, Probe1, Probe2, Probe3, Probe4

Whereas the next month I can have something like this

Time, Probe2, Probe3, Probe1, Probe4



The "Time" column will always be on the left side, but the probes may vary in their placement.

I'm importing this csv to a temp table, where I then run a query to select any new data and enter that in my main tables. The problem is that when i import the csv, if the placement of the columns has changed, the data gets entered in the wrong locations.

Is there any way to create this temp table dynamically, based on what the header columns of the csv file are?

Any help appreciated!

View 11 Replies View Related

How To Create Dynamic T-SQL Clause

May 6, 2008

Hi,


I have a project which is need dynamically t-sql clause...I've created interface for the create dynamic t-sql clause.
But the clause should get data from relational database. It needs inner join...so it's very hard to do it..

for example


lkpProduct

id product
1 Mouse
2 Keyboard

3 Modem
4 Monitor


main

id productid

1 4
2 1
3 2
4 3
5 4

You can get this table with 2 ways like this..

1. Select main.id, lkpProduct.product from main,lkpProduct where main.productid = lkpProduct.id
2. Select id, case productid when 1 then 'Mouse'.....end as product from main

mytable

id product
1 Monitor
2 Mouse
3 Keyboard
4 Modem
5 Monitor


My question is; how can i use CASE function dynamically ?? Mouse should get from lkpProduct....I do not want to write long table manually..

I hope it is clear for you..

Regards.

View 4 Replies View Related

Dynamic Create Table

Oct 30, 2006

Hi,

I need to create a table....whose column names should be dynamic...I wouldnt know in advance what the column names would be...These coulmn names are availabe in another table as rows...

Ex: TABLE_A Data

Column Names

Col1

Col2

Col3

Col4...

Some column Names are known already...I need help in writinf the Create table statement..

I need to write something like

Create table Table1

(SerialNo int,Name nvarchar(50)+ AS select * from TABLE_A +

Address nvarchar(500))....



Now the Table1 should look like

Serial No Name Col1 Col2 Col3 Col4 Address



Can some one please let me know how can i accomplish this...I know i need to write a Dynamic Query but dont exactly know ho to write it and execute it....

Thanks

View 7 Replies View Related

How To Dynamic Create Bit Field On Sql

Apr 10, 2008



Hi

In Sqlserve we can create dynmic field on sql like:

Select '' as Name from Employee.

It creates a string field.

I want to how to create a Bit field in this way.

Regards
Deepak

View 1 Replies View Related

How To Create Dynamic Columns In Sql Database

May 3, 2008

hi,
in the front end i have two fields one is dropdown list another is checboxlist say dropdownlist consist of title name and checkbox list consists of sub title name.on selecting title name from dropdownlist i will be getting respective title name in checkboxlist. here when i select checkboxlist(suppose if there are 6 items in checkboxlist n if i select only 3)then my databse column should generate one dropdownlist selected item and 3 checkboxlist selected item.

Eg: if dropdownlist contains( title1,title2,title3) and checkboxlist contains(chk1,chk2,chk3,chk4,chk5,chk6). if i select title1 from dropdownlist i will be geeting 6 item in checkbox list) if i select only 3 items of checkbox list. then i should be able to create column name by title1,chk1,chk2,chk3


help is appreciated

View 1 Replies View Related

Best Way To Create Dynamic Update Statement

Jul 23, 2005

In general, What is the best approach in creating a dynamic updatestored procedure, that can handle recieving varying input paramters andupdate the approporiate columns.

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved