I am trying to make my cross tab show the lines even if the columns are empty;
The cross tab model is the following:

I’ll like to display a text in the report’s footer if a line item meets a specific condition, if it does not then the footer’s text should suppress. I have it working if there’s just one line item, however, if there are two or more with meeting a “true” condition and a “false” then the text still suppresses. If I have 4 line items and just one meets the condition then the report’s text should display. I created a header variable and a detail line’s variable, on the footer I’m testing if the variable = true, however, if three of the line items = true but just one = false the text suppresses.

I am working on a crystal report which I need to spell out the amount in Spanish. Was trying to get help from chatGPT but are not able to figure out how to fix the formula. Can someone give me some advise?

I need to find the last appointment date per person that is prior to their most recent appointment date.

I have to print a receipt in which every odd page has billing info in Detail section, after that payment detail in group footer section. Now I want to print return policy on every even number page.
Please suggest.

I upgraded SAP Crystal Reports for Visual Studio to the latest 2022 version.
HTML Report viewer from .NET Database is SQL Server.

Odd form puzzle.

I have RAS setting up and create java web servlet running.

We have to print company’s contract terms (common 2 pages) on every purchase requisition. We have to print it in report footer. Have made 2 separate subreports. In it even if I insert the pdf of contract terms and align all details it prints first page of contract properly. On next page; lower half page of contract’s first page is again printed and half page is left blank. This isn’t needed. Same happens for 2nd page of contract. Means on last page the lower half of terms contract 2nd page is again printed. How can I stop this overflow. Even though full page seems intact (of page 1 and 2); still lower half page of both; overflows to next page. Matter is in pdf. So instead of 2 pages 4 pages are used.

In Crystal Reports I have a Parameter field for the user to enter the issued date (IssuedDate?) I’d like to create a formula field to add 2 years to this date as an expiration date.