I set out today with the intent to parse an SSRS RDL file (XML) using Python in order to gather the DataSet and Query data. A recent project has me back tracking on a variety of reports and data sources with the intention of consolidating and cleaning up what we have published. I was able to use this script to create a CSV file with th...
The application I am working on is generating .rdlc files that will end up being interpreted by Microsoft's WinForms ReportViewer control (not the ASP.NET one). I have only been partially successful with adding the interactive 'sort direction' controls on to these reports. The controls appear on each column and row in the report, when y...
Hi By mistake I deployed wrong version of a RDL file on the ReportServer. This overwrote the existing RDL file (the correct one). Is there any way to retrieve the earlier version of the RDL? Note: No backup of the database is available. Thanks. ...
I have an SSRS report, the layout based on an Excel spreadsheet. Therefore, I have a lot of drawn lines and rectangles to mimic what Excel would print. I also have two images that are loaded from fields in the database, if they exist for the record. If the images are displayed, I have several lines missing from the report. If the dat...
In SSRS, I noticed that the rdl.data cache files are being stored on my dev machine. Are these files also stored on the Reports Server when reports are run? If so, is there a way to avoid creating those files on the server? ...
Over the years, I've been working with SSRS reports (RDL and RDLC) but I have not found a solution to this problem: Let's say I have x number of fields in my report. I would like to highlight all the fields at once and modify the background-color, foreground-color, font and font size, for all fields at the same time. Is this possible...
Hi, I need to show multiple values in a drop down list, and i also need to allow the customer to pick more than one option. Thanks in advance. Luis ...
When I design a RDLC-Report and change the FontSize of a text-box to a smaller value, the height of the text-box is not adjusted automatically. If I try then to adjust the height manually, it's very difficult to find the right height. Is there a simple possibility to adjust the height corresponding to the font size (in the designer)? ...
I am not creating RDL from scratch so maybe this is a problem -- I work on already prepared files. MSDN states that CommandText in RDL file can contain T-SQL query. Ok, this I understand, but what else it can contains? I am asking because the phrasing clearly indicates you can put some other expression there So if I understand correct...