Hiding/unhiding a report field by mouse click

How would you go about making one of your fields hidden until you click on it?right click the textbox and go to properties, go to the visibility tab. Check hidden and check "can be toggled by another item". The Item selected will have a + or - on it, or you can set an expression to control visibility otherwise. If this is not what you're looking for, please provide more information about the report, mainly type of report (matrix, tabular).|||Its a matrix report, and the specific field is a picture. What I want to do is have the report run without displaying the picture, but if you click on the box the picture will then display. So I want it to default as hidden and then have some sort of button or check box to display the image.|||I have never used an image control but if there is a visiblity tab in the properties you could have it controlled by an arbitrary textbox placed perhaps in the corner of the matrix that says "Show Picture". When you set the visibility control property of the image to a textbox, the textbox will automatically show the plus or minus signs.

Hiding table columns creates solid black columns in PDF

Hello all,

I am having a slight problem when dynamically hiding columns in a data table.

When I use the set the "Hidden" property to true, I seem to end up with a solid black column on the far right of the report... but only when generating the report as a PDF.

I've searched the internet quite a bit trying to track down the issue, but I can't seem to find anything.

Has anyone encountered this problem before? Suggestions?

Thanks,

David

check the background color

it should be transperant

|||

All the cells and columns are set to have a background of transparent

no luck :(

|||Anyone else have any thoughts on this problem?|||

ur best bet would be to hide table row itself rather than just hiding a column and u can give a condition instead of just setting the hidden column to true.

Hiding Reports in Sharepoint Integration Mode

I'm setting the Hidden property to True and then creating the report using the CreateReport method from the ReportingService2006 class. When I check the reportserver database Hidden is set to true. But when I call the GetProperties method it shows Hidden as being false. And in the document library the reports are visable.

I tried calling the SetProperties method after I created the report but it still didn't work.

Here's how I create the report.

Dim props(0) As ReportServer.Property

Dim SetProp As New ReportServer.Property

SetProp.Name = "Hidden"

SetProp.Value = "True"

props(0) = SetProp

rs.CreateReport(Path.GetFileName(fileName), Folder, True, bytes, props, warnings)

Any idea?

Thanks,

-Somsong

The Hidden property isn't respected by SharePoint document libraries. We would have had to make code changes in SharePoint itself in order to get document libraries to respect RS's Hidden property, and we didn't pursue that.|||

So we would have to set up a default view and set a filter on it so that certain items can be hidden right? I can create a column in the document library and call it hidden, if the value in here is 'Yes' I could hide it. Do you know if I can set this value when I use the CreateReport method from the Reporting Services 2006 Web Service by passing in properties? I'm guessing this won't work cause those properties are probably just for the Report Server Database. I would probably have to use the Sharepoint Object Model to edit that column value right?

Thanks,

-Somsong

Hiding column heading

I have a report that includes a group that I have hidden. the group becomes
visible using a toggle on a textbox in the group header. I would like to
place a column heading in the header row for the group detail. I want this
header to only appear when the detail is visible. I can use the visibility
property of a text box but if I do that then that affect any color or lines
on the group header row
SO
My question is : Is there a way to use the IIF function to evaluate whether
a particular textbox is visible?I don't think you can access the properties on the fly... At least I haven't
seen an exmple of how to do it ...
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Mardy" <Mardy@.discussions.microsoft.com> wrote in message
news:2424391D-05DD-46F7-A424-B1D965219647@.microsoft.com...
>I have a report that includes a group that I have hidden. the group becomes
> visible using a toggle on a textbox in the group header. I would like to
> place a column heading in the header row for the group detail. I want this
> header to only appear when the detail is visible. I can use the
> visibility
> property of a text box but if I do that then that affect any color or
> lines
> on the group header row
> SO
> My question is : Is there a way to use the IIF function to evaluate
> whether
> a particular textbox is visible?

Hiding a row in a table based on whether another row is hidden

Is it possible to determine whether or not another row in a table is visible?
The example is in a multiple detail row table, where I want to display a
'header' row (really just another detail row), if any of the other detail
rows in the 'section' are visible. Is there some syntax like
ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
visibility state of a row?
ThanksDid you find a solution on your problem? I have a simular problem.
"PD" wrote:
> Is it possible to determine whether or not another row in a table is visible?
> The example is in a multiple detail row table, where I want to display a
> 'header' row (really just another detail row), if any of the other detail
> rows in the 'section' are visible. Is there some syntax like
> ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
> visibility state of a row?
> Thanks|||I have the same problem. Is there any on
"aCa" wrote:
> Did you find a solution on your problem? I have a simular problem.
> "PD" wrote:
> > Is it possible to determine whether or not another row in a table is visible?
> > The example is in a multiple detail row table, where I want to display a
> > 'header' row (really just another detail row), if any of the other detail
> > rows in the 'section' are visible. Is there some syntax like
> > ReportItems!TableRow7.property("Hidden")=' that I could use to determine the
> > visibility state of a row?
> >
> > Thanks