Search results for query: *

Thank you all for your valuable input. Indexes are becoming clearer now and I feel more confident that I can understand their impact to report performance. Thanks Again, Chris

Thank you RiverGuy. That information helps me to better understand how SQL works. Do you know if regular views take advantage of the indexes on the base table/s? In other words, if I use a regular view in a report, and the report has selection criteria...will the index of the base table/s...

Hello, I'm not sure exactly where to post this in tek-tips... Coming from an AS400 reporting environment against a JD Edwards ERP system - The ERP system had physical files(PF) and logical files(LF). A single PF could have multiple LF's, each with different Key fields. K01 identifies the...

Can you take a screenshot of the table linking structure and post it? I'm not familiar with CR 6, but it hopefully gives you some visual of the tables and how they are linked. I don't understand...If you don't have access to the Access DB, and cannot connect to it, how are you running any report?

Hello, I don't believe that will work. I believe the problem is with your data table(based on looking at screenshot6). If your raw data looks similar to the following: Invoice# Part_Desc Line? Qty Sale Extended 000001 Head Gasket 1 000001 2 1 195.00...

Based on my knowledge, which is limited, the convert/cast function changes the data type of a field from one type to another. Like changing a numeric type to a text type. The embedded data in the DB file is stored as an image type. I'm afraid we would lose the formatting of the files if we...

Hello Ido, I don't understand what you mean. I have placed the link_embed file in my detail line on the report. The only files that produce output are .jpg, .bmp, and .tif. Files such as .rtf, .txt, .doc, .htm do not produce output...they are blank. In my DB/application, I can link/embed...

It appears that your data may be stored similar to the following: Line > Data 1 > Part description 2 > Sales info (qty, price...) 3 > Part description 4 > Sales info (qty, price...) and so on. Your sales info and part description are in different detail lines. Your one screen shot shows 29...

Thank you SBerthold and IdoMillet for your replies. Bottom line...it appears that a third party software is required to interpret text/html/pdf from a DB. For our application, Crystal Runtime is invoked and launches the reports. Our users typically do not have the CR application. Adding a...

My findings related to CR XI: 1. You can utilize Object Linking and Embedding (OLE) to print a document (.doc, .xls, .ppt, other) within a Crystal Report(CR). So, the statement that CR can print these types of documents within a report is technically a true statement. However, this method...

Issue – Trying to have documents(.doc, .xls, .ppt) print in reports. I have reviewed some related threads but most appear to involve graphics. Graphics print OK, it is the other file types that are giving me a problem. Info: CR XI, ODBC connection to either SS 2005 or Oracle10g. Software...