I created a base report that covers most of my reporting requirements. I created linked reports using different parameters. Is there a way to transfer linked reports from my development report server to the production report server?
I would have used report models but my system architecture uses a different database for every customer. I use a custom connection expression to determine the database by User ID.
my problem is about the slow execution of a query.
I have two database located in two different servers. The servers are linked with the linked server connection made with the enterprice manager.
The databases structure is the same and I copy some data from a database to the other with the following query:
INSERT INTO DATASERVER.RESULTS.dbo.Tab_Tests SELECT * FROM LINESERVER.WIP.dbo.Tab_Tests WHERE ID_Result = '{76271FC1-9470-4EF7-A403-000CF75C2215}' OR ID_Result = '{08C8EEB9-CD22-4CF9-8269-8C1CC58C752B}' OR ID_Result = '{B7B7EED1-36E4-48FA-9636-ABBE62AAE04D}' OR ID_Result = '{8F7BA69E-D2CE-4EB2-BBC4-AFFA165CE0CE}' OR ID_Result = '{273CB805-945F-4EFA-AE20-BC4E0898A19F}'
Everything works till the database grows up more than 400 MB.
Also if I select one result, that consist of some records, the query is very slow and the CPU is working over the 75 %.
I ask you if my working way is corret or if you have some solution or some explanation for me.
Perhaps i'm missing something but when i update the master report and then go and run the linked report, it's not updating? Is this a known issue?
If i update the master and re-link the linked report, then all is well? Shouldn't the linked report reflect the master report in real-time and i shouldn't have to re-link the report?
Hi, I have a report in one folder in Report Manager. Let's call that the 'base' report. I've created a linked report with that 'base' report to another folder. When I go into Visual Studio BIDS, change the report and deploy it to Report Manager, only the base report changes. The linked report does not change.
Is this by design? I thought linking reports gave you the ability to have a base report and numerous other linked reports, all of which would also change if you changed and redeployed the base report. Is that not the case?
Having just discovered that linked reports do not retain any print formating applied to the original report I thought I'd check out the forum and see if it was just me having a senile moment or if Microsoft had in fact dropped a clanger of massive proportion.
After reading one or two questions from other RS users it does seem as if Microsoft have stuck again and completely diminished a useful feature by stripping it of anything, well....... useful. Well done MS, you once again have my applause for mind-boggling ineptitude of what should be impossible magnitude. Ah, you've got to laugh.
Maybe this and other bugs with RS2005 will be ironed out in Microsoft Reporting Services 2008 - The Search for More Money.
we have a problem with linked reports. We are using the same reports that are run on about 70 different Oracle schemas. The credential information is passed when calling the report. This works fine for reports and reports with subreports. But when linking to another reports, the credential information is lost.
Is the a possibuility to pass the datasource credential information to a linked report?
I have several reports that are set to landscape but then lose this layout when a linked report is created from the original report. I found the link below describing Brian Welcker's workaround and my question is where do you place the vb.net code he provided?
I am using transfer manager in SQL 6.5 to copy a database and all objects with data to another server. Transfer manager is not recreating all stored procedures. This even happens when I used it to another database on the same server. Any ideas??
Is it possible/advisable when transfering very large amounts of data from server to server to: trasnfer the data to a new table first second alter new table adding indexes, defaults, ets based on original table
if it is what flow item would be used to transfer/alter the indexes and defaults?
I'm very new to ssis so the more detail you can give the better.
I have been trying to run transfer manager to transfer all of the data from the production database on one server to a test database on another server(to refresh it). In order to make sure it runs on the server, I have been scheduling it under EM to do so and I am pointing to the log on the destination server on the EM Transfer panel.
For some reason, I am getting the following message in the destination server error log:
99/02/16 10:24:41.42 ods Error : 17824, Severity: 10, State: 0 99/02/16 10:24:41.42 ods Unable to write to ListenOn connection '.pipesqlquery', loginname 'sa', hostname 'TEMP09'. 99/02/16 10:24:41.42 ods OS Error : 232, The pipe is being closed. 99/02/16 10:24:41.42 spid17 Error : 1608, Severity: 21, State: 2 99/02/16 10:24:41.42 spid17 A network error was encountered while sending results to the front end. Check the SQL Server errorlog for more information.
I checked the event viewer error log and see no messages for today.
Can any one advise me what I need to do for this to run successfully?
Thanks. Any information furnished will be greatly appreciated.
Hello SQL Server Experts, Data Analysts, and Report Writers et al:
re: Reporting Options with SQL Server
I wanted to propose an offshoot to the pryor thread:
Would anyone take a stab at comparing Access Reports, Crystal Reports, Cognos or other options to all the Reporting Services and its components offered as part ofSQL Server, especially as to extracting data from SQL Server into a report format?
I guess this is a far as capabilites, ease of use, limitations, and especially formatting or presentation of the end report product?
Thank you to all, and I hope this is a beneficial discussion to others.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
I have an already published application running several MS SQL Server 2000 Reporting Services report. I need a way to find from either the reporting services log or the application server (IIS) logs or windows log to know the frequency of each report being used.
Based on this info, the business needs to know which reports are being used and to what extend? How can I acheive this?
I have already got the IIS logs and it did not give the required info. I have looked into the Reporting Services logs but it does not provide the info either.
My issue is with converting multi-value parameters:
In Crystal Reports, you can set a parameter to accept multiple vales (Discrete, Range or Discrete and Range).
As an example:
I have a database table with a column called ID. I can create a parameter called param_id and set the options of the parameter to "Allow multiple range values".
With this setup, I can limit the result set of the report by comparing the param_id parameter to the ID column in the database. Because param_id is a multi-value range parameter, I can pass it the following data: 1 - 50 60 - 80 150 - 127
This will only return results within those ranges.
Does anyone know if SSRS provides this kind of functionality?
Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.
The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.
1. I downloaded ChartFXRSTrial and created one chart, and able to deploy it in ReportServer, but the problem is the reports are not showing there, i checked the configuration of .dll files in the help provided by chartFX, but couldn't get anything, so could help me on this.
2. How to give Tooltip for the X- axis or Y- axis values in the ReportServer , i tried using chartproperties of .rdl file, but didnt understand it. can help me on this, and one more i tried with Dundas too, If im giving tooltip as #valy then, it is showing samething in reportserver instead the values of 'Y-axis'.
Hi , On my Desktop i registered Production Server in Enterprise Manager on that Server if i go to SecurityLinked Servers There is another Server is already mapped, when i am trying to see the Tables under that one of the Linked Server i am getting the Error message saying that "Error 17 SQL Server does not exist or access denied"
if i went to Production Server location and if i try to see the tables i am able to see properly, no problems why i am not able to see from my Desk top i am using the sa user while mapping the Production Server on my DESKTOP using (ENTERPRISE MANAGER)
And i check the Client Network Utility in the Alias using Named Pipe only, i changed to TCP/IP still same problem What might the Problem how can i see the Tables in Linked Server from my DESKTOP
In the full recovery model, if i run a transaction that inserts 10MB of data into a table, then 10 MB of data is moved in the data file. Does this mean then that the log file will grow by exactly 10MB as well?
I understand that all transactions are logged to the log file to enable rollback and point in time recovery, but what is actually physically stored in the log file for this transactions record? Is it the text of the command from the transaction or the actual physical data from that transaction?
I ask because say if I have two drives, one with 5MB/s write speed for the log file and one with 10MB/s write speed for the data file, if I start trying to insert 10 MB of data per second into the table, am I going to be limited to 5MB/s by the log file drive, or is SQL server not going to try and log all 10 MB each second to the log file?
Hi, I have the following method which transfers data SQL to SQL on the same server but when I try to change the destination server it won't transfer the data. The method runs through as expected with no exceptions or errors but with no data transfered.
Private Sub TransferSQLData(ByVal SourceDetails As Admin_upload.EnvironmentDetails, ByVal DestinationDetails As Admin_upload.EnvironmentDetails)
'Transfer database from source to destination. Dim oPackage As New DTS.Package2 Dim oConnection As DTS.Connection2 Dim oStep As DTS.Step2 Dim oTask As DTS.Task Dim oCustomTask As DTS.TransferObjectsTask2 Try oStep = oPackage.Steps.New oTask = oPackage.Tasks.New("DTSTransferObjectsTask") oCustomTask = oTask.CustomTask oPackage.FailOnError = False With oStep .Name = "Copy Database design and data" .ExecuteInMainThread = True End With With oTask .Name = "GenericPkgTask" End With With oCustomTask .Name = "DTSTransferObjectsTask" .SourceServer = "MYSERVER" .SourceUseTrustedConnection = True .SourceDatabase = SourceDetails.MetaDB .SourceLogin = SourceDetails.MetaUser .SourcePassword = SourceDetails.MetaPWD .DestinationServer = "MYSERVER" .DestinationUseTrustedConnection = True .DestinationDatabase = DestinationDetails.MetaDB .DestinationLogin = DestinationDetails.MetaUser .DestinationPassword = DestinationDetails.MetaPWD .CopyAllObjects = True .IncludeDependencies = False .IncludeLogins = False .IncludeUsers = False .DropDestinationObjectsFirst = True .CopySchema = True .CopyData = DTS.DTSTransfer_CopyDataOption.DTSTransfer_ReplaceData
End With oStep.TaskName = oCustomTask.Name oPackage.Steps.Add(oStep) oPackage.Tasks.Add(oTask) oPackage.Execute() Catch ex As Exception LabelUploadMeta.Text = "Failed to Upload MetaData: " & ex.Message Throw ex Finally oConnection = Nothing oCustomTask = Nothing oTask = Nothing oStep = Nothing
If Not (oPackage Is Nothing) Then oPackage.UnInitialize() End If End Try End Sub This works fine but when I set the following within the method: .DestinationServer = "ANOTHERSERVER" It won't transfer the data. I can access the remote server and read and write data to it. Any ideas?
Hi , Can anyone suggest me to transfer a database from 65 to 70. I trasfer a database using DTS, but i am only getting data. I need my users , views, stored procedures, permissions. I need to upgrade three databases from 65 to another 70 server. i also generated a script from 65, but which is showing errors. Could u pls give any suggestions. thank u.
I recently transferred a db from our production machine to a test machine. After the transfer was complete I realized that all copied logins were copied with blank passwords. Is this default behavior? Can I set the transfer to include passwords?
I have recently tried to transfer my database over from one machine to another, but failed to do so because it gets jammed on 30%. I am just wondering if there is any other ways I can take to migrate the database over.
I am currently running sql server 6.5 in concurrent with iis 4 and nt4. I am trying to seperate the iis to a new server machine and sql server to another server.
Please advise me which route to take if you have any suggestions and your solution is important to me. Thanks!
I want to transfer rows from one database to another. Source My Source tables in database 'Staging'
CustomersEng Name Age StCode CityCode InternalID
CustomersSpanish Name Age StCode CityCode InternalID
CustomersEng and CustomersSpanish contains a replica..only difference being that 'Name' in the CustomerSpanish table is written in spanish language. The Stcode, citycode and Internalid together makes the row unique.
Code BlockSample script Create table #CustomersEng (name nvarchar(20),age int, st_code int, citycode int, internalid int) Insert into #CustomersEng values('Aron',23,1,1,12); Insert into #CustomersEng values('Cathy',28,1,1,13); Insert into #CustomersEng values('Zarog',33,1,1,14); Insert into #CustomersEng values('Michale',25,1,2,12); Insert into #CustomersEng values('Linda',43,1,2,13); Insert into #CustomersEng values('Burt',53,1,2,14);
Create table #CustomersSpanish (name nvarchar(20),age int, st_code int, citycode int, internalid int) Insert into #CustomersSpanish values('Arona',23,1,1,12); Insert into #CustomersSpanish values('Cathylo',28,1,1,13); Insert into #CustomersSpanish values('Zarogo',33,1,1,14); Insert into #CustomersSpanish values('Michalo',25,1,2,12); Insert into #CustomersSpanish values('Lindalo',43,1,2,13); Insert into #CustomersSpanish values('Burto',53,1,2,14);
--------------------------------------------------------------------------------------------------------------- Destination tables in database 'CMO'
