crystal-reports

How to use JNDI in Crystal Reports

Hi! I have a Tomcat 5.5 running which includes a Webapp with the Java Reporting Components (JRC) 2008. The Server has a different data source than the client, and currently I set it with the setConnection() functions on the tables, and it works fine. The downside is, that this taken 800ms (Damn slow crystal) just to set the datasources...

Crystal Reports on Windows 7 64bit with C++

Hi, i have a qt application that opens a Crystal Reports window. this applications works in WindowsXP 32bit but does not work on Windows7 64bit. I see a blank/emty white screen. i even cant see the buttons of crystal reports. i make another project in C# that opens a Crystal Reports window on Windows7 64bit and it works fine. do you...

ReportViewer 9.0 on IIS 7 not rendering

Hello, I have a reportviewer control that works fine locally and on a iis 6.0 box, but when deployed to the IIS 7 webserver, the control has broken images. The report does return data but the top bar has broken images and buttons. Using Fiddler I see that the images requests are returning a 404 or 500 error. I got the 500 after cha...

Crystal Report: Your Request was cancelled.

Hi Everyone, I am getting the following error message, when i try to access the Crystal Report from ASP page. Error encountered by Crystal PageServer The error message returned is: Your request was cancelled. Reasons for the cancellation are shut down of the server or inactivity. Please try again later. [On Page Server: CRYSTAL.cache...

How to use Crystal Report in pure Asp.Net MVC (without webforms ,controls...)

Is anyone able to give simple steps and example (as possible using vb.net) to create and use a Crystal Report in pure ASP.NET MVC application (without using webforms, controls, code behind ... ) ? Thank you very much!.. ...

problem with rtl languages

hi, i have a problem when i use rtl fonts for my crystal reports. the problem occurs when i export my report to PDF.the pdf file shows all of latin word unmeaning (they are converted to square) for example: in crystal ==> www.tss-dev.com in PDF ==> every latin char convert to char(127)or small square ...

Crystal report or flow document in WPF

I have wpf application and it needs report printing. for example daily, monthly sales. Should I use Crystal report or Flow Document with tabular will do? I know this is naive question. I need faster and free reporting solution.... thanks ...

Crystalreports .NET show group footer only on first occurance

Using C# vs2008 with crystal reports .net I am displaying data with multiple groups (3 groups in total). The first group (or if you like the outermost group) i want to show the group footer only for the first time that group is printed and suppress for every time after. Im sure i need some conditonal check in the group footer section e...

How to create a Cross-Tab Report with Split Grand Total

Can We create such kind of reports using Crystal Reports XI Cross-Tab? Product Sales Comparison +---------------------------------------------------------------------------------+ | | Jan | Feb | Mar | April | May | TOTAL | | |---------------------------------------------------...

Display more than one row with the same result from a field

I need to show more than one result from each field in a table. I need to do this with only one SQL sentence, I don´t want to use a Cursor. This seems silly, but the number of rows may vary for each item. I need this to print afterwards this information as a Crystal Report detail. Suppose I have this table: idItem Cantidad <mo...

Business Objects Infoview: How to Design Reports through Infoview? Suggestions?

Very new to Business Objects, but I have a .NET background and PL/SQL background. I've been able to make the most basic reports, but I wanted to know if there were any good books or resources online that explain in detail how to design reports the way I'd like to such as grouping with sections, having two sections and segmenting only one...

Custom sort within 1 instance of a crystal report group

Using vs2008 crystalreports .net c# I have a report with mutlitple nested groups. Im trying to find a way to do different or custom sort, or specifiy specific order within 1 instance of the groups printed on report Eg report grouping as bellow. Report prints 2 lots of the nested groups as shown. I want to specify the sort order ONLY fo...

Data field formatting

I am trying to format a number field to display in this particular way 0001234, i can do it in VB using the Format(right command, but crystal basic doesn't recognise 'Format' ...

How to link an .xsd file created from a SP to a crystal report correctly

I created a dataset (.xsd) from a stored procedure which takes 2 parameters. The .xsd file is linked to a crystal report. When I load the report no data is displayed. Also I dont want the user to be prompted for the parameters as I know the values in code depending on page that requested the report load. How do I link the parameters to t...

Crystal Reports - PrintToPrinter "The handle is invalid"

I'm using the Crystal Reports Basic for Visual Studio 2008 to print reports. I have just one user that gets periodic errors saying "The handle is invalid". If she tries printing a second time, it works just fine. I've looked over her machine and it looks like it has all the same software as everyone else, and of course it never happens w...

How to run a rdlc using coding.

I have created an rdlc where i have used dataset taken as a new item in solution explorer for designing my report. After binding my report from that datasource which is named as Dataset1. I have created its object and tried to fill this datasource using coding. Now when i runs the folowing code i am not getting any result. What can be ...

pdf is shown but not printed

Hello, I use crystal reports of visual studio 2003. I generate a report and export it in PDF. PDF has embeded TT fonts. The pdf is shown correctly, but when printed the fonts aren't shown (neither the greek, nor the english). using print as images, solves the problem in some computers I tried, but others keep having the same problem. F...

Crystal Report Viewer - Export to/open a PDF after entering parameters

I have a report viewer in place, and i would like the report in question to be opened in a PDF after the user enters parameters and clicks the submit button (instead of the report being opened in the report viewer window.) I did some reading elsewhere and found this snippet rptSP.ExportToHttpResponse(ExportFormatType.PortableDocFormat,...

How to populate Crystal Reports with SQL

Since there doesn't seem to be any way to load old VB6 (ActiveReports) reports in .Net, I need to recreate dozens of reports in .Net. I'd like to do this in the least painful way possible. In VB6, the original authors simply did something like this for every report: adoConn.ConnectionString = globalConnectionObject.ConnectionString ad...

Crystal reports export to excel cell merge issue

When I export from Crystal reports any fields that are marked as "Can Grow" are merged with an otherwise blank row below them. This completely messes up my sorting, how can I resolve this? ...