Recent content by rosalindr

ksbigfoot, If you double click on the subreport, Crystal opens another design tab containing the subreport. Click the refresh icon (lightening bolt or rotating arrows, depending on your version of Crystal). You will be prompted to enter the parameter you used as a link to your main report...

I may be misunderstanding what you mean by "text fields." Are these column headings over fields, or are these text objects in the details section, with or without embedded fields? CRilliterate's suggestion will show if the link you are using to the main report is screening out data from your...

Insert a linked subreport into the Main report. Use the Wizard to create the subreport (or use an existing report), and link it to the Main report by representative name or number (whatever matches). Finish the subreport, and return to the main report design window. Select the subreport, right...

It sounds like "Supress blank subreport" is checked in the Subreport tab of the Format editor. 1. Select the subreport in the Main report design window. 2. Right click and select Format Subreport from the popup menu. 3. Click on the Subreport tab and uncheck "Supress Blank Subreport." 4...

Advanced reports could include a combination of Crystal's advanced features like: Subreports, formulas, joining multiple mismatched tables (always fun), embedding fields in text objects, conditional formatting, unusual formatting, running totals, etc. A simple reports is a tabular report with...

Yes, five individual (named) licenses come with Crystal Reports XI Pro or Developer. Five concurrent licenses will set you back $7500. Roz Rogoff www.mytrainingdept.com

Howard Hammerman sells several different training products, including a CBT of an older version (I think 8 or 9) of Crystal. I just finished writing Hammerman's Jump*Start Crystal XI Level 1 and Level 2 course books. While these are designed for instructor-led classes, you can use them on your...

CDX are Foxpro. Use the Microsoft Foxpro VPF Driver, VPFODBC.DLL, 6.01. You can download this from the Microsoft website. http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx When you set up the driver, select Free Table directory. Then enter the path where your DBF and CDX...

A Union Query is done in SQL. It is a way to select data from two databases or tables, and combine the data into a single table. If you have Crystal 9.0, you can create a SQL Command and use the resulting data in place of your two databases. A Union Query is especially useful if the links...

Check out www.hammerman.com first. Hammerman has several similar applications for a lot less $$. Roz www.mytrainingdept.com

Since you have no data, you will not have any continuation pages. That means there is no place for your page 2 sections to go. That's why you are getting the message. Roz www.mytrainingdept.com

Mondi, I am not able to replicate your problem. Which version of Crystal are you using? Do you have any fields checked as "can grow" or "keep together" in your page header? Do you include other sections in your page selection criteria that may increase the total page size...

I did this for a DD250 form which has a boxy first page, and open area for the continuation pages. Don't put your first page in the page header. Create sections in the header, details, and footers, for page 1, and another set of sections for the continuation pages. Use conditional formatting...

Are the months in a linked table? If so, use an outer join. If not, create a monthly table, join it to your main table with an outer join, and use that table for your groups. Roz

I'm not sure what you are asking. You can link more than one field from one table to another. You can also add the same table twice, and link it to another field. When you add the table again, Crystal will append a 1 to the name and it will be treated like another table. Here's an example...