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
View 1 Replies
ADVERTISEMENT
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
View 1 Replies
View Related
Oct 30, 2007
Hi,
Can we share and schedule whole report folder(not just one report) by using management studio?
Thanks
View 1 Replies
View Related
Sep 26, 2007
I'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
View 7 Replies
View Related
Nov 5, 2007
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.
Hal1490
Hal9000
View 4 Replies
View Related
Dec 15, 2006
I am amazed that we cannot use our own styles?. There is only a predefined set of styles in HTMViewer.css to which we cannot add our own style names and use it for a textbox?
Has anyone done this?
Thanks
View 1 Replies
View Related
Nov 20, 2007
except for dots and dashes, it seems like the fancier border styles on a text box (like "Groove") all act like the "Solid" border style. Am I missing an add in?
View 8 Replies
View Related
Apr 30, 2015
In addition to the column values, we are getting the below tag added throughout the table. It happens specifically to the columns with data type nvarchar and varchar and length >=100. We have 5 numbers of database but it happens only in one specific database. We doubt it to be sql injection but not sure how it happens. The impact is very severe on our clients. how to find the root cause. In that html tag have the url:...
Wilhite</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div
Blunt</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div>
Duran</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div>
Neiwert</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div>
Gerard</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div>
Hrnandez</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div class
Hernandez</title><style>.alwi{clip:rect(483px,auto,auto,427px);}</style><div class
[code]....
View 4 Replies
View Related
Dec 14, 2007
Everybody says that sql reporting supports using business objects but I am running into a situation where I have a custom business object which has bunch of objects bundled inside and if I try to show those objects in a list or table, all I get is an error without any description.
Can we report on business objects which have some depth build into them, like a customer -> address -> shipping -> Although my custom object has 4 level deep objects which I would like to group on and report on.
If yes then how do we achieve this?
Or what kind of interface do those object need to use like IEnumerator or what?
Is there any example out there which reflects this?
Atul
View 4 Replies
View Related
Jul 20, 2005
Hi,I am evaluating Microsoft Reporting Services against Business Objectsas a reporting tool against SQL Server. I am primarily a BOBJdeveloper and am finding RS not easy to use. Can anyone provide anyfeedback to the overall comparison between these 2 products as I amfinding RS frustrating and am wondering if it is just a matter ofre-adjusting and spending more time on it or if anyone else is findingRS more trickey to use than BOBJ as wellI would be extremely grateful for any feedback.Many thanks in advanceLA
View 1 Replies
View Related
Jun 17, 2015
I am making a report using RDLC. I have made the connection with Sybase database (using ODBC) and when I add a new DataSet in report then it says:
The database is new or does not contain any objects...Connection to database is successful and it contain many tables and views but they are not being displayed.
Tried again with Sybase OLEDB provider but same issue.Even the Server Explorer where you can see database servers added is not showing any tables and views. I read somewhere it is because there may be no primary keys defined in any table so I created a new table with primary key but issue remains the same.
View 2 Replies
View Related
Apr 29, 2008
Is there a way in Reporting Services to filter based on a parameter, but get it to use distinct values?
Currently I have a dataset that is grouped on a Branch value and a Team value.
The end-user wants to be able to filter out data based on the branch values, however when I set it up to that field it comes back with:
Branch 1
Branch 1
Branch 1
Branch 2
Branch 2
Branch 3
Branch 3
and the same goes with Team, which is a sub-group of branch. Is there any way I could set this up so that the parameter drop-down will only display distinct values? Also, is it possible to do the same with another parameter based upon the branch parameter.
Ex.
Branch 1 contains Team 01, Team 02, and Team 03
Branch 2 contains Team 04, Team 05
User selects to filter by Branch 1, the Team dropdown should only contain options for further filtering on Team 01, Team 02, and Team 03 not all of them.
Any help is much appreciated.
View 3 Replies
View Related
Jun 10, 2015
I am working on complex invoice document that handles various types of invoicing, credit, and progress bill customer facing documents. I am faced with same problem I see many SSRS devs posting on. And that is extra blank pages, being generated because the report width exceeds the width of the page.
My problem is I cannot shrink the horizontal width of the tablix and therefore the report width either...
While I would have done things differently if developing from scratch, the tablix in question has only one column and objects contained in rectangles are placed in the row/column cell.....The link to the image below shows the row I am currently working on. Essentially all the client wants a columnar report with column lines, closed footers, etc... so rather redoing the whole tablix, which I still might do, I am using rectangles with the column then lining them up. Anyway, that is a whole 'nuther post. My specific questions are:
Invoice in Report Builder
1. In the image I have selected the parent rectangle. The children are other rectangles and the data is with grandchildren textboxes that exist within those rectangles. I clearly have a bit of right side white space in the main parent rectangle, but there is no sizing tool on a hover... just move tool. And if I change the rectangle size in the prop form it just snaps back to the cell width. How do I size the parent rectangle and keep if from expanding.
Here I am guessing that to actually reduce the horizontal width of tablix and then the report, I have to first decrease the parent width of the rectangles that occur in each row?
View 2 Replies
View Related
Jan 12, 2005
I have installed and am using Reporting Services.
I can create RDL files using Visual Studio.NET, but like to offload this task to a minion who does not have VS.NET.
Is there a stripped down something-or-other to make reports that and end user or business analyst could use and then upload the reports?
Thanks.
View 1 Replies
View Related
Aug 23, 2004
Can anyone tell me if MS Reporting Services can import/read a Crystal Reports file as it can an Access report file?
I've seen a few posts out on other boards that there are some companies charging fees for converting Crystal Reports over to MS Reporting Services.
Is there any easier way? Are there any tools out there that can do it?
Perhaps Microsoft should produce such a tool for converting...
Thanks in advance for any help!!
View 3 Replies
View Related
Jul 12, 2007
Crystal reports to Reporting Services
Is there any way I can convert Crystal reports to Reporting Services instead of creating reports again in Reporting Services?
View 3 Replies
View Related
Jul 11, 2007
I have reports posted to my server and need to edit them. My issue is the original rdl has been "misplaced". I do not have a model built for this server so I cannot use the built in report builder. Is there a way to "download" from the reporting server?
View 1 Replies
View Related
Feb 27, 2008
We had some problems in deploying the reports to the client. Previously we used to deploy the reports in our development environment through reporting project but now we need to physically deploy the reports to the client on 14 different servers. We don't have access to the reporting project on site. Is there any way to deploy the reports outside reporting project?
Thanks,
View 4 Replies
View Related
Apr 29, 2015
I have a Manager dashbord report.In this report 1st page contains some tables and 2nd,3rd page contains line charts with tables.Actually what we need is in 1st page tables are pretty simple,we need to add kpi's and shown these tables in kpi. kpi in ssrs and how to add kpi in ssrs reports?
View 2 Replies
View Related
Nov 30, 2007
We are planning to migrate our crystal reports to reporting services, just wondering if we have cross tab reports in sql server reporting services. Thx.
View 7 Replies
View Related
Apr 30, 2008
I currently have a report on our Reporting Services 2005 server that takes a CompanyID as its only parameter. Also, in our database, we have a list of contacts that are linked to the CompanyID that is used in the report. What I would like to do is email a pdf or each company's report to every contact for that company in our database daily. However I am stuck on how to do that. My project is using C#, but if there is a way to do this directly through Reporting Services I could do that as well. If anyone could help me out I would greatly appreciate it. Thanks!
View 5 Replies
View Related
Jan 25, 2007
I am using Visual Studio 2005 and trying to deploy reports to SQL Server 2000.
I get the following message:
A connection could not be made to the report server http://aklink1/reportserver.
------------------------------
ADDITIONAL INFORMATION:
The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version. (Microsoft.ReportingServices.Designer)
Please help!
View 4 Replies
View Related
Nov 3, 2004
Hi all,
Currently I have a project that require me to use reporting services (Reports) together with ASP.net web application.
However, I have the following problem.
I have an asp.net web application. From there, I have a textbox whereby user can type a specific date. The specific date should then be incorporate with the sql reporting services. The report that is being generated will contain data that is on the specific date.
How can I do that?
I try to search through the internet but to no result. Can anyone help out?
Thank you so much.
View 1 Replies
View Related
Jul 30, 2007
We will making a change to our Reporting Services deployment next month. We will be moving from our SQL 2000 server to a new SQL 2005 server. In addition, we will moving from a Local Catalog Deployment to a Remote Catalog Deployment. My question is this: Is there a way I can prevent my team from having to manually redeploy our reports in the new system? They have not been diligent about saving the Visual Studio solution or project files, so they will have to pull the most up-to-date RDL's off the server and deploy them on the new server one by one.
I suppose I can install SQL 2000 on the new server first, then move the Reporting Services databases to the new server, then upgrade the server to 2005, but installing 2000 and upgrading to 2005 does not sound like a best practice. I would prefer a clean install of 2005. Does anyone know if I can move the deployed reports from one server to another?
Paul Teal
paul@partytilyoupop.com
View 1 Replies
View Related
Apr 20, 2015
We have created and scheduled some test reports via Idera performance tool but we are unable to delete the reports. These are not custom reports and reports created with Schedule Email option in Idera. Unfortunately, I dera does not have any option to delete these reports and support is asking me if I tried this by deleting from SQL Server Reporting Services.I looked at the Reporting services but can't find any place to delete these reports. This link does not provide any support because I don't have these (Or Report Manager)----> Configuration Manager console, navigate to System Center Configuration Manager / Site Database / Computer Management / Reporting / Reporting Services.
URL....All I have is "Reporting Services Configuration Manager" under "Configuration Tools". How can I delete these reports from SQL Server Reporting services ?. Can I delete them from some tables in Reports databases ?. If so, what are the tables ?. I delete the jobs from SQL Server but the jobs are automatically created the next day emailing the reports again..
View 3 Replies
View Related
Jun 29, 2007
I have a requirement to create dynamic reports for my client.
once i create these reports then the user will choose columns of there choice.
so the columns may belong to multiple tables.
Now the report should get generated with the layout etc. is it possible.
since our project is totally on the webserver(webbased.)
please if you can provide me with any links with dynamic report creation wizards.
and also we only use Stored procedures via database.
which is best is writing the entire queries right behind the layouit or calling the entire logic via Stored procedure. i am a bit confused. this is my first project working on reports itself.
Thank you all for the helpful information.
View 1 Replies
View Related
Jun 1, 2015
Is there a way to publish the MDW (Data Collection) reports (Disk Usage history, Query Statistic history, and Server Activity history ) on SSRS server?!
It is not logical for all who wants to view the mentioned reports to open the SSMS !
I've already check [URL] .... there, the writer is suggesting to recreate the reports from scratch on SSRS, that if I could figure their queries, which I don't think the only way that we have!
View 3 Replies
View Related
Jul 27, 2015
Is there a good way in TSQL to:
1. List all SSRS reports containing sub-reports
2. List the SSRS sub reports?
View 2 Replies
View Related
Feb 5, 2007
I have a question regarding Reporting Services:
I want to run the Reports on a system that has Oracle Database but reporting Services are not installed there. Only Application exe file will be there designed in .NET Windows Forms.
Reports will access oracle Database.
View 7 Replies
View Related
Jun 8, 2015
I'm using the SQL Server Reporting Services to build a sales report.
I'm having two different reports because I need to have a matrix table into one of them.
Is possible to Join two different reports (two different reports.dll) into one? Basically, can I, in the end, export two different reports in only one report?
View 2 Replies
View Related
Jan 1, 2015
I make SSRS Reports and I use SSRS RDL file to perform coding and all..
How can I use jQuery scripts in my Report Server Reports(SSRS) to make it more attractive and user friendly?
View 4 Replies
View Related
Oct 31, 2007
Hi 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
View 1 Replies
View Related
Jun 2, 2015
I have generated an invoice report is SSRS. It works correctly via Report Builder and the viewer. However if I then export the report to PDF, it throws the formatting of the report off.
As I have mentioned, it is an invoice report. If I print 1 invoice, and export it, everything exports correctly and all formatting is retained. However if i print off and export multiple invoices (range of Invoice 1 to 4), the 1st invoice is exported correctly, but all subsequent ones are not. In so far that where 1 invoice should be printed on 2 pages of A4 paper, it is spread over 7 pages.
The header is one page, then 1 row is on the second page, then a blank page, then another set of data on another page etc. Is it a problem with the page/report sizing/margins?
View 8 Replies
View Related
