Crystal Reports formula function. Displaying values from Detail section in Page Header. Is Shared variable preferred vs some other formula?
What would be the best way to display a value while suppressing it in another section where it would normally show in Crystal Reports.
This image shows a column called contract amount. Currently showing a field called Approved Amount. $44,755. The value at the top....which is not correct. The value should be $505,000 which is displayed far below in the bottom of the column next to the Code on the right with "QU-00547". The record is in the details of another field.
Since I need to post the record $505,000 currently at the bottom of the details column (where the code next to it....starts with "QU") at the top. Where the $44,755 is currently.
Since I have to suppress records that start with "QU" in the details section but display them at the top of the report next to the Contract Amount.....which is what is approved. Is the best solution a shared variable or something else and is there a more efficient formula over another. Since this is going to be repeated over many many contracts.? Examples welcomed.
This image shows a column called contract amount. Currently showing a field called Approved Amount. $44,755. The value at the top....which is not correct. The value should be $505,000 which is displayed far below in the bottom of the column next to the Code on the right with "QU-00547". The record is in the details of another field.
Since I need to post the record $505,000 currently at the bottom of the details column (where the code next to it....starts with "QU") at the top. Where the $44,755 is currently.
Since I have to suppress records that start with "QU" in the details section but display them at the top of the report next to the Contract Amount.....which is what is approved. Is the best solution a shared variable or something else and is there a more efficient formula over another. Since this is going to be repeated over many many contracts.? Examples welcomed.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
What I cannot show on this forum is the massive text section in the Page Header at the top of the page where lots of text logo and embedded fields are. Unless you are talking about two Details sections where one is suppresses everything that is not "QU" verses the next detail section where everything that is "QU" is suppressed. I could not for NDA reasons show the whole page as there are actual company contracts shown.
It is an oracle database.
So you are saying add another table with the data from the Change Order data {changefield} like "QU" is that what you mean.
It is an oracle database.
So you are saying add another table with the data from the Change Order data {changefield} like "QU" is that what you mean.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I can post the report but would need to keep it private. I assume I can do that? Also can I protect it in a way so only you can look at it? mlmcc?
Not through the EE interface.
mlmcc
mlmcc
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Subreport was all I needed and to pass the records between reports with a shared variable.
ASKER