In SQL Reporting Services 2008, can you format a field conditionally? In Crystal Reports it is doable. I have a field which I want to be bold if another field is Y, and unbold if its value is N. ...
I'm new to using web services under powershell, so maybe I have a basic misunderstanding about something. I'm working with Microsoft's Reporting Services. Here is a repro script. $computer = "rptdev" $uri = "http://$($computer)/ReportServer/ReportService.asmx?WSDL" $reporting = New-WebServiceProxy -uri $uri -UseDefaultCredential -names...
I do not find Report header in RDLC only Page Header shows up when I right click. ...
Is there a better way to allow us to scan back a year at a time in addition to a month at a time rather than just only a month at a time? ...
how can i add a .jpg file in local report in c# withour storing the pics in database ...
Hi, I have a simple table in SSRS which I am using to create a CSV report. The output looks like: a,b,c 1,2,3 4,5,6 where a,b,c are the column headers. Now my client requires a footer row saying how many records are in the file. However if I add a row to my table with the required fields in, the output becomes: a,b,c,records 1,2,3,2 4,...
I am trying to figure out how to group data contained inside a Table. I want to be able to group by data that is similar in a column. For example: Bob, 23, Cereal Bob, 24, Oatmeal Susan, 25, Cream Susan, 26, Horse The above, I am trying to find an expression to use that will allow me to group both Bobs together, and bot...
I would like to display my text in a text box in Reporting Services vertically bottom-up. I already can have it top-down by going to the WritingMode property of the text box and switching to 'tb-rl' but there is no option for bottom-up. I have done some research and would really like to avoid creating an image and putting that into the...
There is a table [ReportServer].[dbo].[User]. But what is the relationship with other tables? And how can I generate the values inside? ...
Hi, I'm looking to implement SQL Server Reporting Services as our standard reporting platform in our company. We were trialing Crystal Reports, but atlas it seems to be plauged by issues. SQL Server reporting services looks to be a great product, but I have a concern or two. I have some existing web apps in coldfusion, and the backend...
I've created a report in SSRS with two report parameters. I'd like the second to update it's values based on the selection in the first. The first is a list of sales agents, and the second is a list of distributors. Each agent can have many distributors. So if the report user selects an agent, I'd like only their distributors to show in...
Hello, We are using SQL Server as our database server. We've built a consumer product and are looking to build a dashboard that has metrics on our user base. We're a team of two and were wondering if SSAS or if TSQL was the way to go to get metrics. Caveats We're not up to speed on SSAS so there would be a learning curve The data n...
I have SSRS report with its own datasets coming straight from the database. I have the report on ASP.NET application page. The application page header has the username and user region details defined in the master page. Now, I want to read this region id label from the ASP.NET page and build my report accordingly. Basically build...
I have a drill through link on the value cell of a matrix to show a detailed report. However when I run the report, users are able to drill through using the sub total of this value. How do I disable the click through navigation for the subtotal only. Answer: Using the “Jump to report” expression (on the Navigation tab, in properties of...
I have several SSRS '08 reports that look great when viewed as a web page or exported to the various formats. Recently, someone wanted a data driven subscription to go out for the report. No prob. They were adamant that they did not want the report attached to the email or to link to the report from the email. No prob. Unfortunately...
(SSRS 2008, using Report Builder 2.0 for design) Hi Folks, I have a tablix that has column groups. Since the values in columns may be different lengths (AND there are a variable number of values to group on), the width of the tablix is hard to predict. What I'd like it to do is to expand to take up as much of its parent (a rectangle) ...
Hi, We're having a hard time figuring how these credentials objects work. In fact, they may not work how we expected them to work. Here's an explanation of the current issue. We got 2 servers that needs to talk with each other through webservices. The first one (let's call it Server01) has a Windows Service running as the NetworkServic...
I am trying to figure out how to pass some of the options from Microsoft SL Reporting to my report in SQL Reporting Services. I need to use them as parameters for my SQL statement in the report and can not figure out how to accomplish the connection between the two programs. During runtime, SL Reporting creates the RptRuntime table that...
I have created a SQL Server 2005 matrix with a total column. I want to be able to change the colors of the totals only so they stand out from the rest of the data. I can change the color of the "total" label, but not the actual data. Can anyone give me a clue of how to do this? ...
Hi All, I am using SQL Server 2008 for reporting. In that when we export report to excel, the footer image or textbox is not exported. Header image is getting exported successfully. can anybody tell me some solution on it? -Kalpesh ...