Thanks for the info everyone. Thanks to lbass's answer, it works. I appologize for taking so long to get back with you, but I was having a lot of issues connecting to tek-tips for some reason. But thanks for everything though!!!
Thank you for the help on the "F"'s. Okay, here's a shot at the technical info:
Crystal Reports 9
ODBC Connectivity into a Progress Database
The following is actual sample data yanked out of our database, minus many fields as there are on average 30-40 fields/table:
Segment Table:
Segment-ID...
I'm currently trying to design a report for our estimating package at work. We're almost there, but I'm running into 1 major problem. Our estimating system is setup in 3 "tiers" to speak of. Tier/level 1 is the overall estimate. Each estimate contains components, and each component contains...
I have a field where I want to display a series of numbers in a formula. The numbers can range with any number of decimal places, usually no more than 7 but they can be whole numbers as well. Whenever I use them in a formula, I convert them to strings for concatination purposes, however they...
LBass,
Thanks for the response again.....I tried it and it worked!!! Woo Hoo!!!! I'm very new to Crystal, although I'm experienced with formulas, believe it or not...I believe I understand how it works, but thanks again....I'm familiar with VBA and Excel/Access formulas, but I'm still trying...
LBass,
Thanks for the response. What I'm wanting to do is do a hide/show a group footer based on a lookup of a free-field-char field where sequence = 2.
Our system has a goofy way of doing free fields. When you create free fields (we currently have 7), instead of setting up different fields...
This will be my final post unless I get the answer :-) When I check my formula
IF {FreeField.Sequence} = 2 Then {FreeField.Free-Field-Char} Else "No"
there are multiple sequence numbers per record. When I check it in my header, it appears it's checking squence number 2, however when...
This should be my final reply unless I get it working....for some reason the expression I use to calculate @EstOptions is an if statement which evaluates to true when ran in the header and false if I run it in the footer....is there any reason for this???
Here's the formula:
IF {Sequence} = 2...
I think I'm starting to answer my own problem....lol, anyways, if I show the variable in any of the group headers, it displays "Yes" and will work with any header, however when I try to display it in any footer is shows up blank and doesn't hide the row. Is there any type of layering of a...
Another thing I found out is that if I use the same statement to hide one of the headers it works fine. Any help would still be greatly appreciated.
Thanks in advance!!
We have just upgraded from Crystal Reports 8.5 to CR 9. I had a report that worked great in CR 8.5, however when I save it in 9, everything seems to work except for the suppress section I had setup. I have a formula setup to determine if the section should be suppressed and it is...
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.