hi, I have to apply group on several columns in a report. I have to keep some of the columns in a rectangle. and I have to apply gruop on rectangle on regular columns too. Please tell me in what way I can do this. Please respond. Its urgent!!!! ...
I am using the web service “ReportingService2005.asmx” to set parameters of reports and linked reports. Here for I call the method “SetReportParameters(NewItemPath, Parameters)”. This works great until I try to set a parameter of the type DateTime. Here I get a format exception. The reason for this is that the value is a formatted string...
OK, I have a report in Reporting Services 2005 backed by SQL Server 2005. I use some C# code to generate 10 records. Maybe 12 columns. There are only 6500 records in the table. I record those records to the database and then simply display them. So the Reporting Server isn't doing any calculations or anything intense that I can tell...
I am using ReportViewer 9 in WPF to talk to a remote SSRS server (because I have a SQL Server 2005 Reporting Services requirement) to add reports to a WPF .NET 4.0 application. I can create a project and run ReportViewer 9 using .NET 3.5, but I cannot (either from not being possible, or my lack or knowledge) get it to run within the WP...
I have a SSRS report with a few dropdowns that are chained together. Basically a item is selected from dropdown 1 which then populates dropdown 2 and so on. The issue I am having is that in dropdown 3, which is a multi-value populated from a query I want to allow no selection. Problem #1 Although that report parameter is set to allow bl...
I have a report which, when rendered on its own, has the following performance times (taken from ExecutionLogStorage table): TimeDataRetrieval: 6776 TimeProcessing: 142 TimeRendering: 30 When this report is used as a sub-report which is repeated 34 times, the performance of the overall report comes out as follows: TimeDataRetrieva...
Question: I have written a console program that uses the SQL server 2005 web service to upload reports to SQL Server 2005 reporting service (so that I don't have to upload 100 reports by hand everytime). It works fine locally, and remotely. But now, the problem is one server uses SSL so rs.Url = "https://hostname/ReportServer/reportserv...
Hi I have a dataset as follows SELECT WEEKNAME AS WEEKSTART, CUSIP_BASE AS CUSIP, case when FK_BBGFTPStatus = 5 then 'Failure' when FK_BBGFTPStatus = 8 then 'Failure' when FK_BBGFTPStatus = 9 then 'Failure' when FK_BBGFTPStatus = 3 then 'Success' end 'RESULT' FROM Glossary WHERE (FK_BBGFTPStatus = 5 OR ...
I have now seen it several times and was wondering if there is a solution for this problem. WHen I run procedure (which I have heard is the fastest method) it takes 1 sec but in report manager it takes like 20 sec. And if run the query in report builder (BI) it takes appx.17 sec and the last 3 sec to render the report. Any suggestions h...
I am building a report in Reporting Services 2005, where the data is retrieved from an Informix database. The connection to the database is declared via ODBC. Here is the simpler version of the query: select prodtype, familynum, family, sum(invested) invested, month(recevdate) month, year(recevdate) year, d...
I have a batch detail report in SSRS 2005, the left most column is an NTEXT SQL field. I need to show the field in the report either as: 1). A collapsible text box so users can view detail in the field by clicking the expansion control OR 2). As a tool tip, so when users hover over the column, they can view the full detail I can find co...
Hi, I've put together several reports which render exactly as I'd like them to in the preview in Visual Studio, but when I view them in a web browser, they render as required initially but are quickly squished into the left half of the browser window by the viewer. The zoom level is set to 100% - setting it to Page Width zooms the repor...
Hi I am trying to make a report that lists all the subscriptions on our report server, the report they are on, the times and days they are run on, and the reccurence. So far I have been able to get a list of the reports and schedules of the reports. I cannot seem to understand what the values and columns in the Schedule table mean. ...
when the multivalued parameter is selcted how to get the valu in textbox? eg my dropdown box is having select all, success,failure i want to display the above values in textbox..so i have selected the value for text box as Parameters!value.Value(0) it works if we select only succes or only failure in the drop down box but when we sel...
I'm new to BIDS. In Business Intelligence Developer Studio 2005 in the Report designer, the default toolbox has Report Items displayed. My end goal is simply to default the properties of the controls in that toolbox. For example, the Textbox control should be defaulted to a specific font and background color. How can I accomplish thi...
The question is simple, I couldn't find any solution though. If it is possible, how do I repeat a field that's in the Footer on a new page if it doesn't fit the container? For example: I have a column that can store up to 5000 characters, and I must display it in the Footer. So if it reachs a certain number of characters, I'd like it t...
Hi There View have a central report server running SSRS, all our reporta are already built and present on the server. How can i now dispaly one of those reports using ReportViewer Contontrol in ASP.NET? My Control: <rsweb:ReportViewer ID="ctReportViewer" runat="server" /> My CodeBehind: var reportServer = ctReportViewer.ServerRep...
Hi, I have created reports with drill thru functionality. I use a blue foreground and bold font to give the user hints as to what they can drill into. I would like to be able to turn off the blue, bold, and even the drill thru action when the report is being printed or exported. I have thought of basing those properties on a hidden/no...
I built a report with one parameter being a menu of names, and the default value being <ALL> Clients wanted the default to be the person logged in. I can easily get User!UserID the default for a text box, but if I change the menu from names to IDs, it will not pre-select it on the menu. Instead, it adds the "" thing to the top of the ...
Hi, Is it possible to filter a named query in a reporting services data source view on the global user ID? I would like to do something like select UserName, ContactNumber, Email from Users WHERE (Users.UserName = User!UserID) so that it returns the name and contact details of the user running the report. Any help would be much apprec...