reporting

Best way to print Invoices, Pick Tickets etc...

Well, heres my scenario. Client/Server winforms application with SQL Express as the DB. I need to be able to print invoice, packing slips etc.. i would like the customer to be able to modify the invoices. ie. be able to put their logo or change font sizes etc...basically format the display. Things i have considered so far are. 1) Use...

How to design good looking reports?

Hi, i'm currently doing some reports for SSRS, and i just confirm what i already knew, i suck at this thing of color matching and making things look pretty. Does anyone know a good site or something to help me figure out how a report should look. I need help! any website or recommendations would be highly appreciated. I tried trying to ...

SQL - Need to find duplicate records but EXCLUDE reversed transactions

I have a table of transactions which will occasionally have duplicate entries. If/When an admin finds these duplicate entries, they will reverse the transactions, therefore creating a negative value (but the original duplicate still remains due to regulatory requirements). I'd like to create a SQL query (and use Crystal Reports) to make...

Reporting Services Interactive Sort and Paging Problem With ReportViewer

I have been having a strange problem with interactive sorting and paging within a ReportViewer that I can't figure out. I am using a local report definition and a ReportViewer control within an aspx page. I have AsynchRendering set to true. Everything seems to work fine except for this problem. Here are the steps to reproduce the pro...

In BIRT, how do I access the children of a cell from the cell's event script blocks

I am creating images dynamically in BIRT and adding them to a cell of a grid. The grid is part of a List, which iterates over the records in the data source. I want to be able to modify the properties of the images on a per-record basis. Specifically I am changing the margins - but my problem is that I cannot find the way to access th...

Design of Reporting Services for Java webapp

A design question. I have developed an online test engine web app earlier this year. I have used Java servlets and Freemarker templates and done it entirely following the MVC paradigm. One big missing feature in the application is that it provides no reporting. The initial design of the application did not consider reporting as part o...

How can I programmatically change the Page Header height in a RDLC report?

Does anyone know of a way to change the height of a Page Header in a RDLC report? I have a textbox that has line breaks and would like the height of the Page Header to expand if there are more than one line. Does anyone know how to do this? Let me know if you need more information. ...

A Question About Datagrid And Sql Query

I have 3 tables in database shown below. And I want to make a report just like shown link below. How can I do it with datagrid or datalist? Which one is the best chois? I have tried to do it for a week. http://img123.imageshack.us/my.php?image=61519307xx5.jpg COMPANY: ID_COMPANY, COMPANY_NAME PRODUCT: ID_PRODUCT, PRODUCT_NAME ...

Best method of tracking users for unique visitor reporting using .NET?

I would normally use Google analytics because it is free and simple to implement but on this occasion we need an internally built reporting system. This system needs to be in .NET only because JavaScript is not an option. My question is how do you track unique visitors when you can never be sure that they have cookies turned on? I was ...

Integrating Business Collection, Datasets with reporting services

What are the best practices and implementation solutions for integrating your Business logic classes with Microsoft Reporting services? ...

Export data from SQL2005 stored procedure to CSV

Hello, I want to find a way to allow our reporting guy to export data returned from a stored procedure into a CSV file. The procedure will need a (date) parameter passing to it. Is there a data export wizard I can get him to use, or some other user friendly way in SQL2005 that he can generate the CSV (after providing some parameters)....

SQL Reporting - Can you have a group inside a group?

Hi I'm trying to produce a report that has multiple grouping but does not just show the group as the single field being grouped. I think it may be best shown with an example: > Date <- Grouped, broken by page > Meeting type <- grouped > Meeting_Time Meeting_Place Meeting_Title Meeting_Priority > Agenda_item_1 > ...

automatic error reporting - recommendations?

Can anyone recommend a library/SDK/etc. that is free or for purchase that I can integrate into my C++ application that enables the application to perform automatic error reporting? I have something now that I am using but it does not catch all exceptions. I'm looking for something more sophisticated and more robust than I have now. Any ...

Access rdlc elements from code behind file

can you please give any sample code for accessing the rdlc elements from code behind file. I have a text box in the rdlc file, i have to set the value for that from code behind file. Please help me Thanks P S Marimuthu ...

Templating Engine to Generate Simple Reports in .NET

I'm looking for a free templating engine to generate simple reports. I want some basic features such as : Ability to Write Loops (with any IEnumerable) Passing Variables Passing Templates Files (main template, footer, header) I'll use this to generate reports in HTML and XML. I'm not looking for a ASP.NET Template Engine. This is fo...

How do I group slices in my Crystal Report pie chart?

I am trying to display a pie chart that shows sales by company. However there are a lot of companies that only have a tiny sales which makes the pie chart look rubbish. Is there a way to group companies like this into a single "Other" category? ...

sql reporting serices not showing anything when go to web interface

Hi, A client has installed Sql server 2005 reporting services. When we go to the web bit at http://servername/reports/ we just see a blank screen like: http://img91.imageshack.us/img91/3787/rsblankqx4.jpg We are using windows authentication and I think it has authenticated us as the "site settings" button is appearing and we can alter ...

Good open source Reporting tool/framework for WPF (C#).

I am looking out for a good open source Reporting tool/framework for windows based application (WPF). The database I am using is sql server 2005. The typical reports format which I am interested is for e.g. Trial balance, balance sheet, etc (typical banking / finance reporting application). There should be good support for charting...

Upgrade to Birt 2.3.1 and log SEVERE: Not allowed choice any

After an upgrade to BIRT 2.3.1 have a tons of logs: org.eclipse.birt.report.model.metadata.ChoicePropertyType validateXml SEVERE: Not allowed choice any Any thoughts how to rid of them will be appreciated. ...

Filtering Subreport data on a Winforms report

I am using Winforms Reporting Services (RDLC) to generate a report that has a subreport. My problem is the subreport isn't being filtered by the parent ID. A simple example of the data model might be a Department which contains Employees. In the report I want to show all Departments and have a subreport to show the Employees that bel...