reporting

Visual Studio Report: Checking how many lines are still available on a page

Hi, I have a report which has a table to which I keep adding records but there is a certain place I want to check how many lines are still left on the print page and if its below a certain amount I want it to continue on the next page. Can anyone please tell me how to check the number of lines left and also how to tell the report to st...

BIRT - Adding total from multiple dataset

I have a report in BIRT and I want to add a summary at the end. The report is 3 tables that have there own dataset. I want to show a fourth table with the summary information an a grand total. I have trouble calculating the grand total. ex: DataSet #1 col1 | col 2 | Total x | x | x x | x | x xx ...

Custom Delivery Extension DLL not loading - Why?

To all, I have deployed the Printer Delivery Sample and another FTP Delivery Extension. Neither one are showing the WebControl HTML table as it is defined in the custom assembly DLL. When I attach to the browser and access the subscription html content Visual Studio 2008 fails to attach to the DLL and allow walk through of the code. Th...

Package for presenting OLAP data

Hi, I'm managing a very large data warehouse (>1 TB) based on MS SQL 2005. I would like to create a solution for the users to present data from the cubes on-line (web interface). Right now they are using Office Web Components, but it's not so good. I don't have any controls over the reports that they create. I googled, and there are so...

COGNOS 8 Bi value prompt

Currently I have a value prompt added to my report (with UI selected as List-Box) and the date item used is name 'YEAR'. Now when I run the report the values in the value prompt are seen as below: YEAR 2004 2005 2006 What I want to do is get rid of the year tag that is present in the output of the value prompt box, more clearly the ...

Reporting Tool or Software for Printed Forms?

We are creating a new HR application (.NET) that requires printing of complex forms (IRS documents, employment forms, pay checks, etc). Some of these would be printed on preprinted stock (i.e. W-2s) while others would need to save the formatting within the report/form design. In our OLD legacy applications, we have used C programs to...

Recommended reporting tool for smaller applications?

Hello, There are quite a few VCLs for Delphi to build reports, so I'd like some feedback on which one to check. It's just to build a few pages, ie. a microIVS application, so I don't need enterprise-level solutions. I don't expect any open-source tools, but if there's a good one out there... I know about the following: Rave Reports,...

SQL Server Reporting Services - Report Model: API (build custom report builder)

I am looking into the idea of creating a custom report builder and data tool to replace the ssrs report builder. I am wanting something more like a query builder and data export tool rather than reporting. The thing I want to use is the report model. I want users to select field from report model, render the sql, then exec sql and retu...

sql join history table to active table SSRS report

I'm trying to pull results from a database (sql server 2005) which takes 4 tables: Subscriber S, Member M, ClaimLines L, ClaimHistoryLines H Query is as follows: select S.SBSB_ID, M.MEME_NAME, (CASE L.CLCL_ID WHEN '' THEN H.CLCL_ID ELSE L.CLCL_ID END) AS CLAIM_ID FROM CMC_CDDL_CL_LINE L, CMC_MEME_MEMBER M LEFT OUTER JOIN CMC_CLDH_DEN_H...

How to properly create a denormalized reporting table?

So we have reports which run, that our client runs multiple times daily and some of these reports hit very important tables which I'm not a fan of. We currently have a small reporting table which is populated when a new user signs up. The user signs up and the aspnet_membership table is populated, then another sproc is run to populat...

Matrix Reporting Services Problem

I have a matrix with rows indicating a name (Ex Store name) and I have data pertaining to that in the DATA cells. I also have another date field in this format (MM/DD/YYYY). I would like to use a cross tab between Store Names and Just the Month of the date field. Jan Feb Mar Apr (From Date) A (Store Name) 10 5 ...

How can I display charts with a asp.net control on web page?

I want to display chart on my web page for which I have the the source (for X & Y axis values) table in sqlserver. ...

C# backgroundWorker reports string?

How can I report a string (like "now searching file. . .", "found selection. . .") back to my windows.form from a backgroundWorker as well as a percentage. Additionally, I have a large class that contains the method I want to run in the backgroundWorker_Work. I can call it by Class_method(); but i am then unable to report my percentage d...

vertical column headers in microsoft reports possible?

I have a report that can have 20+ columns I need to be able to generate column header text vertically such as: x | x | x | x | x | x | x | x | ------ 1 | 4 | 8 | 4 | and so on, is there a way to do this in the .rdlc? Or is the use of images my only option? ...

Lightweight Java reporting engine

I'm looking for a lightweight java reporting engine to be embedded in an applet application. My first option was Jasper Reports, but the jar is over 2Mb, a little too heavy (and too bloated) for my needs. I don't know if there is modular jasper distribution, with funcionalities split in several jars (like html rendering, pdf, excel, com...

What is your favourite strategy for tackling reports in ruby projects?

Recently, a customer required a complex report with multiple transformations on a large dataset. I employed Ruport - which is an excellent choice for quick and dirty reporting. However, after a few trials I realized that ruport nested groupings and normalized data don't go together. The choices that now remained included: Denormalize ...

Reporting Services custom code not executing

I'm using this code in my report, to alternate row colours of grouped rows. http://stackoverflow.com/questions/44376/add-alternating-row-color-to-sql-server-reporting-services-report/83832#83832 It works correctly on my development server (SQL Server 2008 Developer Edition), but not on the live server (SQL Server 2008 Express). Is the...

Best Architecture for Reporting Application in ASP.net ( with dynamic Sources)

Hi the Requirement in simple words goes like this. Its a charting Application ( kinda Dashboard) with multiple views (Charts , PDF and Excel) DataSources could be primarily from Oracle but there are other data sources like Excel,flat Files....etc. Charting library would be Component art (I would like to try the new asp.net charting bu...

How to Find Out page number for specific member of a group in a .rpt file?

Hi! is there any way to find out page number in a group for specific title??? imagine that we have these 3 Hierachical group: A -B -C and B has several Items in it. now can you help me to get page number of for example one of B's members when viewing in crystal viewer??? Is it Possible? whit this achivement I can create a cont...

SourceSafe reporting - how to get custom reports in a usable format?

I'm hoping that i'm simply missing something, but I really can't see how to get the report I want out of SourceSafe. All I need is a report of the check-ins and corresponding comments for a particular date range. So, for example, I can see who has checked in what in the past month and what they said about the check-in. I wouldn't imagi...