• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 897
  • Last Modified:

ssrs make detail row appear as hidden on a report

Is it possible to make a detail row in SSRS appear as it is hidden even though in reality it is not?

I have some custom code that needs to be called for each detail row, and it ONLY gets called when the row is NOt hidden

But, I only want what is in the total rows for the group to show up on the report so I want the detail to appear hidden even though
it is not.
0
vbnetcoder
Asked:
vbnetcoder
  • 6
  • 2
1 Solution
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Click on the row, then right-click:Row Visibility on the grey box to the left.
In the Row Visibility dialog that appears, select Hide, and hit the Ok button.
0
 
vbnetcoderAuthor Commented:
That is the problem .... when i hide it that way my custom code function does not get call for whatever reason.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
If the detail row will always be hidden, and you don't want to actually hide it, setting the height of all controls to zero, then set the row height to zero may be a good workaround.

>when i hide it that way my custom code function does not get call for whatever reason.
Copy-paste this custom code function + it's location/event into this question.
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
vbnetcoderAuthor Commented:
Basicly, I am doing this at every detail level in a text box.

Perhaps, there is a better way of doing that....

=Code.Caclulatepayments (fields1.value, fields2.value etc.)
0
 
vbnetcoderAuthor Commented:
it doesn't let me set the height of the textbox to 0..
0
 
vbnetcoderAuthor Commented:
i meant "row heightt"
0
 
vbnetcoderAuthor Commented:
I am running the code from a detail line. Do I really need to be doing this?  Is there another way I could run the coder per each value in the dataset without putting it in the detail line?
0
 
vbnetcoderAuthor Commented:
ty
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now