Urgent -> Change the Allow Nulls caption +ssrs

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Urgent -> Change the Allow Nulls caption +ssrs

Author

Topic

aoriju
Posting Yak Master

156 Posts

Posted - 2009-01-01 : 05:45:07

Hello Experts

I am Working with SSRS(Sql Server Reporting Services).I have an Datetime parameter.And tick the Allow Null property.In report a checkbox comeup with side a caption like NULL.I want to change that caption with Developer likeness(Meaning full word).

Please Help Me(Its valuable for business).

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-01 : 13:02:33

change the caption where?
i think you can edit this by taking code behind of report.

aoriju
Posting Yak Master

156 Posts

Posted - 2009-01-02 : 00:05:23

This is the code of the that report parameter
<ReportParameter Name="adt_FromDate">
<DataType>DateTime</DataType>
<Nullable>true</Nullable>
<DefaultValue>
<Values>
<Value>=CDATE("4/1/" & Switch(Month(Now) <= 3,(Year(Now) - 1),Month(Now) > 3,Year(Now)))</Value>
</Values>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>From Date :</Prompt>
</ReportParameter>

i want to add here a caption

<Nullable>true</Nullable>

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 01:07:50

caption to what? you mean parameter caption?If yes, what you should be changing is prompt value in parameter propertis

aoriju
Posting Yak Master

156 Posts

Posted - 2009-01-02 : 01:14:41

Visakh.
if we are giving property of a parameter <Nullable>true</Nullable>.then a check box comes up with a caption Null.i want to change that caption as meaningful one.

Please give m a good reply...Its will valuable for business.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 01:27:22

but NULL value will always be shown as NULL in report. what do you mean by more meaningful caption. if your attempt is to set some other meaningful default value, then why not invlude it among parameter values in combo and set it as default value.

aoriju
Posting Yak Master

156 Posts

Posted - 2009-01-02 : 01:34:09

My/Your Qusstion is Clear

I am asking any methord for giving meaningfull caption on that place.Several times client asking what is it. I want to Change null caption into "Select This CheckBox FromDate Will Not Consider"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-02 : 01:47:24

quote:
Originally posted by aoriju

My/Your Qusstion is Clear

I am asking any methord for giving meaningfull caption on that place.Several times client asking what is it. I want to Change null caption into "Select This CheckBox FromDate Will Not Consider"

Ok. this is not something you can do easily in standard report viewer at least from designer window. However, as i said earlier, you can try altering xml behind.

aoriju
Posting Yak Master

156 Posts

Posted - 2009-01-02 : 01:53:55

Thats i know dear.
Need to alter it on Xml.But how to alter it .that is the Question.
<prompt> tag not support in that place.<Nullable>true</Nullable>.

filip1150
Starting Member

2 Posts

Posted - 2009-04-09 : 14:30:09

aoriju,

Did you find a solution for this?. I'm in the same boat

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources