reporting

Where does a published RDL file sit?

Hi, When publishing a reporting services report. Where does the actual .RDL file sit on the server? I can redownload the .RDL file via browsing through the report manager? But where is this file situated on the reporting services server? Thanks ...

Reporting charts and data for MS-Office users

We have lots of data and some charts repesenting one logical item. Charts and data is stored in various files. As a result, most users can easily access and re-use the information in their applications. However, this not exactly a good way of storing data. Amongst other reasons, charts belong to some data, the charts and data have some ...

How can I get another report to be the last page in reporting services?

I have 2 reports that need to be printed together. The first report has a header and footer that will repeat (if necessary) on data overflow. The last page, which is a form to be sent back. I basically need a way to print the last page without the repeated header/footers from the first report, and send in parameters to be used in the...

Open source PHP reporting tool

Hi All I am developing web based application, i need php reporting lib/class to make the job easy. I need PDF/Excel format. The report based on related db tables(member bills, member info) Is there any advanced open source solution ? Thanks ...

Setting the locale via RCP-Designer...

Hello! Is there an option in the reportfiles for BIRT to enforce a locale? I want my reports to have a german number formating no matter what. Thanks in advance!:-) ...

How to select a different dataset depending on a parameter value in Reporting Services

It is possible to select a different dataset (query) depending on the value of a parameter in Reporting Services? Thanks in advance! ...

What reporting tools can I use for an XML datasource?

I'm looking for a reporting tool that I can use with an XML datasource. The XML files would be small, approximately 50-60K but may be as large as 200K. The goal of our project is to generate reports based on data submitted in the XML file. I understand I could simply use XSLT style sheets and output HTML but I prefer PDF, XPS, XLS, or D...

Advanced report generation library

Anyone know of a reporting library for Delphi Win32 (or possibly in C#/.Net, Java) that provides the following types of features in a page formatting mode (I am not looking for a banded report writer). This is not an exhaustive list, merely some of the key areas of interest. Tables Column and row spanning Rich formatted content in ce...

SQL Server Reporting Service programming issue

Hello everyone, I understand how to manully connect to a SQL Server data source and input SQL statement to generate/publish a report on the web. My question is, I want end user to input some parameter values, then use such parameter values as SQL statement parameter values (e.g. using end user input time range as SQL statement parameter...

What is the best online SQL tutorial for learning to write complex reporting queries?

My SQL skills are rather limited and since I find myself working with a DB (Oracle) a lot lately I would like to get beyond the basic select statements. I want to write queries that do things like get data from multiple tables, sum quantities, compare dates, group, filter etc. What sites can you recommend for getting SQL reporting skil...

Issues with Exported Crystal Report to Word Document

I am having a minor issue playing with my exported Crystal Report, I can generate the reports just fine on our website, however when I attempt to export them to Word documents I don't quite get a document I can do much with. i.e.: I can't position the generated text anywhere in the document, it is almost 'frozen' in place. I would ex...

Help to make decision on huge reporting

Hi All I would like to ask your opinion to my case. We have big table. And monthly we do reporting on that table. That is we need to download up to 20000 records as PDF or Excel file and print it out. I am planning to generate reports in real time. No in advance generation. Is it a good way to solve my problem ? or if u have better idea...

Using Custom Labels for Y-axis in SSRS Chart

Does anyone know how to customize the y-axis labels in a SSRS chart? I'm using SQL Reporting 2008. Specifically, I have already plotted values over time from a dataset into an Error Bar Chart. I want the y-axis to have 3 labels: (Least, Medium, Most) in place of the numerical values. Where Least is at the bottom (y=0), Medium in the ...

ssrs multi column table data gets spanned accross columns and/or pages incorrectly

In SSRS I built a report where a providers name, address, phone are listed in 3 columns on a page Grouped by State. Example Data: What I'm trying to do is prevent the data from spilling over into the next column or page. I want to just move the provider to the next column/page. Any suggestions? ...

Have you tried to use SQLite as the query engine for your *raw* database?

I have made a custom report generator for our database (Oracle Berkeley DB engine). Now it's time for me to add more flexibility and I am in dilemma. Do a partial or a fundamental redesign? Lets assume that I have plenty of time. I can only read the database, I don't have the right to modify it. Inspired from Query Anything with SQLi...

Error trapping when a user inputs incorect information

So, i have recently started learning python...i am writing a small script that pulls information from a csv and i need to be able to notify a user of an incorrect input for example the user is asked for his id number, the id number is anything from r1 to r5 i would like my script to be able to tell the user that they have input someth...

Reporting tool for Excel

Hi, We are developing a Asp.net 3.5 web application for a rather strict environment. We need to generate reports and export them to Excel. Please suggest some tool which we don't need to install into GAC. Because to install anything into GAC we have to go through many hurdles. ...

SharePoint SQL Reporting Services - OutOfMemory exception on large reports. How to solve?

We have a bunch of reports on SharePoint, using SQL Reporting Services. The statistics reports - the ones that aggregate data and display few hundreds to a few thousands records are loading fine. However, we also have reports that display raw records from database. These reports usually have tens or hundreds of thousands of records. So...

A good alternative to crystal reports over the internet

I have so many problems with using crystal reports over the internet. I admit that the web viewer looks good and the reports you can produce with it are really good but... I have issues with diffrent versions on diffrent servers The development tools are worse than access I dont understand it. Does anyone have any good alternatives f...

String aggregation in SSRS 2005

Using BIDS 2005 to create rdl reports. I want to have the report aggregate all the strings in a data group. I was looking for something along the lines of Concatenate(Fields!CompanyName.Value, ","), or Join, or equivalent. But it would have to iterate over all the records in the scope given. I am creating a report of a user's activit...