Hi and help - I need to forecast revenue across calendar months based on a projects $ value (number field) and start and end dates (date/time fields). Some projects may be limited to a few months; others to several. I've checked the FAQ on working with rolling dates, but am not clear on how...
I wish to use the following formula in a subreport:
If {Opportunity_User_Field_Data.char_value} = "0" then "No" else
if {Opportunity_User_Field_Data.char_value} = "1" then "Yes"
However, when I try to save this formula in the subreport, I am getting the...
Thanks for responding so quickly. I am using Word 2000. I tried resetting the page size to landscape / legal, but it is still dropping the text data. I am stumped!
Hi - I'm using CR 8.0. When I export the report to Word, data that came from a variable length text field is dropped from the report. Exporting to Excel doesn't have the same problem. Any suggestions are welcome.
Hi - I am looking for how to export to CSV using the Print > export function in Crystal, which creates nothing except a file with the run date repeated for multiple. Did you find that you needed to use VB to export report data to CSV?
Hi - I must be doing something wrong - I tried both solutions (grouping by project id, then date & suppressing) and suppressing using the formula. I am still getting only the single record for the project with the most current change date. I'm selecting the Suppress (No Drill Down) from the...
Thanks for responding so quickly. I tried using the solution you proposed and ended up with only the last record in the report. In doing so, however, I checked the Crystal Help for OnLastRecord and found the section on PrintState Functions. Is there a way to use Previous or PreviousFld to...
I need to connect two tables and return a single value for each project. However, the tables have a one-to-many relationship.
The first table has a single record for each project.
The second table is a status history table and contains multiple records for any single project. This table...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.