crystal-reports-8.5

Custom Functions in Crystal Reports 8.5 ?

Hi all... I could've sworn there was a way to do this (without DLLs), but going through the first several pages of google, I can't find it. Maybe I'm thinking of something else. I'm having to do some development in Crystal Reports 8.5. I thought there was a way to write custom functions. Something like creating a custom formula then wr...

Can't Set Crystal Report Selection Formula Programatically

Hello all, first, I can't stand Crystal! Okay, that's off my chest... Now, we have an old VB6 app we maintain for a client, which uses the Crystal Automation library to programatically change the record selection formulas in a bunch of Crystal Reports 8.5 reports. There are two reports which are ALMOST identical. I had to change them...

Exporting a report from Crystal 8.5 causes the report to first refresh, then export, with unexpected consequences

We have a VB6 application that can generate reports using the Crystal Reports 8.5 runtime. To generate one of the more complicated reports we have, the VB app does the following: Deletes records from a SQL table (we'll call it Foo) based on the session ID of the user Performs a select statement, and populates the Foo table with the co...

Negative zero using Crystal Report ToText()

Using Crystal Reports 8.5 on Windows Vista or 7, I'm using the ToText function to report a value: totext(Sum ({ap121w7.yrentamt}, {@type1099})*100,"000000000000000000") The result (if yrentamt is 0) is -000000000000000000 The dash (I assume it's a negative sign) is unneccessary and unwanted in my report. Is this a bug, or is there an...

Problem using VB6 and Crystal Reports

HEllo, i have a small problem: i have a Crystal 8,5 Report in a VB 6 application. About 2 days ago, all worked like a charm. Since this morning, whenever i press View REport, it shows on screen but the PRINT BUTTON is disabled, meaning has visible=false. I cant see it so i can print the report. I searched the net like a maniac and st...

Pass sub report fields to another sub report?

Hello guys, I have a pretty complex report. I have managed to create it up till the 1st sub report. Now I have to summarize the 1st sub report's fields inside a 2nd subreport 'horizontally'. 1) How do I pass the fields from sub report 1 to sub report 2 (Name & totals) & list them horizontally/each year? 2) How do I get each summary to...

How can I display a string which excess 254 chars in Crystal Reports 8.5?

hi How can I display a string which excess 254 chars in my report created by crystal reports 8.5? My application that shows the report ia a vb6.0 application. Thank you ...

how can we pass data from crystal report(8.5) to vb form

I made Invoice By Crystal Report v8.5 (Vb6 & Access). There is item Name and Price. At last Net Payable Amount:500(Exp), I need to Show In words(Five hundred). Crystal built in Function is not appropiate for it. So write a function in VB6 and it works nice. Now problem is how i send this value Crystal Report (v8.5) to vb.(I know to sen...

Why my report has strange fonts when I export it to PDF file?

Hi I have a report which has been created by Crystal Reports 8.5. When I run my application (vb6) and wanna show the report, every thing is all right but problem begins when I export it to PDF file. The .pdf file has strange fonts and can NOT be read . I have used "Tahoma" font for displaying text on the report. What is your solution? ...

Crystal Reports group header suppression formula doesn't work

I have a report that groups by two codes, we'll call them Parent and Child. At the top of each page, in the Page Header, I want to print the Parent Name. There are a number of columns in the report, and when the group breaks, I want to display the new Child name, as well as the column headers again. The report should look something ...