Adding customs code to report (.rdlc)

Question

0.00/5 (No votes)

See more:

Hi,
I have been trying to add some custom code to my data report (.rdlc)
But I really donot know where to write the code. In vb6, I could do it behind the report, in code area but I donot know where is the code area in vb.net.

I want to:
1) I have added a text box to header of the report, I want to assign some value to it from my variable.

2)I want to make this control visible and invisible depending on user's choice.

4)In page footer, I want to display page nos.

Thanks a lot.
Furqan

Posted 6-Feb-11 4:27am

Furqan Sehgal

Add a Solution

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)

Sandeep Mewara · Answer 1 · 2011-02-06T04:44:00

Solution 1

This article of mine would help you in understanding and learning on how to use Custom code: Localization of SSRS Reports[^]

Now, pointwise:
1) I have added a text box to header of the report, I want to assign some value to it from my variable.
You can do it via custom code or using a hidden textbox in report body and referring that as a reportitem object in your header.

2)I want to make this control visible and invisible depending on user's choice.
In Visible property of control, you can set an expression. Use it and put whatever condition you like to.

4)In page footer, I want to display page nos.
It's an inbuilt feature. Just use the Report Pages. Place a textbox and check the option when you select expressions. You can find the pagination option in it.

Try!

Posted 6-Feb-11 4:44am

Sandeep Mewara

Comments

Espen Harlinn 6-Feb-11 10:51am

Excellent answer, nice tutorial too :)

Sandeep Mewara 6-Feb-11 10:58am

Thanks. :)

Furqan Sehgal 6-Feb-11 11:11am

Thanks a lot for your help.
Could you kindly elaborate the point2 a bit more?

Sandeep Mewara 6-Feb-11 11:15am

Just chect the Proprty grid of the control selected.
You will find a 'Visible' property in it. When you check the dropdown you can see, 'true','false','Expression'....
Select the third one and then based on any value you can set the visibility something like:
=iif(Fields!MyField.Value >12,true,false)

Furqan Sehgal 6-Feb-11 11:12am

Kindly give me code snippet for point 1
Thanks
Furqan

Sandeep Mewara 6-Feb-11 11:16am

Point 1: Article link given + Just google for "SSRS dataset value in header"

Furqan Sehgal 6-Feb-11 11:20am

=if(Fields!MyField.Value >12,true,false)
Error: refers to a field, fields can not be used in header and footer.

Sandeep Mewara 6-Feb-11 11:23am

Yes. Use a hidden textbox in report body and referring that as a reportitem object in your header.

Easiest would be just Google: "SSRS + Error: refers to a field, fields can not be used in header and footer"........ you will get lots of link on what I am saying about ReportItem and hidden textbox.

BTW, this means you are using SSRS2005 or so.

pavanee 25-Jun-12 9:19am

t