reports

Crystal Reports - TestConnectivity returns true on dev machine but false on test machine

Hello, I have a SQLServer 2005 database on a client server. I have a VPN connection to their server. I am using the connection code from here When I run the winforms app from my local dev machine it works fine, reports display things are great. When I run the app from testing machine it fails. I have followed the trail and found out th...

Horizontal page in Crystal Reports

Hello, How can I design my report to use it horizontally ? I really need more fields so vertically won't show everything. Thanks. edited: I need the page to be landscape instead of portrait. Sorry, my version is 8.0. ...

Need an info on PHP Reporting Framework/API/Tools

I have created My portal on PHP and MYSQL. I am unable to find a competitive PHP based tool/Framework like Jasper report which can be used to design reports The framework must be an Open source and rich and flexible in extending its basic functionality Do you know solution to problem of reports in PHP ? ...

ms access sum on groups, not on details

I am trying to calculate a SUM in an MS Access report the following way: Group1header - label Group2header - value Detail - example Detail - example Group2header - value Detail - example Group1footer [sum of Group2header value] Somehow, when more detail rows appear, the sum in group1footer is incorrectly calculated (adds value...

What is the correct caption label for a code fragment?

Hey all, I'm currently working on my Dissertation for my degree, and in writing my report, I don't know how to caption my code fragments correctly. For example... ==================================== Diagram/Image: "Figure 1 - My Diagram" Table: "Table 1 - Tabulated data" Code: "????? 1 - some pseudocode" =========================...

Refresh Crystal Reports without "Parameter Values" dialog

I am running Crystal Reports Basic for Visual Studio 2008. I would like to dynamically refresh my report based on a parameter. For instance, I'll have a customer contract and I want to switch between customers based on a VB.NET winform button click. I was expecting the code below to work, but I keep getting the "Enter Parameter Values...

Does any one know of an RTF report generator in Django?

I know about the PDF report generator, but I need to use RTF instead. ...

Image is not coming in the crystal report using stored procedure

Hi, I have a webapplication in asp.net 2.0 on that application i am using crystal report to display image from oracle database. on that report i am using dataset xsd with storedprocedure to display data in crystal report. But the problem is when i am using stored procedure the image is not display in the report in case if i am us...

Non-Unicode CSV Export from SQL Server Report Server

I am using the SQL Server Report Server from Microsoft SQL Server 2005. In the report server report viewer control, there is a CSV download option. The CSV download option is currently downloading a Unicode CSV file, which does not load into Microsoft Excel with the correct column formatting. If I save the Unicode CSV file and convert...

A glorious reporting tool

I'm in search of a glorious reporting tool. I'm aware that glorious is a subjective term but... here are my desires: Dead simple for business types Does not require me to speficy any SQL Can inspect the database's schema to interpret the users requests without programmer intervention Costs next to nothing Can save commonly crafted repo...

I would like to extract the SQL queries from Crystal Report .rpt files, is there a way to do this?

I would like to extract the SQL queries from Crystal Report .rpt files, is there a way to do this? I don't have any of the Crystal Reports products, just the .rpt files. ...

Obtain values from current row when databinding

I'm using DevExpress XtraReports in a WinForms application, but could equally apply to other reporting tools. I'd like to perform some logic per-row in the report as it is "rendered", on a row-by-row basis. Specifically I'd like to hide a barcode if the data for the barcode isn't available. Currently I'm doing the following: priv...

Turbo Delphi & Reports

Hi everyone Is there a way to use reports in turbo Delphi, I searched a lot for Report components, but I couldn't find any ! any hint is highly appreciated. ...

Crystal reports - close the database connection

This is in C#, Visual Studio 2008, crystal reports that came with VS2008 I've got a crystal report viewer form that resides in a DLL. The DLL is responsible for loading the crystal report (based on report filename), and displaying the report on the form. When I'm done with the crystal report, i call dispose on the loaded reportdocum...

The best reporting component for Delphi ?

We are a team that use Gnostice and RaveReports to view, print, mail and generate PDFs of reports using D2007. D2009 is in the roadmap but as Gnostice don't support D2009 we have to wait. In the past the reports was done in code and then viewed, printed etc. Now we have started to evaluate the Ravereports designer and make reports with t...

Dataset Field in Header/Footer disappears in PDF Export

I've been asked to make a small change to one of our RDLs. Essentially, I have some fields in my header/footer which pull information out of the resulting dataset (this is done by creating hidden textbox in the report body, then creating a textbox in the footer with its value set to ReportItems!txtHiddenMsg.Value). Unfortunately, the me...

How to automate tests for reports in SSRS

My current project uses SSRS as the reporting engine. I have the report executing a text command with about 10 variables passed to it. I have been looking for a solution on how to unit test (acceptance or integration, whatever, just some automation) to an SSRS report project. I thought about using this method: Move the SQL text comm...

How to change custom Paper size in Crystal Reports in VS 2005 ?

How to change custom Paper size in Crystal Reports in VS 2005 ? ...

How to change the crystal reports page size in vs 2005 ?

How to change the crystal reports page size in vs 2005 ? ...

Something like Crystal Reports for PHP?

I'm looking for something that works in PHP and is similar to crystal reports. I basically need to have a layout setup that means I can output invoices just by inserting the data, and then send it to a printer. The closest I've found so far is PDFB, but It's a bit of a pain as it needs to have precise positioning. I'd like to have som...