Search results for query: *

I was hoping for a Repeat group header on each page switch. Thanks for your idea - I'll give it a try.

Yes, I can right click, choose Change Group, go to the options page, and there is a checkbox for: Repeat group header on each page. The checkbox is on, but in certain cases I want it to be off, and would like to change it via code. So how do I set Repeat group header on each page to FALSE in...

Is it possible to change the "Repeat group header on each page" via code? I have code like this: For kk = 1 To oCrystal.crReport.areas("GH2").Sections.Count OSection = oCrystal.crReport.areas("GH2").Sections(kk) OSection.Repeat_group_header_on_each_page = FALSE I cannot determine what the...

We use the Export data only for when they want to take the report data and do further calcs. I used Dell's (Hilfy) suggestion of an extra group header for the second row. That works well. Thanks for all the ideas.

For Problem #1: The dummy label works when exporting to PDF, etc, but unfortunately when exporting to Excel data only it does export that field. I wonder if there is another way for Problem #1.

In Crystal reports, exporting to Excel works fine. However, exporting to Excel data only has two issues: Report looks like this: jan feb mar Tom 100 110 220 The months (jan feb mar) are in a Group header. Problem #1 When exporting to Excel data only, the "jan" moves to...

Thanks for the information that a formula fails if a null is encountered. Most helpful.

This is what I want: (CurrentFieldValue = 0 and {testH.UHEAD3_13} ="") or ({test1.ctotid} IN ['O','C'] and {test1.REP} IN ['No','Nc','NC']) However, it suppresses everything. if I use the first part, i.e.: (CurrentFieldValue = 0 and {testH.UHEAD3_13} ="") it works OK. How do I enter my...

Can anyone help? Exporting to Excel from the Preview window and then from code causes some interference. Each export works independently, but doing both in the same session causes problems. Any suggestions please?

More information: I tried this with a simple report with just Details. Same problem. These are the lines in my export code: oExport.DestinationType = 1 && Disk File oExport.FormatType = 29 && Excel 80 oExport.ExcelAreaType = 4 && crDetail oExport.ExcelTabHasColumnHeadings = .T...

Hi The error when I run my code is: MESSAGE: OLE IDispatch exception code 0 from Crystal Reports ActiveX Designer: Failed to export the report. Error formatting the page... Note: Only get this error if exported from Preview first. If exported report first, it works fine without error. I am...

I can export to Excel from the Crystal Viewer window, and I can also export directly to Excel using some code that I wrote. However, if I try to do both in the same session, the second one gives an error. I have to close my application. When I run it again, it works fine. Any suggestions on...

Sometimes the Report viewer gives this error: Crystal Report Viewer ----------------------------------------- Failed to export the report. Error formatting the page. I guess this is an internal error message. How can one trap for this error and give another message? I tried code in the Error...

That works! Thanks.

Can I indent the second line of a field? In format I tried -.5 for the first line indentation, but CR9 does not allow negative values. How can I tell it to indent the second line, so it looks like this: Jan Feb Mar Freight adjustment 10 20 30 for year end...

When choosing Export from preview window, most users get two options for destination: Application and Disk file. I have a problem with two users who only get Application, not the "Disk file" option. The Application option works fine - they can view an Excel spreadsheet OK. The file...

That sounds like a printer driver issue. Upgrade the problem PC to the latest version. Cyril.

Several users of my app report that they cannot print reports. It looks OK in Preview, but prints very strange fonts. A search on the Crystal site reveals that this is a known issue. http://support.crystaldecisions.com/library/kbase/articles/c2013278.asp It seems that it is a printer specific...

Yes, that will work. But does that mean that the expoprt to HTML thru Crystal does not? Thanks.

Thanks for your reply. I am using Crystal 9 and RDC and installing runtimes needed on the users PC. I'm just starting off with this, so I don't understand yet what your advice means... When I bring up the preview window and she clicks on the Print button, will it then ask her to select a...