create a report (.rdlc) between 2 values

Question

0.00/5 (No votes)

See more:

Hi

Guys i am totally a noob in vb
i want to create a report from a column named "Serial" in my dataset named "Serials" which shows me the data between 2 values (that i have given to it)
so far i have created a form.vb as my report viewer
i have created a report.rdlc as my report and added dataset and a table which shows all of "Serial" column data on it

now i just want to filter the data that it shows so i can only see data between my given values
{my values are two string which are label text}
i am familiar with sql syntax and i can run a query to get my values but i can not pass in into the report ...
my databases are accdb
tnx and sorry for my bad english
[[ added : i have not written any code for this. i just ran some wizards and created a report but my sql syntax in query builder looks like this :

SQL

SELECT   Serial
FROM    Serials
WHERE    Serial   BETWEEN   A  AND  B

]]

Posted 24-Jun-13 5:32am

KababChi

Updated 24-Jun-13 9:05am

v2

Add a Solution

Comments

Nelek 24-Jun-13 11:40am

You should post a bit of the relevant code involved, so people can see what are you trying and correct you // point you in a better direction

If so, please use the "improve question" widget and add the needed info

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)

Mattintosh · Answer 1 · 2013-06-24T10:36:00

You'll need to add parameters to your report. Your query will look more like this:

SQL

SELECT Serial FROM Serials WHERE Serial BETWEEN @A AND @B

Once you do that, you should add corresponding @A and @B parameters to the report definition (.rdlc). In Visual Studio, you'll generally see these in the "Report Data" docked window that shows you all of the parameters, fields, data sources, datasets, and images used in the report. Usually, if you type anything that even looks like a parameter name (starts with "@") into the query box of the report's dataset, it will automatically add them to the report parameters.

When running the report, you can set these either by using the MS Report Viewer parameter entry panel that shows up when there are non-hidden parameters, or you can set them programmatically.