Sharing Multiple Reports
Oct 30, 2007Hi,
Can we share and schedule whole report folder(not just one report) by using management studio?
Thanks
ADVERTISEMENT
Sharing A Dataset In Multiple Reports?
Sep 26, 2007I'm looking for some advice on how to manage reports that use the same query in their datasets. I have multiple reports that use several datasets that are the same. If I need to make a change to one dataset, I need to remember to update the other datasets. Of course I don't always remember to do that!
Is there a way to create a dataset in a single location and then share it? I was thinking of using a View but I don't think it'll accept the parameters.
I've been cutting & pasting the entire query as I make change but I'm afraid it'll mess that up or forget to update a dataset.
How do you do it?
Any suggestions you have would be helpful.
Rob
Sharing Style/formatting Between Reports Or Objects
Apr 9, 2007To date I have found no way of defining styles that can be shared either between objects or between reports.
I am looking for the concept of the rdl making a reference to an external css (or equivalent) file. This would allow for me to define a font or image external to the rdl and shared among all my reports. Currently if I want to change my header image, I need to edit 50 rdl files across the reporting suite.
What work arounds are available for this? Is this a coming feature enhancement? If so when? Does the reporting team publish a list of future enhancments?
I know crystal and few other reporting packages have the concept of css or style external to the report.
Cheers
Sharing Styles Between Reports (reporting Objects)
Apr 9, 2007
To date I have found no way of defining styles that can be shared either between objects or between reports.
I am looking for the concept of the rdl making a reference to an external css (or equivalent) file. This would allow for me to define a font or image external to the rdl and shared among all my reports. Currently if I want to change my header image, I need to edit 50 rdl files across the reporting suite.
What work arounds are available for this? Is this a coming feature enhancement? If so when? Does the reporting team publish a list of future enhancments?
I know crystal and few other reporting packages have the concept of css or style external to the report.
Cheers
Sharing ASPNET.MDF Between Multiple Apps
Sep 27, 2006Hi guys,I've got two apps that are going to have pretty much the same users and i wanted them to have the same ASPNET.MDF user database. Is it possible to store the ASPNET.MDF in a different location and then have the two apps access it from there or alternatively have it in the App_Data folder of one of the apps and then have the second app access it from there?Thanx
View 2 Replies View RelatedMultiple Databases Sharing Device
Jul 14, 1998Does 7.0 allow multiple databases to share a data file/log file?
Will a large data device file shared by 10-25 databases present any problems?
Thanks
Multiple Packages Sharing One Solution XML Config File
Jun 22, 2007Hey guys and girls,
This seems like a no brainer, but it's driving me nuts. I want one XML file for the entire solution. There are multiple packages in the solution which have different Connections in the conntion Managers. The packages share some connection names, and some are unique to the package.
Example:
LoadData.dtsx would have a source database connection named (SourceDB_OLEDB) and a oledb connection (DataWarehouse_OLEDB).
LoadDataMart.dtsx would use the same name for the (DataWarehouse_OLEDB) connection and have another oledb connection (DataMart_OLEDB)
I want one XML config file that has all the connection strings, but the problem is that the LoadDataMart.dtsx will throw an error:
Error 1 Error loading LoadDataMart.dtsx: The connection "SourceDB_OLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. c:ssisLoadDataMart.dtsx 1 1
Thanks,
James
Sharing Hard Disk On Multiple SQL Server Instances
Jan 31, 2008
I have a situation where I would like to set up one DB server instance for US and anther one for AUStralia. The Instance should share the same data base/hardsisk. One of the instances will be running in using US time zone and anothe one in Australia time zone.
There will be 2 Application instaces one poinint to each SQL Server instance. This applications does write into the database
So the underlying requirment is to have 2 database server running in differnet time zones but accessing the same disk/set of data
What is the best way to do this? Is it linked servers?Girish
Retrieving Multiple Values From One Field In SQL Server For Use In Multiple Columsn In Reports
Mar 30, 2007I am trying to create a report using Reporting Services.
My problem right now is that the way the table is constructed, I am trying to pull 3 seperate values i.e. One is the number of Hours, One is the type of work, and the 3rd is the Grade, out of one column and place them in 3 seperate columns in the report.
I can currently get one value but how to get the information I need to be able to use in my reports.
So far what I've been working with SQL Reporting Services 2005 I love it and have made several reports, but this one has got me stumped.
Any help would be appreciated.
Thanks.
I might not have made my problem quite clear enough. My table has one column labeled value. The value in that table is linked through an ID field to another table where the ID's are broken down to one ID =Number of Hours, One ID = Grade and One ID= type of work.
What I'm trying to do is when using these ID's and seperate the value related to those ID's into 3 seperate columns in a query for using in Reporting Services to create the report
As you can see, I'm attempting to change the name of the same column 3 times to reflect the correct information and then link them all to the person, where one person might have several entries in the other fields.
As you can see I can change the names individually in queries and pull the information seperately, it's when roll them altogether is where I'm running into my problem
Thanks for the suggestions that were made, I apoligize for not making the problem clearer.
Here is a copy of what I'm attempting to accomplish. I didn't have it with me last night when posting.
--Pulls the Service Opportunity
SELECT cs.value AS "Service Opportunity"
FROM Cstudent cs
INNER JOIN cattribute ca ON ca.attributeid = cs.attributeid
WHERE ca.name = 'Service Opportunity'
--Pulls the Number of Hours
SELECT cs.value AS 'Number of Hours'
FROM Cstudent cs
INNER JOIN cattribute ca ON ca.attributeid =cs.attributeid
WHERE ca.name ='Num of Hours'
--Pulls the Person Grade Level
SELECT cs.value AS 'Grade'
FROM Cstudent cs
INNER JOIN cattribute ca ON ca.attributeid =cs.attributeid
WHERE ca.name ='Grade'
--Pulls the Person Number, First and Last Name and Grade Level
SELECT s.personnumber, s.lastname, s.firstname, cs.value as "Grade"
FROM student s
INNER JOIN cperson cs ON cs.personid = s.personid
INNER JOIN cattribute ca ON ca.attributeid = cs.attributeid
WHERE cs.value =(SELECT cs.value AS 'Grade'
WHERE ca.attributeid = cs.attributeid AND ca.name='Grade')
Multiple Report Server Instances Sharing A Single Report Server Database
Mar 30, 2007I would like to know if it is possible to have different applications on separate report servers sharing one report server database. If so are there possible issues or ptfalls to this type of architecture?
Thanks,
thecoleman
Multiple Reports
Dec 20, 2007Hi Friends,
How do I display a bar graph in my main report? I dont want it to be displayed on separate page. When I click on some entities on my main report, a graph should be popped up in the same report in some corner? how do I do that ? Please let me know.
Thanks & Regards
Naveen J V
Multiple Reports
Apr 23, 2007Hi all,
I have created a report that everyone is happy with.
My dataset (simplified) looks like this:
SELECT *
FROM FamilyMember
WHERE QuestionnaireID = @QuestionnaireID
Now, instead of running individual reports the users want to run several reports on a list of QuestionnaireID's.
I thought something like this would work:
SELECT *
FROM FamilyMember
WHERE QuestionnaireID IN (@QuestionnaireID)
but RS complains about converting '152,153' to an INT.
Is there a way to accomplish this?
I am guessing I need to convert the nvarchar @QuestionnaireID to a real list of INTs but am unsure how to do this...
Ad Hoc Reports Multiple Tables
Aug 21, 2007HI,
i am a new to SSRS and i am facing a problem with Ad Hoc reporting.
actually i wanted to create a report with data from two different table. now its the relation between these two tables that is not allowing me to create a req. adhoc report.
i want the report to have data from table A and table B and the relationship between A and B is many-to-many. so in the database design i have an associate table C between A and B. so in .dsv file i have C related to A as one-to-many and C related to B as one to many.
Now here how do i get data from both table A and table B?
Generating Multiple Reports
Sep 25, 2007
I have a report that I pass parameters of a clientID. I run the report and export it to a .pdf file. I would like to be able to do this for multiple clients without manually having to enter the ID each time and exporting it.
I have thought about creating a report that calls this report so that I can pass in the clientID one at a time. The problem is trying to export each one.
Does anyone have any ideas? Thanks in advance!
Getting Reports On Multiple Pages
Jan 4, 2008 I have a data set which has more than one record. Iam tyring to create a report without using the wizard. I want the report on multiple pages. I dragged some text boxes on to the design and added the expressions in there. If I run the program now Iam only getting the report with the last record. How do I get the report for all the records in the Dataset on multiple pages ? . I want each record on one page. I am forsure getting more than one record into the Dataset.
Thanks in advace for the help
Code For Multiple Reports Deployment
Nov 5, 2007
Hi,
I have created bunch of reports using SSRS. Now I want to deliver all of these reports together. I can use data driven subscription in Report Manager. But that feature allows to deliver one report at a time. Can anyone tell me how to deliver all reports together?
Requirement is reports should be delivered to dirrent departments. These reports have parameterized. Can anyone tell me how to do this? at least if somebody provides sample codes I really appriciate.
Thanks
p/s ;
I found this one on MSDN. But I'm not sure whether I can change this and use for multiple reports subscription. I dont hv a good knowledge on C# or VB. Please can anyone help me to modify this? I think we can use a loop or smthing.
http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createdatadrivensubscription.aspx
Executing Multiple Simultaneous Reports
Oct 15, 2007Is there a way to get the Report Manager to allow a single user to
execute more than 1 report at a time? Currently, each user can only
have a single report being executed at a time. It looks like any
other reports are being queued and executed serially.
Reports Based On Multiple Databases
Oct 23, 2007I'm new to developing reports using 2005 SQL Reporting Services. Is it possible to develop reports based on more than one database, (generally MS SQL)? I need to set up a dataset that includes tables from several different databases linked together so that information can be viewed together in one report.
thanks
How To Execute Multiple Reports With The Same Parameter
Mar 29, 2007We have timed-based subscriptions set up for our standard set of 10 client
reports which run monthly with the appropriate parameters set for each
of our clients. Our management has requested that we provide them with
the ability to run the set of 10 reports together at will. So we would
provide the client parameter and all 10 reports would be generated.
What is the recommended approach to accomplish this? We are using Sql
Server 2005, Visual Studio 2003 and .Net 2.0.
Multiple Sections In SQL Server Reports..
Nov 15, 2007Hi,
Am using SQL Server Reporting service to generate reports.Actually i want is a reports containng two sections,How can i achieve that?
Cheers
Jan
How To Pass Multiple Parameters Across Reports In SSRS
Apr 25, 2008
Hi,
I am working on SSRS. I need to open a new report from one report when user clicks on some
particular summarized count link.
It is a sort of drilled down report. I am not getting how to pass the respective Ids (more
than one) to the next report when user clicks on the summarized link in the 1st report.
These ids I want to use as a parameter (multiple) in the 2nd report to dump the rows from
the database.
Sub: How To Pass Multiple Parameters Across Reports In SSRS
Apr 25, 2008Hi,
I am working on SSRS. I need to open a new report from one report when user clicks on some
particular summarized count link.
It is a sort of drilled down report. I am not getting how to pass the respective Ids (more
than one) to the next report when user clicks on the summarized link in the 1st report.
These ids I want to use as a parameter (multiple) in the 2nd report to dump the rows from
the database.
Can I Create Multiple Reports Using Business Intelligence??
Apr 14, 2008Hi I need to create 6 different reports using Business Intelligence.
Therefore I have to use it 6 times
Is there a way it can be done in one go??
cheers
SSRS And ASP.NET Multiple Reports Within One Report Viewer
Feb 6, 2008
Ok,
I am writing an app that will allow a user to select various information for displaying in a report. The sql is dynamically generated when the user clicks on "Get Report". Currently, I am using a gridview with a datasource and I pass the query to the datasource and it displays in the grid view. However, our company has expressed a need to migrate reporting to SSRS.
Is there any way that I can use dynamic sql with a template report and feed the dynamic sql to it so that all I would have to do is write a single rdl or rdlc and pass it the sql?
Alternatively, is there a way to have One ReportViewer show multiple parameterized reports. Ie. User selects the report from a dropdown and then selects the parameter options from other dropdowns and when they click "get report" it loads the chosen report with the parameters?
Thanks in advance.
Matrix Reports With References To Multiple Datasets
Oct 4, 2007Hello and thank you for the help in advance.
I know this has to be possible maybe I am just missing somthing.
I am creating a matrix report which will compare year by year quotes to orders The issue is quotes and orders each have their own dataset. I will be pivoting on JobType which is in both datasets and spelled the same. Is there a way to do this or will I have to figure out how to union the tables? If not possible why does it allow you to name the dataset in the expression?
Thanks, Leo
How To Bulk Deploy Reports To Multiple Servers?
Mar 23, 2007Hi,
I'm just wondering if there is any easy way to deploy reports to multiple servers. My current issue is that I need to deploy tens of reports onto tens of production server. Does anyone know how to do that?
Thanks a lot.
Cheers,
Saving Multiple Reports From Reporting Services
Oct 31, 2007Hi everyone, I'm very new to SQL and SQL Reporting Services.
However I've been given a task.
How do I save multiple reporting services reports onto a predetermined location on a users local pc? Are there tools/applications that can be used to push files onto the users local pc?
The application uses .NET but they've created reports using SQL Reporting Services. The user will select which report they want (out of 2). My task is to figure out how can we save those reports that they have selected onto their pc?
Thanks in advance
Is It Possible To Render Multiple Reports Into A Single Report ??
Jul 20, 2007Hi,
I have an application wherein I need to generate a single report(possibly in PDF format) which contains more than one report. Iam using SSRS 2005. In my application Iam using report server url to render reports. The below is URL for rendering single report.
http://servername/ReportServer/Pages/ReportViewer.aspx?reportname&rs%3aCommand=Render&rs%3aFormat=HTML4.0&rc%3aToolbar=true
Is it possible to render multiple reports into a single report ?
Can anyone help me in this regard ?
Thanks,
S V Ramakrishna
How To Render Multiple Reports Into One Output File?
Nov 21, 2006We are using SQL Server 2005 Reporting Services and looking to render multiple reports into one output file. So, for example, say we have four reports and when the user asks for the reports to be generated, we would like to have all four reports come out in one PDF (or Excel or HTML) file instead of four separate files. I hope this makes sense.
Is there any way to render multiple reports to one output file?
Thanks!
Drill Through To Reports Located In Multiple Folders
Feb 28, 2008Report A contains a textbox that should navigate to Report B using the Jump To option. Report A and Report B are located in separated folders on the Reporting Server.
SSRS looks for the rdl file within the same folder when using the Jump To option. Is there away to navigate to a report located in a different folder on the same server?
Thanks
Using StoredProc With Multiple Result(or Datatable) In Server Reports
Sep 17, 2007Hi guys,
I've been doing some LOCAL reports on my current application until recently there's has been a case that I really need to do SERVER reports.
Usually when I design my local reports, I create a XSD file, so I usually have one dataset with multiple tables in it. I just pass the dataset to report with a single procedure call that returns multiple result sets or data table.
From what I understood server reports are binded to database objects only, like stored procedures. Now I used the same stored procedure that I used in my local report to my server report. But the thing is only the first result set in the stored procedure is recognized. Are there anyway that I can bind the server report to a single stored procedure that return multiple result sets?
Thanks.
How To Generate A Report Containing Multiple Single Page Reports
Mar 14, 2006I am using SS 2005 RS. I am able to generate single page pdf reports by passing "id" as a parameter. Now I need to send multiple ids as parameter and generate one big report which would contain reports for all the ids supplied on separate pages. Is this possible? If yes, then how do i do this.
What I have tried so far is, I created new report with a list control and added single page report as a subreport to this list control and grouped this list control using id parameter. When i send multiple ids in the parameter, for example 3 ids, it generates 3 page report but only for the first id. So it generates report for the first id and repeats same report 3 times.
Thanks for your help,
SQL 2012 :: Data Driven Report Looping Through Parameter For Multiple Reports
Sep 15, 2015I'm trying to create a report that will be data-driven and produce multiple reports based on a parameter. For example, 5 reports go out today based on invoice numbers from yesterday. Each invoice can have multiple trasnsaction lines and each line contains the invoice number. What I have so far is only taking the first invoice number (let's say it has 10 transactions) and sending me the same report 10 times and stopping.
I get nothing for the remaining 4 invoices/reports. Here is what I have. To me this should enter the distinct invoice no's from yesterday into #temp, while a invoice no exiists begin query with one invoice selected from #temp then delete that invoice no and select another one and repeat till no more invoice no's. But it's only going through the one invoice no.
select distinct InvoiceNo
into #temp
from table
where Invoicedate between getdate()-1 and getdate()
declare @InvoiceNo VARCHAR(25)
[Code] ....