Undo Functionality In Data Driven Application
Sep 17, 2007
Hi,
I am in a process of designing a web application (ASP.NET) which is mostly data driven. The application needs to provide an undo functionality to users for eg. Undo an Add, Update or Delete that has been already committed to the database.
We are using SQL Server 2005 at back end. What I need to know is how will I enable this feature at database level. I am sure we might have to play with triggers but that too might not help in achieving the UNDO functionality. If anyone can shed light on how to achieve this, it will be quite helpful. Thanks
View 7 Replies
ADVERTISEMENT
Jun 11, 2015
I am trying to find a reference for a client that lists the fields available to be substituted into a data driven subscription from the query, along with the expected data types. For example, the field on whether or not to include a link to the report seems to be expecting a bit data type.I have searched and can't seem to find anything. I guess I could walk through the interface and try different data types, but if a list exists, that would be better.
View 4 Replies
View Related
Jul 28, 2015
get the data from report to create data driven SSRS Subscriptions,
write query :
Running Report:
View 5 Replies
View Related
Aug 24, 2007
I have a stored procedure that receives an input parameter of ReporID and then sends back the appropriate dataset to the data-driven subscription. In the stored procedure, there is some concatenated sql in producting the final select statement to send to the subscription, but it is generating the following error:
The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Get Online Help
Insert Error: Column name or number of supplied values does not match table definition.
Because there are some optional columns that need to conditionally appear based on the report, I can't avoid concatenation. My only other option is to have hundreds of individual tables to source all our reports, which I don't have time to manage.
Please let me know how I can allow the data-driven subscription setup process to discover the columns for my concatenated SQL so I can seutp my schedules based on the single stored procedure with all my logic nested in my table structure.
Thanks.
View 7 Replies
View Related
Sep 22, 2000
Hi,
Can anybody help me with this? I have tried this and got confused big time.
Can you point me in the right direction please?
TIA.
Barath
View 2 Replies
View Related
Apr 19, 2000
Hello;
I need to create a data driven query task where the destination is a view. The option to select a view is only available for the source.
I have created a view because the first attempts to create a data driven query againt the required table (db is over 4000 tables, 4 GB of data)resulted in workstation lockups.
Thank you.
Barb
View 1 Replies
View Related
Jan 19, 2007
I have a question has anyone seen a Webbased Database made with Frontpage 2003 before???
View 2 Replies
View Related
Jun 13, 2007
I have vb code that I am triggering a Data Driven Subscription.
The problem I am having is that I need to wait for the Subscription to finish before I go on to the next line of Code.
I am Currently using SQL to query the Subscriptions table in the ReportServer Database. I am Checking the LastStatus field to see if the Subscription is done. But I've noticed that it doesn't always update the field when the Subscription is finished.
for example some times that field will stay "Pending". Is there another way that i trap for the subscription being complete?
View 1 Replies
View Related
Sep 23, 2007
Hello there,
How/Where can i check the error i get when i send report by email.
cheers
zolf
View 4 Replies
View Related
Dec 21, 2006
I have create a data driven subscription that should email to to different people. It is sent to one but not the other. if I set up a normal subscription to the email it works. I can not see anywhere in the log the problem. Any Ideas on how to find out what is causing it.
View 8 Replies
View Related
Dec 29, 2006
I am using vb .net 2003 with msde.
I have downloaded microsoft`s vbsdk setup and have it working pretty well until I get to the login page and the provided credentials will not work.
The sample tells me to set permissions in the dacl editor.
1:What is the dacl editor and how do I use it?
2:What do I set permissions to?
I have been through the code provided over and over and can`t seem to find anything wrong,So I figure maybe this is the problem.
Any help will be appreciated.
Davco
View 1 Replies
View Related
Jan 8, 2007
Hi
I migrated my system from SQL2000 to SQL2005, now my MDX reports don't want to work with the data-driven subscriptions. The SQL reports run fine.
Any help, comments, or even suggestions will be very welcome.
Kind Regards
Carel Greaves
View 12 Replies
View Related
Feb 22, 2007
Is it possible to copy an existing Data Driven Subscriptions and make some minor changes?
Elias
View 1 Replies
View Related
Jan 8, 2007
I am using Reporting Services 2005 locally for testing purposes and also on a production server. Locally, I can create data-driven subscriptions, but not on the server. The only difference I can think of between my local test environment and the production server is the versions of SQL server database. Locally, I am using SQL server 2005 but on the server I am using SQL server 2000 (but with Reporting Services 2005). Can the version difference be the reason for not being able to use data-driven subscriptions?
Note: I have followed various guidelines and walkthroughs that describe how a data-driven subscription is created, i.e. stored credentials on the report server and such should not be the problem.
Operating systems: locally; Windows XP. Server; Windows Server 2003.
Thanks!
/Stefan
View 8 Replies
View Related
May 15, 2008
Hi
I created a new data-driven subscription which successfully created a guid job on the server under jobs. So, I run the job and I get no report emailed to me. On the report manager all it says is I have 1 error. I cant figure out what the error is and where do I go to see what the error is? I know it is in some log file under MSSQL, but I dont know which log file and what I should be looking for in that log file. Any help is appreciated.
I guess, in summary, how do I debug a data-driven subscription?
View 1 Replies
View Related
Jun 13, 2007
I'm very new at this and found this video very helpful. I downloaded Visual Web Developer 2005 Express Edition and following the direction except for changing a few column names. When I get to the point of viewing in browser I get the drop down box but nothing in it and the table doesn't show up either. I copied all the data to my website and tried to view it there but got some error that I don't understand. Can someone please help. The website I uploaded the files to is ocbeachrentals.net/default.aspx. Thanks.
View 1 Replies
View Related
Aug 3, 2000
I'm trying to perform a simple DTS tassk and am having no luck. All I'm trying to do is to run a task that will delete rows from an Access table. I presume I have to create a Data Driven Query in order to do this, but I can't seem to get the formula just right.
Can someone shed some light on the subject, please? BOL says little to nothing about how to set up a simple task. Microsoft.com is also pretty lsackluster with regards on what to do.
Again, thanks for any help.
Anthony Robinson
View 4 Replies
View Related
Jul 1, 1999
I would like to use a Data Driven Query Task to conditionally update/insert some data from a source table into a dest. table, but I can't find any decent doc or examples on this. Is there any place that explains in gory detail how to use these DTS tasks?
Thanks,
Patrick
View 1 Replies
View Related
Mar 27, 2004
I use a data driven query task to perform row updates along with appending row data to a text file. In the source I use 'select top 1000 field1, ..., fieldn from table'. The package hangs when executing the data driven task. If I reduce the return count to 'select top 100...' the package execute with no problems. I can do that 10 times, with no problems. But anything more then 100 will hang the package at that task. Please help!
Thanks,
Monique
View 1 Replies
View Related
May 30, 2007
I created a data-driven subscription for my report with "Null Delivery Provider" set in report manager. I set the processing to "On a schedule created for this subscription" and scheduled the report to "run once" in the next 1 minute so I could test it. The subscription added successfully, but I don't see the "last run information" even after 5 minutes. Am I missing something?
Thanks in advance!!!
View 1 Replies
View Related
Feb 17, 2008
Hi experts,
i am asked to check data driven errors while importing data from an excel workbook to a sql server table.
what are the data driven errors expected and how to introduce that in this sql code.
SELECT a.* FROM OPENROWSET(BULK 'Microsoft.Jet.OLEDB.4.0',
'Excel8.0;Database = C:DataExTestVista_Logo_Product_List_20080204.xls',
'SELECT * FROM [RAW Data$]'
, FORMATFILE = 'D:format.fmt') as a
Thanks in advance.
View 3 Replies
View Related
Dec 10, 2007
Hello,
Any help is greatly appreciated...
SQL Server Reporting Services 2005. I have a data-driven subscription that executes weekly and had been executing just fine until this past execution. In the Subscriptions tab of the Report Manager web interface the Status says:
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Now, the stored procedure that returns data for the subscription has never taken more than about half a second to run (it does not return much data; only 55 records, and it is efficient and optimized). The timeout interval was 30 seconds, but I increased it to 300 seconds just in case...same result when I reschedule to subscription.
None of the procedures which return data for the actual report (there are six of them) takes more than 1 second to execute either, and I can generate the report from the RS web interface just fine; this only fails and gives a Timeout when I try to schedule the report on the data-driven subscription.
Is there any way to tell WHERE the timeout occurred, what step or process? I ran a Profiler trace of all activity on the ReportServer database after re-seheduling the subscription, and saw nothing that seemed unusual. I see the timeout error in the log file "ReportServerService__12_10_2007_00_06_03.log", but no useful details.
Has anyone else encountered this issue, or similar? Please let me know if there's anywhere else I might check.
Thank you,
Ethan
ewiers@heritageacademies.com
View 2 Replies
View Related
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
Nov 16, 2006
I have a data-driven subscription that launches once a day and delivers
emails to subscribers. The problem is that it delivers only about half
the emails. It runs ok and then it produces error. I ran it once and it
ran ok and completed without errors. 20 minutes later it produced
errors. Log looks like this:
ReportingServicesService!library!c!11/16/2006-10:27:45::
i INFO: Call to RenderFirst( '/Subscribed notifications/Subscribed
notifications' )
ReportingServicesService!library!11!11/16/2006-10:27:45:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., AuthzInitializeContextFromSid:
Win32 error: 58;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
ReportingServicesService!library!c!11/16/2006-10:27:45:: e ERROR:
Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information., AuthzInitializeContextFromSid:
Win32 error: 58;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
ReportingServicesService!library!11!11/16/2006-10:27:45:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in
Server system properties.
ReportingServicesService!library!c!11/16/2006-10:27:45:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in
Server system properties.
ReportingServicesService!emailextension!11!11/16/2006-10:27:45:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The
report server has encountered a configuration error. See the report
server log files for more information. --->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at
Microsoft.ReportingServices.Library.RSService.GetReportAndDataSourcesForExecution(ClientRequest
session, CatalogItemContext itemContext, String queryParametersXml,
Boolean& hasData, DataSourceInfoCollection& dataSources,
String& reportProperties, ReportSnapshot& intermediateSnapshot,
Guid& reportId, ReportSnapshot& snapshotData, String&
description, Boolean& cachingRequested, DateTime&
executionDateTime, DateTime& expirationDateTime, Int32&
execOptions, Boolean& foundInCache)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType
type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
ReportingServicesService!emailextension!c!11/16/2006-10:27:45:: Error
sending email.
Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The
report server has encountered a configuration error. See the report
server log files for more information. --->
Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException:
The report server has encountered a configuration error. See the report
server log files for more information.
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at
Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String
userName, IntPtr userToken, Byte[] secDesc, ReportOperation
requiredOperation)
at
Microsoft.ReportingServices.Library.RSService.GetReportAndDataSourcesForExecution(ClientRequest
session, CatalogItemContext itemContext, String queryParametersXml,
Boolean& hasData, DataSourceInfoCollection& dataSources,
String& reportProperties, ReportSnapshot& intermediateSnapshot,
Guid& reportId, ReportSnapshot& snapshotData, String&
description, Boolean& cachingRequested, DateTime&
executionDateTime, DateTime& expirationDateTime, Int32&
execOptions, Boolean& foundInCache)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType
type, Warning[]& warnings, ParameterInfoCollection&
effectiveParameters, String[]& secondaryStreamNames)
at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
at
Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage
message, Notification notification, SubscriptionData data)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification
Any ideas? Am running SQL Server 2005 with SP1.
View 5 Replies
View Related
Jul 20, 2007
I have created a report and published it on the reporting server. My connection is working, and I have followed the steps in the BOL tutorial for "Defining a Data-Driven Subscription" i.e. Credentials stored securely on report server, using windows credentials when connecting to the data source. When I click on "Subscriptions", I only see "New Subscriptions". However, when I look at other reports (not even created by me), I see the option to create data driven subscriptions. Can somebody tell me what I need to do to see this?
View 1 Replies
View Related
Nov 23, 2007
We have SQL2005 sp2
I created data driven subsription
sending email "Sent to " to particular address like Theodore Johnson @bliablia.com , it works fine
we use facsys application
from outlook email sent like [FACSYS: Theodore Johnson @ +1 (333) 555-5555] ,it works fine
I changed email "Sent to " value for subscription on [FACSYS: Theodore Johnson @ +1 (333) 555-5555]
Report shows as executed with errors ,fax no sent and no entry in Report log files or facsys application log
Do reporting services verifying email addresses ?
Why is no enty in log files?
View 1 Replies
View Related
May 22, 2007
hi all,
i built my report with BIDS, configured my datasource and report. then i deployed it. on http://localhost/reports, I to go to the Report, but under "subscriptions", I don't see the "create data driven subscriptions" button.
however, under properties/datasources of my report, I clearly configured the
"Credentials stored securely in the report server"-setting.
Did I forgot something??????
Thx
View 3 Replies
View Related
Jan 11, 2008
I have set up a data driven subscription for a report, and against "Reply-To" I have selected "Specify a Static Value".
I have then I have entered a valid email address.
When the report is received however, and the recipient clicks reply, the reply address is filled in as the Email Address from which the report was sent.
Is this a bug with the "Reply-To" functionality? Or do I have to do this a different way?
Thanks :-)
Kate
View 2 Replies
View Related
Oct 1, 2007
I am trying to go through the MS tutorials on creating Data-Driven Subscriptions.
http://technet.microsoft.com/en-us/library/ms169673.aspx
I have followed the steps multiple times but when I go to add the Data-Driven Subscription, the option is disabled. The report's datasource is setup to use stored credentials and the server Mail is setup. Is there another prerequisite that I'm missing?
View 1 Replies
View Related
Nov 6, 2007
please help, when I access my report and click on the subscription tab, on the top page i only see the "new subscription" button. I also tried creating a data driven sub in sql manger but it was disbaled. please help how to correct this one.
thanks
View 3 Replies
View Related
Nov 27, 2007
Hi need to create navigation that gets populated via database and is role based. below is the sql
CREATE TABLE [TopMenu] (
[MenuID] [int] IDENTITY (1, 1) NOT NULL ,
[Text] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Description] [varchar] (255) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ParentID] [int] NULL ,CONSTRAINT [PK_Menu] PRIMARY KEY CLUSTERED
(
[MenuID]
) ON [PRIMARY] ) ON [PRIMARY]
GO
INSERT INTO TopMENU
Select 'Property','Property', NULL
UNION ALL Select 'Portfolio','Portfolio', NULL
UNION ALL Select 'Capital Expenditure','PortfolioCapex', 1
UNION ALL Select 'Depreciation','PortfolioDepreciation', 1
UNION ALL Select 'Condition Audit','PortfolioCondition', 1
UNION ALL Select 'Historical Expenditure','PortfolioHisEx', 1
UNION ALL Select 'Property Details','PropertyDetail', 2
UNION ALL Select 'Assets','PropertyAsset', 2
UNION ALL Select 'Depreciation','PropertyDepreciation', 2
UNION ALL Select 'Capital Expenditure','PropertyExpenditure', 2
UNION ALL Select 'Insurance','PropertyInsurance', 2
UNION ALL Select 'Documents','PropertyDocuments', 2
UNION ALL Select 'Capex','PortfolioCapex', 3
UNION ALL Select 'Graph','PortfolioCapexGraph', 3
UNION ALL Select 'Graph','PortfolioDepreciationGraph', 4
UNION ALL Select 'Current Depreciation','PortfolioDepreciation', 4
UNION ALL Select 'WDV & Depreciation','PortfolioDepreciationWDV', 4
UNION ALL Select 'Assets','PropertyAsset', 8
UNION ALL Select 'Capex','PropertyCapex', 8
UNION ALL Select 'Depreciation','PropertyDepreciation', 8
UNION ALL Select 'Condition','PropertyCondition', 8
UNION ALL Select 'Expenditure','PropertyExpenditure', 8
UNION ALL Select 'Disposed','PropertyDisposed', 8
UNION ALL Select 'Capital Ex','PropertyExpenditure', 10UNION ALL Select 'Capital Ex Graph','PropertyExpenditureGraph', 10
GO
now clearly, I will have two top level navigation
property and portfolio. both property will have subsequent navigation and those subsequest navigation may or may not have another sets of navigation.
I need to display in a row style not in a drop down style for eg. If I am in portfolio link the navigation structure should be as below
Portfolio
Capital Expenditure | Depreciation | Condition Audit | Historical Expenditure
Capex | Graph
by default Capex should be selected. it should also highlight Portfolio, Capital Expenditure and Capex as Capex's parent is Capital Expenditure and Portfolio
I was thinking of using a 3 level datagrid. could someone please help me I am using asp.net 2.0 web application project with vb.net and sql server 2005
thanks in advance
View 9 Replies
View Related
May 20, 2004
Hi, I'm trying to get a Data Driven DTS task to update a table based on a .csv source file. I've got a numeric ID Identity column (unique) to give me a record number, and I'm using the following code on the update query to try and update the relevant record:
UPDATE [DR-TestDB].dbo.[Test - CustAddress]
SET
County = ?
WHERE (ID = ?)
The problem I'm getting is a conversion error from VarChar to Numeric when I run the task. I've tried using a type conversion in the transformation, but that doesn't appear to help.
Anyone know the answer - I'll bet it's simple :)
Cheers,
Menthos
View 1 Replies
View Related
