Crystal Reports

Select printer from CRViewer in VB 6.0 and Crystal Reports 8.0

i use Rpt.PrinterSetup Me.hWnd this, to set up printer setup. it prints blank page

Report Versioning (kinda)

Ok, what I need to be able to do is the following: MHP/FINANCE/Rpt 1 Rpt 1 needs to be modified, I need to be able to make changes to report one BUT still allow it to be used as is until new version is done AND retain all past instances and recurring schedules, anyone have any ideas??? I know if...

Crystal Reports last twelve months

I wrote a report that accululates invoice totals for each customer in a sql database based on period and year for period. I manually entered the last 11 months in the formulas by taking current month minus 1, then current month plus 10, year minus one and so forth. How can I make this process...

Crystal Reports 8.5 filed data convertion

How can you do data conversion on the fly for selected records but in indivitual fields? e.g. string data ="5" new string data = "3" (5-2=3) string data = "10" new string data = "8" (10-2=8)

Changing Default Settings for Crystal 11

When you click the Refresh report option, can you change the default to "Prompt for new parameter values" rather than "User current parameter values"?

Crystal Report XI Question

I am working with CrystalReportsXI. On a given patient, lines are repeating the same data, such as name, phone number, and SSN. Any suggestions on how to get rid of the same data? Thanks.

Crystal Reports OBDC (Oracle)

I created an OBDC on the client to link into the Oracle server, and using it in Crystal report, I can only see the system tables, but not the database table. Using the same obdc in Access application, I can see and am able to link all the tables. Do anyone know why is that I can't see the...

Crystal Reports 8.5 and Windows Vista compatibility

I am currently running Crystal Reports on XP pro. All the computers in the Gov is switching to VISTA, Is this version of Crystal Reports going to run on Vista?

Crystal Reports XI: Multi-Level subreports?

If I have a report that contains a subreport. Can that subreport contain a subreport?

No records in detail causes the group data not to be shown

Report is grouped by Loan#, I show loan info in the group header and all the trades for this loan in the detail section. If there where no trades, the report doesn't show the loan at all. I would like to see the group header info and show a msg "no trades" in the detail section when there are no...

Crystal Reports exporting to PDF font error

Hi, I export a report on pdf format. The problem is the barcode is not generated properly from the Crystal Server. We don't know what the causes are.. please help This is the Crystal Server generated: http://www.pugs-es.info/karen/EtiquetasAlmacenar.pdf This is the locally generated:...

Crystal Reports Export Path

How can I set a default path for exporting Crystal Reports from version 8.5?

I need to up load an excel file to sql server db with vb

I need to upload a excell file to sql server. I made a Stored procedure with the openrowset but if i run de stored procedure works, but embebed in visual basic or in crystal repor an error appears.Somethig about serverliked or server trusted i don't rememeber. does somebody an idea? thanks in...

Migration of Crystal Reports 8 to Crystal Reports 2008

How to migrate Crystal Reports 8.0 to Crystal Reports 2008? The crystal reports which had stored procedures of 8.0 are not executing in 2008, can anyone help? Thanks

Crystal Reports embedded fonts to PDF

Hi, I am having a problem exporting my reports to PDF. I am using a barcode font (not as an OLE Object) which I am able to see using the Crystal Viewer and Exporting the Reports locally from my computer. But when Exporting the reports from the Crystal Server, I am unable to generate the pdf with...

Sending a print job to two separate printers using VB 6

I have prepared a Restaurant Software in VB 6.0 and Access 2001. I have to print a prepaid bill in two copies (one for customer and another for kitchen). One epson lq 300+ printer is attached in LPT1: port and another in USB001:port. I printed the Bill through LPT1: port and I could not print...

Printing a Crystal report - paper size

I have an application that uses Crystal reports 10 on a Citrix environment. Suddenly, when trying to print the report from the screen the printer defaults to a strange size of paper (12' x 18') when the printer settings are correctly setup for Letter. ANy ideas?

How do I get a message to show when the report doesn't return any data?

It's been a couple of years since I've worked directly with Crystal so need a little help. I am in the process of writing some technical specifications for reports that will be developed in Crystal. If a report is ran and no data meets the criteria of the report we want to display a message "NO...

Crystal Reports can't connect to Access 2007

We have just upgraded from Access 2003 to Access 2007 and CR-XI can not see the dB's. I think it is the new file extensions with Access 2007. Anyone know how I can connect and see the dB's.

Reporting problem when dates contain zeros in the same field

Using AcuODBC and creating simple lists involving dates, ie, termination date in an employee file. When I select only records that (in this case) do NOT have a valid date in the TERM-DAT I select no records at all. The data is a signed decimal 8 characters with a valid sign. Crystal seems to not...