Text Box Header

[taylor_jesse]

Hi,

I have a text box as a header that displays the header on top of a straight table based on what the user selects.

For instance if the user selects a Team, the team name will appear.

I am trying to do the same thing for when a user selects a region as well as a group.

It works for when a user selects a region however when select a group, the two text boxes overlap.

Below are the expression for each text box

Expression for text box for Team header

=if(isnull(LocationDescription and Location_LocationCode),LocationDescription_LocationCode&' ' & group,' ')

Conditional expression to display the text box

=GetSelectedCount(TeamFilter)>0

Expression for text box for Region header

=region_name

Conditional expression to display the text box

=GetSelectedCount(region_name)>0 and (LocationDescription_LocationCode)<1

Expression for text box for group header

=group_name

Conditional expression to display the text box

=GetSelectedCount(group_name)>0

Attached is also how it looks when multiple is selected.

[vishsaggi]

Your image is not visible, can you re attach the image and also if possible share your qvw file where you have this issue?

[taylor_jesse]

How do I share part of the document?

[vishsaggi]

I cannot see that image. You can save your qvw file with a different name and in that new qvw file delete sheets which are not necessary and just keep the sheet which has those two text objects and attach the file using Advanced editor.

[taylor_jesse]

document don't seem to be loading when attached

[vishsaggi]

How big is your document? Are you getting any error?

[taylor_jesse]

Its pretty big and I get an error that its not able to load when I attached it. It doesn't load on my local machine

[vishsaggi]

So just load only that data required by those text objects or create a sample data and your expected output. It will take little time but worth creating some sample from your original qvw file.

[taylor_jesse]

Sounds good. I will do that and attach it