Hide document map label using expression

When a report item is hidden, its document map still shows. I would like to
access the hidden attribute of the item (in this case they can be table or
chart, but I believe the model to be the same). I can't seem to find the
object model how to access that attribute. I tried ReportItems!table1.hidden,
ReportItems!table1.visible, ReportItems!table1.Visibility and they all say
those attributes do not belong to the member. Anyone can point me to the doc?
I'll try to dig around and find the dll for reporting services and see if
object browser might help.
Thanks.Hide document map label using expression

Hide Data Region based on Parameters

I have a report with 3 data regions. Based upon one of the Report Parms, I
wish to hide one of the data regions. I used an expression on the
Visibility property of the table like this:
=IIf(Parameters!ReportLevel.Value = "Summary",true,false)
this works, except it still displays the page header and no print details
since the report is hidden. how do i get it to not display the page at all?Hi JrMcG,
Thank you for your posting!
I am not sure why you want to hide the Page Header. Since you only hide the
table, the Page header will not be hidden untill you use the same
expression on the Page Header visibility.
I recommend you post the RDL file here with your requirement. I would like
to help you. Thank you!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

hide column based on Parameter

Hello All,
I need an expression that hides a column based on the report parameter.
So, I add the following expression to column Visibility property:
=IIF(Parameters!active.Value = "Current", True, False)
Which gives me the following expression error:
"Input string was not in the correct format"
Any help is appreciated, I've already searched through previous newgroups
entries/bol with no luck.
Thanks in advance,
RobMy apologies.
Issue has been resolved.
Thanks, R
"Rob" wrote:
> Hello All,
> I need an expression that hides a column based on the report parameter.
> So, I add the following expression to column Visibility property:
> =IIF(Parameters!active.Value = "Current", True, False)
> Which gives me the following expression error:
> "Input string was not in the correct format"
> Any help is appreciated, I've already searched through previous newgroups
> entries/bol with no luck.
> Thanks in advance,
> Rob
>
>

Hide Calculated Column in Matrix Report And show only in Total

Hi All,

I need to show the Cumulative calculated value only in Total by year/Group. I could not use Visibility expression using

InScope, as it creates *Blank column. Please go thru details below.

Year

Month01 02 03 Total

Salary Salary Salary Salary Cumulative (Calc)

Employee01 20 5 25 25

Employee02 10 10 20 45

.....

Total

How can i achieve this?. Any suggestion on this would be appreciated.

Thanks,

You have a couple of options:

1 - Can you add Total Salary as part of your dataset and return that for each Employee/Year ?
If so, then you just include that field in your cumulative statement, so no need for the column

2 - You may be able to take both Tot Salary and Cumulative salary and place them in a single cell using the cells in cells technique. Select your cell and drop a Rectangle control into it. You’ll notice the background change from solid white to the transparent grid pattern. Next, select a textbox control and drop this into the rectangle. You have to get it perfect and sometimes it’s a bit annoying when you don’t land exactly on the control. Next, drop in another textbox so it rests directly beside your first one.
In one cell add your Sal Tot, and in the right textbox the Cumulative Salary. Set the Sal Tot textbox to hidden=True and as small width as possible. To the end user it will appear as though this is a single column.

Hidden Property - "Deserialization failed: is not a Valid Value" E

If I add an expression to the visibility property on a text box, table row,
etc.. and then remove that same expression, I get the following error message
in preview:
"deserialization failed: is not a valid value..."
I get an option to edit the XML code. When I look at the code, I find the
<Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
removing only one side of the Hidden tag when I delete the expression.
I used to be able to edit the code, but now I can't even edit the code to
take the remaining tag out. With this error my rdl file became, for all
intents and purposes, corrupt. Luckily I had posted it to a dev Report
Manager site earlier and was able to recover it.
Has anyone seen this?
Also, not being able to close VS2005 because of the the "Modal Dialog
Open..." box is killing me. Anyone have a solution to that yet besides
killing the devenv process?
Thanks in Advance,
bsod55I just had a similar error - I had to open the file and remove the Hidden
tags. In the IDE I right clicked on the file and selected Open from the menu
- this gave me the XML version and allowed me to remove the tags.
--
mal
"bsod55" wrote:
> If I add an expression to the visibility property on a text box, table row,
> etc.. and then remove that same expression, I get the following error message
> in preview:
> "deserialization failed: is not a valid value..."
> I get an option to edit the XML code. When I look at the code, I find the
> <Hidden /> tag. But get this, there is no </Hidden> tag. Apparently, VS is
> removing only one side of the Hidden tag when I delete the expression.
> I used to be able to edit the code, but now I can't even edit the code to
> take the remaining tag out. With this error my rdl file became, for all
> intents and purposes, corrupt. Luckily I had posted it to a dev Report
> Manager site earlier and was able to recover it.
> Has anyone seen this?
> Also, not being able to close VS2005 because of the the "Modal Dialog
> Open..." box is killing me. Anyone have a solution to that yet besides
> killing the devenv process?
> Thanks in Advance,
> bsod55

Hidden expression with dates?

Hi! How to write the syntax when you try to compare the dates. In this case I try to check if the date is empty(then it's 1/1/1900) then the field should be hidden. This is what I tried but didn't succeed:

=iif(Fields!ModifiedDate.Value="1/1/1900",true,false)

You can convert your string value ('1/1/1900') to a date with the CDate() function. With this you can compare the to value's with each other.|||

Jan Pieter Posthuma wrote:

You can convert your string value ('1/1/1900') to a date with the CDate() function. With this you can compare the to value's with each other.

Thanks for the post but unfortunately I didn't get it. The main problem is syntax - I don't know where to use Cdate() -function. I tried this:

=iif(Cdate(Fields!modifiedDate).Value) > "1/1/1900",false,true)

the compiler didn't like it :)

Can you give me an example?

|||

It just the otherway round: =iif(Fields!modifiedDate.Value=CDate("1/1/1900"), false, true)

Hidden Expression for Group Header

I am trying to hide a group header (table row) based on the value of that group, but have not been able to get it working.

Let's say I have 2 groups in my table:

Group 1: State

Group 2: City

I want to hide the group header (tablerow2) where State = "Unknown" but I want the Group 2 cities to still display - just w/o a header.

I tried putting the following expressions on the hidden property of tablerow2 with no luck:

First I tried referencing the field that it's grouped on:

=Iif((Fields!state.Value = "Unknown", true, false)

I also tried refereing the name of the group:

=Iif(("State_GRP" = "Unknown"), true, false)

In both cases, nothing gets hidden - all rows, including the group header that says "Unknown", are visible.

Any help would be greatly appreciated!

Kathleen

You are doing this correctly, and I was not able to reporduce the behavior--it works as you are thinking. I would make sure that the case of "Unknown" is consistent with the field value. I would do this in the expression (or change the query to do the trimming), so that case and extranious white space is not a factor.

=IIF(Fields!state.Value.Trim().ToLower()="unknown", true, false)

Ian

|||Thanks Ian - the trim/tolower seemed to resolve whatever issue I was having.

Hidden Expression enquiry

Help!!!
I have a group that is grouped on a category code...
Under that group is a details line that lists the transactions of that
grouped code
I then have a group footer that has a subtotal...
On my report I also have two parameters Date From and Date To...
In order to show only the category codes and details that are in the user
defined period I have entered the following into the hidden expression
dialog box on the three rows..
=iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
Now for my question:
On my report the details is correct... it shows only the details that fall
between the two data parameters. However, the categoryID sometimes will be
displayed and other times will not. I think it has something to do with the
grouping... but I cannot for the life of me solve it.
Can anyone assist?All,
I have got around the problem through the use of a subreport... but can
anyone explain why this happened?
"AshVsAOD" <.> wrote in message
news:u3tcSIbhEHA.1644@.tk2msftngp13.phx.gbl...
> Help!!!
> I have a group that is grouped on a category code...
> Under that group is a details line that lists the transactions of that
> grouped code
> I then have a group footer that has a subtotal...
> On my report I also have two parameters Date From and Date To...
> In order to show only the category codes and details that are in the user
> defined period I have entered the following into the hidden expression
> dialog box on the three rows..
> =iif(Fields!DATE.Value >= Parameters!Report_Parameter_FROM.Value AND
> Fields!DATE.Value <= Parameters!Report_Parameter_To.Value,False, True)
> Now for my question:
> On my report the details is correct... it shows only the details that fall
> between the two data parameters. However, the categoryID sometimes will
be
> displayed and other times will not. I think it has something to do with
the
> grouping... but I cannot for the life of me solve it.
>
> Can anyone assist?
>

Hidden columns exporting in CSV

I am writing a report to export columns dynamically. The column's Hidden
property is controlled by an expression (=Cbool(parameters.hidecol.value))
which works ok in Excel and PDF export. However, whenever I export in CSV,
this property is ignored and the column is never exported.
Is this a bug in reporting service or is it by design?
I have SQL reporting service 2005 with SP1 and all the hotfixes.Imran,
I got a reply from a MS contact on msdn. Here is his reply for anyone
else with the same problem...
John,
You can't conditionally hide and show data in data renderers (CSV,
XML). This is by design. If you have an expression in the Hidden field
and 'Auto' in DataOutput tab for text boxes in the column, your data
will not be rendered into CSV or XML.
You can set DataElementOutput to Output for textboxes in the cells and
in the header, and the coulmn will always be in the output file.
Thanks!
----
- DenisL (SQL RS Team)
Imran wrote:
> I am writing a report to export columns dynamically. The column's Hidden
> property is controlled by an expression (=Cbool(parameters.hidecol.value))
> which works ok in Excel and PDF export. However, whenever I export in CSV,
> this property is ignored and the column is never exported.
> Is this a bug in reporting service or is it by design?
> I have SQL reporting service 2005 with SP1 and all the hotfixes.|||Actually I was expecting a solution rather than a refresher on "status quo"
from Microsoft. Ofcourse I am aware of this issue and there are several
codable workaround for this... Was curious if someone had already done this
or if another hotfix is on its way to resolve this.
Imran
"johnburns007@.gmail.com" wrote:
> Imran,
> I got a reply from a MS contact on msdn. Here is his reply for anyone
> else with the same problem...
> John,
> You can't conditionally hide and show data in data renderers (CSV,
> XML). This is by design. If you have an expression in the Hidden field
> and 'Auto' in DataOutput tab for text boxes in the column, your data
> will not be rendered into CSV or XML.
> You can set DataElementOutput to Output for textboxes in the cells and
> in the header, and the coulmn will always be in the output file.
> Thanks!
>
> ----
> - DenisL (SQL RS Team)
>
> Imran wrote:
> > I am writing a report to export columns dynamically. The column's Hidden
> > property is controlled by an expression (=Cbool(parameters.hidecol.value))
> > which works ok in Excel and PDF export. However, whenever I export in CSV,
> > this property is ignored and the column is never exported.
> >
> > Is this a bug in reporting service or is it by design?
> >
> > I have SQL reporting service 2005 with SP1 and all the hotfixes.
>