We've recently upgraded one of our SSRS2005 servers to SSRS2008 and have found that all of our applications that utilized the reporting services web service for producing reports no longer works. The first issue is that the web service itself was no longer available at ReportService.asmx, and had been replaced by: ReportService2005.asmx...
Hi I have A BAR chart in SSRS which has following vaues.. for 5 points on X-axis values are 100,120,130,123,8000 So the last value is too lagre due to which scale is geeting larger causing chart to look bad...n unreadable for other points... So is there any way by wiz i can breal the LAST BAR in a bar chart showing it on ongoing mann...
I have an SSRS report that is displayed to users in the ASP.NET ReportViewer control. The report has many parameters and we're using the parameter prompts that the ReportViewer control offers. Depending on a certain parameter of the report, we only need to have the user prompted for a subset of the rest of the report parameters. We coul...
I'm trying to eliminate HTML tags from a value displayed in an ssrs report. My solution came to: =(new System.Text.RegularExpressions.Regex("<[^>]*>")).Replace((new System.Text.RegularExpressions.Regex("< STYLE >. *< /STYLE >")).Replace(Fields!activitypointer1_description.Value,""),"") The problem is that the second expression ("< STYL...
I'm trying to figure out if you can create template files or skins for SSRS reports. We are trying to standardize all of our reports to look similar. If there are no known ways to create templates or skins how do you work around this issue? ...
Have a matrix report now that has Position, Hours and Wages for a location for a month. There may be any number of locations...that's why I'm starting with a Matrix report...the user may chose up to 50 locations to view. Location 1 Location 2 Total Hrs Amount Total Hrs Amount Posi...
I have an SSRS report with 2 sub-reports that had been working fine. Recently I added some additional table sections to the report and I started seeing and issue when the report was displayed in the interactive viewer. The data is fine but the formatting on the last 2 table sections does not appear in the veiwer. The formatting actual...
In SSRS 2005 (and 2008 I would imagine) you can provide functions to the reports, and if I'm not mistaken, whole assemblies as well, which allow you to perform some type of work before the report is rendered. Does anyone know at what point in the ASP.NET page life-cycle is this function compiled and / or executed? I would tend to thin...
I've got a batch of reports to which certain changes need to be applied in how the reports are presented. I know how to modify the Reporting Services stylesheet but is it also possible to apply custom CSS classes to items as they are rendered to the browser? Does Reporting Services support any type of Visual Inheritance that I could us...
I face problem when my file size more than 1.5mb report take to much time and getting failed to send. what can i do for this problem? how can i send this big size file? ...
I created a report in SQL BI studio, and in the sql server 2005 Configuration tools made all the setup. In IIS the directory security is Anonymous Access ticked. I can access the website, but no one else can. I changed the setting to Integrate Windows Authentication and then the people could connect but they had the username and password...
The Particulars: I have a report that displays information about invoices. There is a page break between multiple invoices (each invoice gets its own page). What I want in the report header is the result of this expression (ex. "June, 2009"): =MonthName(Month(ReportItems!textbox1.Value)) & ", " & cstr(Year(ReportItems!textbox1.Value)...
Using BIDS 2005 to create rdl reports. I want to have the report aggregate all the strings in a data group. I was looking for something along the lines of Concatenate(Fields!CompanyName.Value, ","), or Join, or equivalent. But it would have to iterate over all the records in the scope given. I am creating a report of a user's activit...
Hey, I have a report that requires the user to enter their ticket number, then they click view, and it generates. Pretty standard. What I would like to do is have the report automatically export to a pdf when they click view. Does anyone know if this is possible and how I would approach the matter? Thanks for any input. ...
We have an opportunity to purchase 3rd-party chart controls for SQL Server Reporting Services. We are currently using SQL Server 2005 database engine and reporting services, but are contemplating going to 2008 within the next 6 months to a year. What 3rd-party charting controls do you use? What do you see as the good and bad points ...
Does anyone know how to set a height and width on a subreport so that it forces the subreport to wrap into several columns? The delimma: I have to show a legend in a limited amount of space in a page header above a tabular report, and I'd like to limit the height of the legend so that it wraps into multiple columns, as needed. For exa...
I created a report in reporting services 2005 with a report page size of 14in x 8.5in. The report looks fine in the reports manager and also in the report viewer. The issue is when I export the report to PDF, the page size in Adobe states 14 x 8.5 in but when you hit the print button, it selects Letter size (8.5 x 11) instead of choosing...
Is it possible to have multiple formatting of a text string within a single textbox in SSRS 2005? example: The quick brown fox jumped over the lazy brown dog. possible setting font colors as well ...
I have a report that is grouped by Region and then Office location. The users would like the ability to sort on a date value. I can get it to work for the innermost group (Office location). However they want it to sort the whole table. Any ideas? ...
Hi, I have a SSRS report with full of number fields. I would like to have that to be displayed as in one decimal. i tried to use F1. it gives me only one decimal points in html rendering, but in excel exported version it shows 2 decimal points. How can i have just one decimal point both ecxel and html rendering. Please comment. Than...