Search results for query: *

Yes, it was conditionally suppressed. Rather than research further, I've just put all subreports in Report Footer sections, and the paging is working fine. Thanks . . . Jane

Thanks, Jim. I had adapted your initial solution for a multi-section Detail. There are more fields than just address, though I could probably adapt the address solution you've given with a little thought. I'm using mixed formatting and indents, though, so I haven't gone that route yet...

Can you put monthly in one worksheet and yearly in a second worksheet? Then you can treat the data as two separate tables that are joined by CM# and CM#2, with an outer join so that all records for CM#2 are shown even if there is no corresponding record for CM#. Use Crystal's Visual Linking...

Now I'm at a loss. I have several sections in Details and want to keep them together for each record (sections are for address lines: Details a is name, Details b is address1, etc.). I've selected 'Keep Together' for Details in the Section Expert. This works great except for the second...

Thanks. What I ended up doing was checking 'Can Grow' for the text box and then entering a Maximum Number of Lines as '1'. For some reason, that worked, though unchecking the 'Can Grow' didn't work.

I am using a text field in my report that includes two data fields. I do not want the text to wrap; i.e. if the data fields have more characters than I've allowed for the text field, then the end characters should be cut off. I have unchecked 'Can Grow' for the text field. However, I am still...

Thank you, Jim - that did it.

Thanks all. The Keep Group Together option doesn't work for me, since I want the group detail to split on pages and columns as long as there is at least one record with the group header. Using this option gives me too much white space. I am trying variations of the Underlay Following...

I have page number on the Page Footer section of the main report. Interestingly, the page numbers appear on the last subreport which is in a Report Footer section, but not the first, which is in a Report Header section. Don't know if it is relevant, but I am using a formula for PageNumber...

I have a lot of group headers with no detail beneath them - the detail is appearing on the next column or the next page. If there is not room for any detail, I'd like the group header to be printed on the next column/page. Is there an easy way to keep the header with at least one detail record...

Exactly what I needed - thanks!

I have a report that is made up of several subreports (a dental provider listing by alpha, by location, and by specialty). Each subreport is several pages long. I'd like page numbering throughout the report, but can't seem to get it on the subreports. Any ideas?

Is there a way to apply multiple formats to a single field? Example: I am concatenating several data objects (first, middle, last names, prefix, suffix, etc.) through a formula so they all appear as one field on the report. I'd like to make part of the field bold (i.e. last name only). Is...

I am using shared variables to return a value from a subreport to a main vendor report. The main report uses a payment detail table with multiple records per vendor. The subreport uses a summary 1099 table with a single record per vendor. The main report displays one line per vendor (the...

I'm hoping this is a simple issue: I need to calculate totals of the fields that I'm using shared variables for. I'm told that shared variables must be executed while printing records, and then that I can't calculate totals of formulas that are executed while printing records. Is there a way...

I'm a newbie to Crystal and MAS90, but have done a lot of report writing and development in the past. Is it true that you can use only one left outer join with these programs per report? If so, how do you write decent reports with acceptable performance? Example: I need a report that shows...

Thanks for your replies. This issue is is not universal with all databases, but doesn't work for MAS90. I don't get an error message with multiple outer joins, but the generated SQL statement FROM section is incorrect, and I get database errors if I try to change the SQL directly (not due to...

I'm a newbie to Crystal and MAS90, but have done a lot of report writing and development in the past. Is it true that you can use only one left outer join with these programs per report? If so, how can you write decent reports? Example: I need a report that shows all vendors [vendor table]...