I have a table with a group. I'm using a toggle item in the details group. If the user clicks in the header group the details are shown. I want to change the background color of the header group rows that have its details expanded. In other words, I want to change the property of a report item based on the status of a toggle item. Is t...
Hello, Trying to debug a deployed SSRS security customization (to use forms auth) as described here: http://msdn.microsoft.com/en-us/library/ms160724(SQL.90).aspx. There is a section about debugging your application... I followed the steps I think, but I cannot debug this. Has anyone got any advice as to how to debug a custom Forms ...
Hello, Can multiple SSRS share the same DB? We're getting into an SSRS customization scenario, which may adversely affect our existing SSRS features, and I wanted to see if it was possible. Thanks. ...
Hello I've the following expression in my report. =FormatNumber(MAX(Fields!Reading.Value, "CellReading_Reading"),3) Now when the dataset is empty 'Fields!Reading.Value' becomes empty and finding their maximum is invalid. How can i check if the entire column is empty? I tried the following with no luck. =iif(IsNothing(Fields!.Readin...
Ok I need to display total talk time of an agent that is coming into SRSS 2005 from SQL 2005 as an INT. For the life of me I cannot figure out what combination of expression editing or format editing I need to use. For the detail portion I can use: =DATEADD("s", SUM(Fields!Talk_Time.Value), CDate("00:00")) And it will return: 1/1/000...
We are using SQL Server 2005 Reporting Services (SSRS). We need to disable the hyperlinks for drill down reports while exporting the reports to excel from report viewer. Is there any way to achieve this in SSRS 2005? ...
I have a report that needs to be able to render a very large amount of pages (about 4500 in this instance) in a web browser. The total time needed to finish on the report server from start time to end time is about 30 mins for the instance that I am looking at. Does anyone know what options exist for handling the rendering of such a la...
Is it possible to have 2 report parameters set the same actual parameter? For example, the user should either be able to type in an ID, or select it from a dropdown list - for the query to then take that id and run the proc for that id. ...
Hi, How can i get a column in an SSRS 2005 report to render control chars like new lines and tabs? For example: SELECT VW.System_name + CHAR(13) + CHAR(9) + ' > ' + VW.PTS_NAME + CHAR(13) + CHAR(9) + CHAR(9) + ' > ' + VW.FEED_NAME as Name In SSRS (and SSMS Results to Grid Mode) table will render as: TRIPLE > HYBRIDS > HY...
Have an issue in exporting a slightly complex report to excel from an rdlc. Exporting a simple tabular report works fine, but getting a null reference exception with a more complex one. As is usually the case, it works on the server in the development environment, but not in the test environment. The server in the development environme...
I have a report in reporting services 2005 that includes a list with an embedded matrix and am attempting to put a border on the list, however, when I run the report in visual studio the matrix is growing past the end of the page and therefore the border is growing with it causing it to grow into the second page. It appears that there wa...
I have a MS Reporting Services subscription implemented which emails out a CSV report as an attachment. The email is received with the attached CSV file no problem, EXCEPT for users with Lotus Notes. With LN users the contents of the csv file are embedded in the body of the email. Any suggestions on this? UPDATE: Might Lotus be handin...
I have SSRS set up with IIS and SQL on separate servers and can no longer add new subscriptions from the web interface. ...
I am trying to create horizontal bar chart to look like a pill chart. I would like to take a either a stacked bar chart or a 100% stacked bar chart and put rounded ends onto this chart. I would only be using 1 row within the chart. One idea I had was just putting rounded images on either end of the chart to accomplish this but I'm n...
Hello, We setup a custom implementation of an SSRS report server to use forms authentication. Can we use a port other than 80? We are getting 401 unauthorized when we do use another port other than port 80. Any ideas? Thanks. ...
Hi, I inherited an SQL Reporting Services .rdl project from somebody and need help fixing some functionality. In each row of the report, there is a subreport. In order to save space the subreport is divided into 3. Such that in each row of the report, it splits the data of the subreport into 3 smaller tables. Right now, it fills these ...
I have a report with cascading parameters. The first parameter is Finanical Period Type, being either Month or Week. The second parameter is a list of either financial months or weeks depending on what was selected for the first parameter. This all works well and selecting a series of different Financial Period Types in sequence correctl...
We have a requirement where date time values would be passed to the report parameter which is of "String" date type (and not "DateTime"). The report parameter would be a queried one i.e. it would have a list of values in which the passed value should fall in. The strange part is that if the date time value passed to this parameter is pa...
Hello, I am using a custom forms authentication component in SSRS 2005. Everything works great with that except for authorization. I was hoping to be able to configure authorization so that it would control which features were available within the application. So if I wanted the user to only have access to the report builder, I could...
I am learning SSRS so this is probably an extremely easy solution. I have a bunch of reports that were rebuilt to match some old Access reports. For each report, we have to be able to run Current, Last, Next or Adhoc dates. Is there an easy way if a user selects Adhoc to then show the parameters selections for Start and End Date for t...