I have this Report that uses a view i've created in SQL Server.
I can only run it in SQL Server for 1 ID at the time.
When I run Crystal - I can have 6 IDs and it is running in a seconds. What gives? It drives me crazy...ODBC connection.
Nothing fancy. Anyone ever experienced that?
Field CoName
0 A
0 B
1 C
2 D
3 E
If {?Field}<>0
then {t.Field}={?Field}
else
If {?Field}=0 then
true
I works well.
Now I need to find way to have user to choose not from 0,1,2,3 but Y and N
thanks
Hi!
I had probably said it wrong.
If{?Parm} = "Y" then // {?Parm} is numeric field so it is not ='Y' it is 1
It goes like this
If Y show all Numbers else If N show only Zero values
I have a numeric field.
I need to have it as a parameter.
If Y then show everything,
if N shoe only 0s.
I set it up as 1 as Y and 0 as N.
Now how do I show captions in Crystal so user will see Y and N and not numbers? Thanks
Please, help me to write following:
name contact id
AAA e 12
AAA b 12
NULL e 11
BBB b 11
So if contract is e then name.
If contract is e and name is null then name then contract b and name.
Thanks.
P.S. I always want cotract e but if not avail then b and...
If Not(IsNull({t.value})) then
{t.value}
else
0
gives an error asking for a boolean and it doesn't have a parameter in it. I need to enter parameter and get everything greater then parameter BUT field is NULL at this moment.
{t.value} > {?Value} is cool but if field is NULL?
If {?Value}...
My Param is {?Value}
Field is {t.value} and it is NULL.
task is to put a filter on a field and get all values greater then a filter - how do I do that?
If Not IsNull {t.value} then {t.value}={?Value}
doesn't work. Thanks
One more here.
Both of my parameters should be excepting multiply values.
I use
join({?CodeID},",")
for the string
but what should I use for the Numeric?
Thank you
I am not sure we are there yet.
Turkbear,
{?GroupOne}, {?GroupThree} and {?GroupFour} are parameters.
It is purely depends on CODETYPE=1, 3 or 4.
So {?GroupOne} works with CODETYPE=1 and so forth...
I have to tell that there are only 3 CODETYPEs 1,3,4 and several CODEIDs (can grow to whole...
I see, I will try different approach here.
Here is data as we saw it before
"GroupThree" is
CODEID CODETYPE
A 3
B 3
C 3
"GroupOne" is
CODEID CODETYPE
A 1
B 1
C 1
"GroupFour" is
CODEID CODETYPE
A 4
B 4
User should be able to select...
What I meant by
CODETYPE=3 group's CODEIDs should not be mixed with CODETYPE=1 and CODETYPE=4 CODEIDs.
is that :
As and bs and Cs from group CODEID and CODETYPE=3 can not be mixed up with
As and bs and Cs from group CODEID and CODETYPE=1 can not be mixed up with
As and bs and Cs from group...
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.