Passing Parameter to Sub Report

Question

0.00/5 (No votes)

See more:

Hello friends i have developed a crystal report with a sub report in it.
i want to pass parameters to the sub report by using vb syntax.
i am able to pass the parameter to main report but dont know how to use it for subreports.
can anyone tell me syntax in vb to pass parameters to sub report
please needed help.

Posted 26-Jun-13 21:46pm

sachin bhise

Add a Solution

2 solutions

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)

Aatif Ali from Bangalore · Answer 1 · 2013-06-28T03:33:00

Hi There

Thanks for your posting. Is Sequence is also a field inside your main dataset? if that is the case then you just need to map your sub report parameter @Sequence with your Sequence field of the main dataset

For more information please have a look

http://www.katieandemil.com/ssrs-create-subreport-with-parameter-example-tutorial-ssrs-2008-r2

http://msdn.microsoft.com/en-us/library/ms160348(v=sql.100).aspx

If you have any question please let me know.

Many Thanks

Aatif

Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

jenitshah · Answer 2 · 2013-06-28T23:40:00

-> Just Right Click on the Subreport and Choose "Change Subreport Links"

-> Select Your Parameter From "Available Fields"

-> Click ">"

-> Now Your Parameter is Added to Your Subreport.

-> If You wish to Select Subreport Data based on the value of Parameter :

-Check "Select data on the Subreport based on:"

-Choose the field based on Which You want to Filter Subreport Data.

-Hit OK.

Remember to Put Your Subreport in Header/Footer (If possible) to avoid repeatation.

Passing Parameter to Sub Report

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0