Is it possible to write extension methods for expressions behind RDLC fields? For example, let's say that I have a DateTime field in my datasource that may either have a valid value or may be null. I drag and drop a TextBox onto my RDLC and format its value using the ToShortDateString() method. This works fine for populated DateTime v...
Hello, I have a complex DB in SQL Server format. I've already written several queries to get the anlysis I need, how ever each time I want to add another layer of data/field it takes much time. I am interested in something like the features DabbleDB has/had at which you could select columns from various tables and it would integrate th...
Has anybody successfully used Report Builder 3.0 on a company network (that uses a proxy server) to access and build reports on a server that is not part of that network? We have forms authentication, and all works wonderfully in Report Builder 3.0 when the computer is ‘on the internet’ (NATted, say at home), but the works proxy just wo...
Hello :) I have a parameter that provides a dropdown list in the report, and I would like to make it optional, that is, I want a report to run even if I don't select anything from the list, and to have a Null checkbox next to it, that regulates if the parameter is optional or not. The parameter is declared in stored procedure and is = n...
We are using SQL Server Reporting Services 2008 to build reports. We're accessing the reports trough the Webservice (ReportExecution2005.asmx), render them to html to embed them in an aspx page. Everything works quite well. Only on the computer of one developer images aren't rendering. When copying the url of the image and pasting it i...
I need to use a custom class that is stored in a dll assebly. I have made a reference to the DLL under SSRS 2005 VS 2005 IDE under Report/Report Properties/References pointed to DLL and added under Classes: Fpl.PowerGeneration.WindProdIndicators.Data.Measurements.MeasurementFactory and Instance: MFactory Under Report/Report Propert...
WebERP is an open-source ERP tool. It has a cool custom report writer that allows you to generate reports by selecting fields from existing tables. Just wanted to know if anyone is aware of the component used there in.. And share their experience with it! Thanks & Regds, PG ...
How do I add a subtotal to a matrix in reporting services 2008? If I right click on a cell I see an option to add a total but no subtotal. (I feel like I'm missing something obvious but I've looked everywhere.) ...
hi guys, While exporting my ssrs report to excel,i am getting that report with white background in excel sheet instead of displaying those data within the gridlines.How can i do this? Please help me to get a solution for this!!! ...
Hi. I am working on a project with some existing MS Reports using Reporting Services 2000/2005 and Visual Studio 2005 with the built in Report Designer. I have come accross a report that makes use of a table to display data which is fetched by a Stored Proc. My work required me to modify the report and the stored Proc. I've made the ch...
Hi, I have the following dataset (simplified): GroupA,GroupB,GroupB Weight,GroupC,X,Y a1,b1,c1,0.4,3,9 a1,b1,c1,0.4,5,7 a1,b2,c2,0.6,6,8 In the report I display the ratios - X/Y even for the groups - Sum(x)/Sum(y). But for the final group (A) I need to weight groups B differently according to the weight listed. I thought about some...
I have a report that generates a number of blank pages at the start when rendering in pdf format. The first page has a table with conditional visibility on it, so that's likely contributing, but it's only one page, and there are sometimes 3-4 blank pages at the start, before the meat of the report begins. This only happens when renderi...
We have a grid on our application that we need to render as part of a report that will be rendered in SSRS. The user has the ability to change the order and sizes of the columns in this grid in the application. I now have the requirement to make the printed grid match the column order / column sizes at the time the report is rendered. ...
I have a task that calls the SSRS report server to render the report, then places the freshly rendered report into a SharePoint document library. The report server is set up in SharePoint Integrated Mode. For smaller reports, everything works perfectly. However, if a report take longer than about 90 seconds to generate, the call to ...
I have a report model in reporting services containing 3 tables: Persons Backgrounds PersonBackgrounds The content of the tables are: Persons (ID, NAME) 1, John Doe 2, Jane Doe Backgrounds (ID, BACKGROUND) 1, Female 2, Male 3, Single 4, Married PersonBackgrounds (PERSONID, BACKGROUNDID) 1, 2 1, 3 If i create a new ...
I have a SSRS 2005 report that lists data between two particular dates. I want to restrict the user from selecting more than a week's worth of data (so they can't do something silly and attempt to view five years worth). Is there any way do do a comparsion on parameters that are being entered, and prompt the user if they fail certain ...
I am confused what these expressions are made out of ? i mean is that VB.NET/ VB Script/ Something else with just VB syntax ? ...
* An error occurred during client rendering. o An error has occurred during report processing. + An attempt has been made to use a data extension 'ODBC' that is either not registered for this report server or is not supported in this edition of Reporting Services. ...
We have SSRS running in integration mode inside of sharepoint. When developing SSRS reports we are able to set the date and number formats to recognize regional settings and format appropriately. But when the report is deployed to SSRS the regional formats all revert back to us. Is there a way to have this display properly inside of S...
This is stupid that I can't figure out how to do this. I'm in the SQL Reporting Services Report Manager website. I have some reports in a folder. I want to copy those reports to a different folder so that I can point those reports to a different datasource. I still need the original reports in their original folder, pointing to their...