How to pass the parameter value to sub report

Question

1.00/5 (2 votes)

See more:

Using vb.net i have created a report backend as sql server, and in my main report i pass three parameters (2 date and 1 category id) and in sub report i have two parameters(2 date).

while i run the project i get some bug like the following,

Additional information: Object reference not set to an instance of an object.

What I have tried:

VB

''Main report parameters
Dim cryRpt As New ReportDocument
cryRpt.Load("report path")


            cryRpt.SetParameterValue("Exid", PrintId)
            cryRpt.SetParameterValue("Frm", FDate)
            cryRpt.SetParameterValue("To", TDate)

''Sub report parameters
            Dim mySubReport As ReportDocument
            mySubReport = cryRpt.OpenSubreport("report path")

            mySubReport.SetParameterValue("Frm", FDate)
            mySubReport.SetParameterValue("To", TDate)

Posted 10-Apr-17 4:26am

jmavrix

Updated 10-Apr-17 4:28am

CHill60

v2

Add a Solution

Comments

CHill60 10-Apr-17 10:29am

Debug your code. Determine if cryRpt is Nothing. If so then your report path is incorrect. If it is not nothing then check the value of mySubReport. If that is nothing then that "report path" is invalid.

jmavrix 10-Apr-17 10:39am

Both the report are in the valid path, i am able to preview the report from vs2015.
but while i run the project i get error.is it mandatory to pass the same number of parameters in main report to sub report

CHill60 10-Apr-17 10:43am

That is not the error you reported in your question!

jmavrix 10-Apr-17 10:55am

error is the same , these are the thing which i have tried

CHill60 10-Apr-17 11:05am

I've realised that was a question not an error message. I don't know how many parameters your reports need - I can't see them.
On exactly which line of code is this exception thrown?

jmavrix 12-Apr-17 2:59am

On this line mySubReport.SetParameterValue("Frm", FDate)
i get the following error
An unhandled exception of type 'System.NullReferenceException' occurred in SmartOfficeV1.1.exe

Additional information: Object reference not set to an instance of an object.

CHill60 12-Apr-17 4:54am

You need to debug and see what value mSubReport has at that point. If it is Nothing then the "report path" is incorrect when trying to open the subreport. If it is not nothing, then FDate is Nothing - you will need to work out why.

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)