Situation: Running a report on SQL Server Reporting Services When I do a Preview of the Report all my charts look fine. No problems. When I run a subscription for the report, the chart look different. Like completely different legends are gone etc. Any ideas what the cause would be? BTW the charts are Dundas Charts. ...
Hi all I am using sql server 2005 reporting service to generate report base on a database. There are two columns which are datetime type ColumnA and ColumnB. The report would display a KPI image on this report by comparing these two columns.Below is the expression for selecting image SWITCH(DateDiff("d",Fields!ColumnA.Value,Fields!Colu...
I have a report where I'm counting the number of records for a day. At the bottom, I have the total records for that time period. I'd like to display the average records for each day. An example: I can accomplish this by aggregating the data by date in SQL then just doing the Average and Sum of the count from SQL, but that would co...
I am currently working with an SSRS 2008 report that returns a dataset similar to the following: Job# ClientId MoneyIn MoneyOut ------------------------------ 1 ABC123 10 25 1 ABC123 10 25 1 ABC123 5 25 2 XYZ123 25 50 2 XYZ123 25 50 3 XYZ123 15 15 Where MoneyOut shoul...
I have a multipage reporting services report, and i would like to start from a specific page, not page one as default. Is there a way to do this? ...
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...
I am looking for a way to automate the production of an offline product catalog using product data contained in an SQL Server database. I have thought about using both Crystal Reports and SQL Server Reporting Services for this but there may be something better suited for the job. There is a requirement to display product images also (c...
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. ...
When I set a default value formula for a date parameter in SSRS, such as: =CDate(”01/” & Month(Now) & “/” & Year(Now)) or even: =Now The date parameter control becomes disabled with nothing in it. Anyone know what simple thing (I am sure) I am doing wrong? ...
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...
Hi, I'm trying to get a list of available reports via the webservice for SQL Reporting Services 2005 express edition. Each time I try to call the ListChildren method I get an insuffient permission exception. The code is: ReportingService2005SoapClient rService = new ReportingService2005SoapClient(); CatalogItem[] cItems = null; rSer...
We have a C# Windows Application. We also have SSRS reports. Can we deploy the application so that the reports are rendered on the local machine rather than using a web server? ...
In our windows application, we used crystal reports. If a customer needed a custom report, we could create it and then send them the rpt file. The customer would then simply add the report file to a custom folder, and could access it directly from our application. Using a web app, how is this possible. It seems like anything create...
I use Netbeans 6.7 to develop Java servlet. It defaults to port 8080. How do I change the port number to 8083 for example? ...
In Business Intelligence Developer Studio, I'm wondering why one would want to create a report model from an OLAP cube. As far as I understand it, OLAP cubes and report models are both business-oriented views of underlying structures (usually relational databases) that may not mean much to a business user. The cube is a multidimensio...
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 working with Reporting services in Sharepoint Mode, I am able to show the report in Sql Server Reporting services report viwer , the report has multiple parameters , My question is how do I pass more thatn one parameter from a custome web part to this report. I am able to pass one parameter by implementing the ITransformableFilterValu...
Hi, I have an rdl file uses custom MDX to generate a dataset. The file is opening in Design MOde and removing the custom mdx. How do I stop it from opening in Design Mode? Many THanks, S ...
I have an MVC 1.0 app with a form that works just fine. The app also launches an SSRS using the URL ReportServer interface (**Not the Webform ReportViewer Control!). This also works just fine. But if I export the generated SSRS report (say to .pdf), and then return to the MVC application, no form will work. By "not work" I mean tha...
My SSRS query returns an empty column instead of the actual values when I run the query in Query Designer, using my XML based Dataset pointing to a web service. The actual xml response has multiple element levels and I am trying to view results from more than one level. It works for some levels but not others. The response XML is struc...