Array Parameter Problem.

Hi All.

1- I have a report to show all the Sales Product and Return Product  grouped with WSNumber , And I define Two Parameter as  shown below :
   A -  Transaction Type    ( String Parameter and have Three Default Value  ( All - Sales - Return )
   B -  WS Number  ( it's String Parameter and have default value ( ALL ) , but the data in DB for this Field is Number Format )

First Q :  please let me know how can i retrive the default value of WSNumber automatically based on Selection in TransactionType
 ( somthing like this :  I choose Sales and WSNumber Defult value show me the ComboBox With  All-1-2-3-7  , and if i choose Return  it shows  All-4-5-6-8-9 )

Second Q : And I want to choose Multiple WsNumber Based On Transaction . for that i define the WSNumber as  (Allow Multiple Value ) but when i use this Formulla to Retrive All or somthing i select in WS i have an Erorr :

The Formulla i Used to Accept Letter -All-  For my Selection  :


if {?Transaction Type} = "All"   AND  {?WS Number} = "All" Then  
      TRUE
else
if {?Transaction Type} = "All"   AND  {?WS Number}  <> "All" Then

   {Deposit.DepositNumber} = ToNumber({?WS Number})
else
if {?Transaction Type} <> "All"   AND  {?WS Number}  = "All" Then

   ({Deposit.TransactionType} = {?Transaction Type})
else
if {?Transaction Type} <> "All"   AND  {?WS Number}  <> "All" Then
   ({Deposit.TransactionType} = {?Transaction Type})
    AND
{Deposit.DepositNumber} = ToNumber({?WS Number})


I have a deadline to create this report ( i must prepare it for Monday Morning ....)

Please Help Me ... ( Sorry For Low Point I gave for this Q , I dont have any kind of Credit Card ( they are not allowed in My Country ) And I cant buy forther Points
 (I Collect this by answring  the other Q)  ... Please Forgive My Bad English, Low Point , High Emergency , and maybe dificult Soloution.

Mohammad Pourebtehaj
LVL 2
gad_flyAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gad_flyAuthor Commented:

I forgot To Say the Error is giving to me in Crystal Reports is

This Array Must Be Subscripted ...

I know i must define the WSnumber in my formulla as Array but i dont Know How and How can i check the user for  : ( if he select ALL and some number the report create with ALL Records and ignore other selection .  

Thanks
0
mlmccCommented:
Q1 - What version of Crystal.  YOu need CR XI to have dynamic parameters like you desire.  You could do it in an application by retrieving the values from the database and updating it when the user changes the selection of transaction type.

Q2 - I assume you only get the error if you pass in multiple values.
The problem is your  ToNumber({WS Number}) can't work on an array.  Try it this way

ToText({Deposit.DepositNumber},0) in {?WS Number}

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
gad_flyAuthor Commented:
Hi mlmcc :))

First of all thanks for your  help :)

I have Visual Studio Team  Edition  version 8.0.50727.42 (RTM.050727.4200) and My Crystal report is included in it  ( Crystal Reports for Visual Studio 2005  AAC60-G0CSA4B-V7000AY  ) is this CR XI ?!

for the second part  I'll go and change it ..  perhaps it's 99% right ! ( like the other suggestion  you gave to me . )

Thanks

Mohammad Pourebtehaj
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

mlmccCommented:
>>is this CR XI ?!
As far as I know it is based on CR 10.

mlmcc
0
gad_flyAuthor Commented:
Oh no ............

is there any chance to do this Wihout the XI ?

 
0
gad_flyAuthor Commented:
For the second part , i have the WSNumber in number format ... you say i change it to :" ToText({Deposit.DepositNumber},0) in {?WS Number}"  

is it ok ?
0
mlmccCommented:
Only through the application by opening an recordset in code and presenting the list.

mlmcc
0
gad_flyAuthor Commented:
Hi again :)

I buy XI today , but now ,after install this i cant use XI from Visual Studio , it's been using 10 Version !!!

now i have another problem !! how can use the XI looks and programing inside my .Net and when it's solved :) how can i do your Suggestion aboat dynamic parameters ....


Thank you very much .

Mohammad Pourebtehaj
0
mlmccCommented:
What Visual Studio?

mlmcc
0
gad_flyAuthor Commented:

hi


Microsoft Visual Studio 2005 and i am using C# for my programing  and SQL 2000 for DB source .

thanks

Mohammad Pourebtehaj
0
mlmccCommented:
You need to download release 2 of CR XI.  I searched the Crystal site and can't find it.  Is the version you bought Release 2?

If not call Crystal.

mlmcc
0
gad_flyAuthor Commented:
i bought this  : Crystal Reports 11.0.0.895  
0
mlmccCommented:
I don't know if that is release 2 or not.  I just know that the Crystal XI first released wasn't compatible with VS 2005 and they issued a Release 2.  It used to be available on the web site but I couldn't find it or a reference to it.

mlmcc
0
mlmccCommented:
0
gad_flyAuthor Commented:
thanks for your advice :)

but can you tel me about :  " how can i do your Suggestion aboat dynamic parameters  "

thanks for your generous help .

Mohammad Pourebtehaj.

P.S : if you have plan to visit my country i am very glad to show you around . :)
0
mlmccCommented:
I don't have .Net but the basic idea would be

Add an option box (i think that is the right one) to the form that calls the report
Populate it from the database field you are trying to use
Have the user select one them pass the selection to the report

mlmcc
0
mlmccCommented:
Look at this code.  It is in Delphi but it may be useful

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21804955.html

mlmcc
0
gad_flyAuthor Commented:
Hi again.

i download the SP1 and install it but it dosn't work with .net i search everywhere , but i cant find it ...................

by the way, thanks for your all care.

Mohammad Pourebtehaj
0
mlmccCommented:
Glad i could help

mlmcc
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.