crystal-reports

How it is possible to print client side(browser) datetime in crystal report?

Hi, In asp.net website, i am using crystal report. My question is very generic i.e. How it is possible to display client side (browser) date and time? Actually in my case our website is going to hosted at India, while that site is used by user's at SWEDEN. Now the problem is that when user request for report then it is displaying serv...

I get 'out of stack space' with crystl32.ocx / vbasic 5 when I run the report twice

The first several times I run the report it prints OK but when I try to UnLoad the form that's running it I get 'Out of Stack Space' error 28 and the program terminates with that error. The details point to to crystl32.ocx version 4.6.1.0 as the problem. How can I release stack space when the report is closed??????? ...

Crystal chart, colour highlight by 3rd element

Hi all, What I'm trying to achieve seems fairly simple but I've not come across a way to do it. I'm trying to create a chart using 3 elements: string 'Vehicle' int 'Number of Vehicles' bool 'Is Van' So basically the string and int represent the x/y values and the bool is needed to shange the colour of the bar chart. If the vehicle is ...

Dynamic Crosstable cell width in crystalreport

Hi everyone, I'm actually working with Visual Studio 2008,and i'm using the embedded crystal report module. And i would like to know if it's possible to make a dynamic crosstable with various cell's width. I have imagine to use the "Expert condition" but i haven't the possibility to modify the width. I have just one cell which will be ...

The parameters being passed from main report are not being passed into the command

I have a subreport that gets its parameter values from the main report. I can see that the parameters are getting to the subreport but they are not overriding the defaults values that were set up in the subreport when I originally created it. So if the default value was a 1 but the main reports parameter value is a 5, the subreport wi...

How do I center a crosstab in Crystal Reports XI?

I have a crosstab that I would like to have automatically centered (left to right) on the page. I would have thought this a simple thing. For example, on a web page I could do something like "align=center". In a java GUI I would use a layout manager. In GWT I would use a panel. In Word I would use Ctrl-E. In Latex, \centering. ...

Crystal reports print option

I want to add an option to print crystal report.I don't want to open the pdf but only show the print dialog before taking print.Any Ideas? Ref ...

Alternatives for Crystal Report

Hello, we are switchting from access reports to another solution we startet with crystal reports and had a few problems but we found solutions (e.g. dynamic images) BUT crystal reports doesnt support a subreport in a supreport, so we need a new reporting tool. any sugestions? thanks! ...

VB.NET + Crystal Report = True?

I'm making a VB.NET application that needs to generate a number of different reports. The customer is already using Crystal Report and is happy with that so the plan is to integrate with that. What I basically want to do is: Manually create template(s) in crystal report User selects type of report in application User filters the data...

Is there an api to create a Crystal Report

Is there an api that can be used to create a crystal report programmatically? I have reports written in Powerbuilder that we need to convert to Crystal and I would like to automate the conversion. ...

Cystal reports with Linq2Sql

Hi, I want to use Linq2Sql as the data source for my Crystal reports. I have all my data in my domain objects in the form of Lists. The problem is all my domain model resides in a different namespace in the form of a .dll. And when i try to assign a data source for my report in Database Expert window, under .NET Objects, i can only see ...

How are these strange characters getting into Crystal Reports PDF Export?

We have a Crystal Reports 2008 report which merges database data with some SurveyMonkey free-text data stored in an Excel spreadsheet. The free text data looks OK in Excel, looks OK when copied/pasted to Notepad, and looks OK in the Crystal Report. But when we export the crystal report to PDF, a lot of strange box characters get append...

Crystal reports export newline to excel data-only

I have a formula that generates a string separated by newline characters (added using the ChrW(10) and ChrW(13) methods). This works great when viewing the report in crystal format, but when I export to excel data-only I want these newlines to be each in a separate row. Instead, they simply show up as a box in excel (the unprintable char...

Crystal Report PrintToPrinter Timeout Error.

Hi All In VS 2008, I have a crystal main report with about 20 sub reports. These sub reports all run their own individual query. When viewing the report in CrystalReportViewer, I can see the entire report without any hassles. The same thing happens at the client's PC. The problem comes in at the client when using the PrintToPrinter fu...

Problems exporting a 3305 page report (95000 records) using Crystal Reports 8 to RTF/Word/Excel

I'm having problems exporting a 3305 page report (95000 records) using CR 8 to RTF. When exporting a TXT file, it works. But... When exporting a large RTF, the program hangs at about 42% of the export process. Later it frees up the system, appears to finish, and outputs a file. The file itself is not complete (many records missing...

Problem with PDF format in Crystal Report

Hello everyone, One of my friend suggested me to use this site in order to find an answer my question that struggle to overcome. I am using visual studio 2008 and I am preparing reports for some forms, and I wanna print this document as PDF format. I am opening my report as PDF format but when I open as PDF format my report has page b...

Crystal Reports in ASP.NET, language problems?

I have a bilingual ASP.NET project that includes a lot of rpt files which are Crystal Reports files. I have never really worked with these kind of things but I should now test that it's possible to deploy these in both languages and so on. By bilingual I mean that these reports should be shown in one of two langauges depending on which l...

How do I upgrade my Crystal Report libraries in a .NET 3.5 project to CR XI R2?

Our project currently uses Crystal Reports for Visual Studio 2008. We need to upgrade to XI R2, but I'm having problems doing so. Here are the steps I followed: Install Crystal Reports XI R2. Collect updated assemblies from the GAC. I did this because I couldn't find version XI libraries in the "Add References..." dialog. I verifie...

How to make a total and Grouping a report

Using Crystal Report 8.5 Generating a report from table1 My Crystal Report Output ID Name Date Totaltime 001 Raja 23/02/2009 08:00:00 001 Raja 24/02/2009 10:00:00 001 Raja 25/02/2009 09:00:00 001 Raja 26/02/2009 11:00:00 001 Raja 27/02/2009 07:00:00 002 Ravi 23/02/2009 11:00:00 002 Ravi 24/02/2009 10:00:00 002 Ravi 25/02/2009...

Search for used columns in Crystal Reports

Background: We have two directories of Crystal Reports for both the web side of an application and Win32 side. Both front-ends share the same database and for the most part, the same reports....it just so happens they are in different locations. Question: We have to change a column in many of the reports from one to another and wan...