How do I pass list of ids in array from VB form to crystal report

Question

0.00/5 (No votes)

See more:

i need to pass many of ids type integer selected by user and include it as array in selection formula by sql query to get data from sql server to crystal report

it show me an error msg
when try to show crystal report
it say ...
the ) is missing.

when i copy the code in sql sever qury its work..

What I have tried:

VB

Dim ListOfSortedID As New List(Of Integer)
 Dim IDs As String = Nothing

 IDs = String.Join(",", ListOfSortedID)

        Where4Crystal ="{DutyView.EmpAutoID} in (" & IDs & ")"

Posted 22-Aug-19 14:08pm

Member 11398913

Updated 22-Aug-19 20:04pm

Maciej Los

v2

Add a Solution

Comments

Maciej Los 23-Aug-19 1:56am

What's error message?

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Accepted Answer · 2019-08-22T20:04:00

Solution 1

Try this:

VB

Dim ListOfSortedID As New List(Of Integer)
'later
Dim IDs As String = String.Join(",", ListOfSortedID)
Where4Crystal = String.Format("{DutyView.EmpAutoID} in [{0}]", IDs)

You need the square brackets aroung IN operator.

Note: as far as i remember there's limitation to 32 arguments in IN operator.

Posted 22-Aug-19 20:04pm

Maciej Los

Updated 22-Aug-19 20:05pm

v2

Comments

Member 11398913 23-Aug-19 8:01am

Still not work ? if there any other way , because ther are another paramaters for Where4Crystal string for query.

Maciej Los 23-Aug-19 8:08am

An how you use them? Like this:

Where4Crystal = String.Format("({DutyView.EmpAutoID} in [{0}]) AND ({TextField}='{1}')", IDs, "some text")

Member 11398913 23-Aug-19 18:38pm

thank alot for your support, i just change the ( IDs ) in code to [ IDs ] and it work now, i really apreciate your help.

Maciej Los 25-Aug-19 13:43pm

You're very welcome.