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...
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.