I've been having loads of problems trying to get a Spring/Hibernate web application to generate Jasper Reports. I have a model populated as a HashMap and the report will display the single entries fine: language, format, date, etc. by getting a parameter that corresponds with a key in the model e.g. model.put("language", "en"); - java ...
I have created a chart using a stored procedure which lists totals by name. However when I create the chart the names only appear for every second element. I have tested this in a table and I get each name correctly. My first thoughts were that it was a sizing issue, so I considerably increased the size of my chart, but this doesn't ma...
Hi! I'm using MS Reporting Services to display my Data. In the report file, I created a table with grouping, precisely with 3 groups. (Reason for this is that I'm doing a right / left join directly in SQL which I supply then to the DataSet). Line1 (Group1): Subject: =Fields!Subject.Value .... this is a main group = grouped by s_id Line...
I was wondering if anyone could make some recommendations for the most impressive charting components for reporting services and analysis server. Has anyone found any animated solutions? Not just static graphs. ...
We are using Reporting Services 2005 on SQL 2005 and when a report is running then Reporting Services seems to block for that user. e.g. navigating in /Reports/Pages/Folder.aspx will wait until the report finishes before displaying anything. I have had a look at the rsreportserver.config file but nothing in there seems to be limiting thi...
When designing a Reporting Services report, and creating a multi-value parameter, a nice dropdown list with the possibility to select one or many items appear in the parameter pane. Is it possible to show this type of control on a local mode report in the Web based Report Viewer? I have tried to set ShowParameterPrompts="true", but no ...
I have an SQL report in a visual studio 2008 project. I need to add a new field to the report but I can't see the data source. If I open the data source pane it is empty. If I run the project the reports runs well. Can anyone suggest a solution? I am new to reporting services. thanks ldj ...
Hi, I am displaying a table in an SSRS report. What I want to do is, if I click on one of the columns in this chart, it opens another report by passing parameters from parent report to child report. How can I achieve this? Regards Manjot ...
Hi, Are there any free and opensource reporting services which we can deploy in a web server, and which wouldn't require any licensing. Actually I'd be interested in the whole framework/toolkit, report designing, viewing, and hosting. It should be able to pull data from mssql database servers. ...
I have a Winforms application that uses the ReportViewer control to display SSRS reports. I have one report with many paramters that must be set by the user. I specifically set one of the parameters to have no default value so that the parameter prompts would display in the report viewer prior to running the report. However, when th...
I work for company A. Company A has a sister company B. Both companies A and B use the same ERP database. I have created an SSRS 2005 report that can be used by both companies. It has a CompanyID parameter that determines whether to display data for company A or company B. For most reports this will be OK, but for company sensitive info...
Nube question: Is there any way to connect Sql server 2008 reporting services to a sybase SQL Anywhere database (ASA or ASE)? (Maybe ODBC ...) If so, have you done it? kindly share experiences and any notable considerations. thanks ...
I've just got to trying out Reporting Services and, although I'm a member of the local Administrators group in Windows, I can't do anything in Report Manager or by connecting to SSRS in SQL Management Studio. In Report Manager (it prompted me for my Windows credentials) I can see the Home page but I have no links to administer security e...
Under Dataset Filters Tab, I want to use OR not AND but when I add a second Filter the AND appears in the And/Or column with no way to change it. Am I missing something? ...
I have a Table in an SSRS report. one of the Table Cells contains the Descriptions of Parts in an order. these descriptions could vary in length and for that reson i have set the "CanGrow" Property to True. when i try to export the report to Excel im expecting that if the text length would exceed the width of the Cell then the height of ...
A SSRS 2005 report that is run by multiple users is generating about 45,000+ records and then being exported to Excel. This is working fine, but when the users try to sort/filter the results they are seeing a huge amount of lag. At first I thought that it was just because of the large number of rows, but we found that when we stripped ...
Hi I have SQL Server 2008 Developer Edition and I'm facing the following issues with the Reporting Services. When I open the Report Manager URL (I get it from the Reporting Services Configuration Manager) in a browser, it shows me a SQL Server Reporting Services page with a folder icon on top left and links with text 'Home', 'My subsc...
I'm working on my first significant Sql Reporting Services project and am having problems with paging. Most of the reports are already working. What is happening is that I"m getting different numbers and locations of page breaks between Web Reportviewer, PDF and Word documents. The word is the closest, but none of the three are really...
I'm having a problem displaying the values for a range of dates in a matrix row. I would like to have a matrix display the following data: Trial Existing Total Yesterday 3 1 4 This Week 5 3 8 Last Week 18 5 23 Month to Date 26 9 35 Last Month 32 20 52 I thought th...
I have a scheduled SSRS report that runs at 5am and takes 5s to process, the output of this task normally appears in the History tab. This morning the report is not in the history tab! A manually run report does appear, and on checking the actions for the morning, SQL5 says that the action ran successfully. My question is this; Has any o...