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.
vbnetcoderAsked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft 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
 
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
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.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.