I need to add letters to a field based on a conditional formula is this possible? This is what I have please tell me where I am going wrong.
IF {Command.DOC_CATEGORY}="SO" THEN 'S{Command.DOC_CATEGORY}'
ELSE IF {Command.DOC_CATEGORY} = "RF" THEN 'R{Command.DOC_CATEGORY}'
I want the field to...
Thanks anyway for your help, I figured it out on the date I can just put No lower value and todays date. This should all be enough for me to play with. Thank you>
Up and Coming Technical Guy
Thanks Cospringsguy and Lbass that worked for my number parameter, but what would be the default for a parameter that searches by date or a non numeric string.
I tried the same thing on a date parameter and it would take the 0.
Up and Coming Technical Guy
My question is how do we Bypass parameters. I have a report that I added a parameter to search for document numbers. The user can search for one document or a range of numbers.
What I don't know is how to bypass the parameter and just let the whole document flow. It won't let you hit O.K. on the...
2328, Click on the Top of this page where it says Forum. Then there is a start new Thread Link at the top of all the Topics. Don't worry I used to be in your shoes!!
Up and Coming Technical Guy
Thanks Lbass, but I was able to do a count on :
if {STOCKEXT.FIELD9} = "Y" then 1 else 0
Then I will sum this up. I'll not your reference in the future. Thanks.
Up and Coming Technical Guy
I just looked at my Third party software called Datalink, it has a autorefresh option. read up on it at www.MilletSoftware.com
Up and Coming Technical Guy
Amazing, That worked , I have a long way to go on learning these parameters. Know of any tutorials or references on parameters.
Up and Coming Technical Guy
I am creating a formula to count a field that has only Y,N, or Blank in the field. I am using fomula :
COUNT({STOCKEXT.FIELD9})="Y"
to count all of the Y's but it is giving me the error message
"A number is required here"
Up and Coming Technical Guy
eNTER DATE IS A DATE TIME FIELD, I have format it to only show date on the report. But It pulls date and time through the table.
Up and Coming Technical Guy
Yes it is a date time field, I have set the parameter where it shows the calendar to choose the dates you want. When i select a date range the reports stays the same it doesn't reduce to only the range. The parameter is set as follows:
Name: Month Date Range
Type: Date
List of Values : static...
Sorry Crystal XI,
I HAVE ENTERED
{TKT_HDR.ENTER_DATE} in [?StartDate to ?EndDate]
and it gave me an error message
A number,currency amount, boolean, date,time-date, or string is expected here.
I have all of the records pulling for the last two years, IU want the users to be able to selct...
Sorry for the lack of Knowledge, this is my first time using a parameter field. I have set it up to choose a date range but I don't know where to place it so it works.
Up and Coming Technical Guy
Sorry let me re-phrase that , not the field but the data in the field. If the price was $10.00 then change to $20.00 or if an order had a due date of 10/1/08 and changed to 1/1/08,I want to have these detail lines show only.
Up and Coming Technical Guy
Is there any way to create an alert or highlight formula that would capture data change. I have a report that covers all our orders over the last few years. I need to know if I can have something that would highlight any change when i update. I also on want only the changes to show suppressing...
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.