Search results for query: *

Crystal Reports 11+ only supports the displaying of BLOB data fields when the data type is an image(jpg, etc). Does anyone know of any work-around, utility, formula, etc. so I can display/print a PDF or .Doc type data stored in a BLOB field type?(text format)? Perhaps using a SQL query? Hugh

here is the SIMPLE solution. I talked to CR tech support. Apperently all u need to do is reinstall CR9 again (do not uninstall the installation that gave you all the 1904 errors). That's it. I did it and it solved my problem. Also be sure you are logged in as the non-default administrator...

I have the same problem, any solutions????? Error 1904 and various dll's not registering? CR9

I searched the crystal web site, and yes this exact same problem is listed in the monthly hot fix for April. The link in the previous thread should get you there. More specifically; ADAPT00124904, Patch ID 35102213 and found in CR90MAINWIN_EN_200304 Loaded and all works OK.

Don't have an answer, but I have the exact same problem. It appears to happen when you have suppressed all the subreport lines, YET, you are sharing needed variables between the subreport and main. Thereafter you suppress blank section in the section wizard and suppress blank reports in the...

thanx, I found out the place to enter the sql commands is in the data expert, in the command option. I was unclear on this orginally. Thanx for your help.

Is there a way in Crystal 9.0 to combine similar files. For example I have a current and a history file and the data fileds are exactly the same in each. Linking from one to the other causes many problems from my report. I Know I can build a sql query throurh Crystal 8.5 SQL Designer using...

When exporting to any file, excel, msdbase, etc., those report formulas that link to shared subreport data fields export as zeros. why, how can i fix? thanx

I tried to link to 2 files in Crytal SQL Designer. I get the message: ERROR CREATING LINK I tried linking the files in Crystal Report Writer and I got the message: FILE LINK WARNING: THE SPECIFIED FILE MAY NOT LINK SUCCESSFULLY DUE TO A DIFFERENT TYPE . They are both employee files. The...

I tried to link to 2 files in Crytal SQL Designer. I get the message: ERROR CREATING LINK I tried linking the files in Crystal Report Writer and I got the message: FILE LINK WARNING: THE SPECIFIED FILE MAY NOT LINK SUCCESSFULLY DUE TO A DIFFERENT TYPE . They are both employee files. The...

one more request. I know how to use the sql designer, but how does one do a "union query". I only know how to use the expert dialog. I am not a programmer and thereby unfamiliar with the sql languare. The expert does not give you a option for union inquiry. In summary: How to...

thanx, I will try to see if I am able to use the sql query. However, will I be able to add a new field to each record so I can keep each company unique. In other words, I want to add a company field to to each record to identify from which company (file) it originated from.

I have multiple files of the same data. The files were created by software that seperated companies by files rather than codes in a record. For example the Employee master file (empmstr) is EMPMSTR01 for company #01 and EMPMSTR02 for company #02. Is there a way to temp combine these files...

Thank u ido for ur help. I am doing a left outer join, however it is the right side-file which I want only the first match records. For Example I have a piece of equipment (unit) tied to to a job. I read a file that has all the units and (left outer join) key by unit to another file that...

Is there a way to have the select statement use only the first record of a left outer join. Perhaps a sequel command? I know you can suppress detail lines and/or use running totals. However for various reasons this will not work in my complex report. Perhaps a sequel command? PLEASE...

Thanx for the help. ur 2nd answer seems to be the right way, re: from select statment. However I am a novice using sql command and where exactly to enter them in Crystal. Could you explain in more detail the commands in the sequel statement. Much obliged Hugh

I have a SQL left-outer link. However I only want the first record found in the selection query. How can I "skip" over the remaining matching records in the Select Query? THANX

Is there any procedure (trick) to have multiple Level (2 levels) subreports? thanx for the assistance.