Can we include a variable field value on the table header.

Can we include a variable field value on the table header.

I am doing a page break on every date change and also set the property of he table header to repeat on each page. By doing this ,I am able to get the table header on each page even on page break. I want the changed date to be displayed on the every page break and in the table header.

Please help.

You should be able to do this without issue. Assuming you have a field which you are pulling from that shows the date, you could do something like this as an expression in the table header.

="Report Header - " & Fields!Date.Value

Hope this helps.

Can there be read only fields in a reporting services report?

Hey guys, I have a really dumb question. In the header of my report I am trying to put in a text box. This text box should look like this.

Legend Value 1

Value 2

Value 3

Here is my problem. Everytime I put in a carrige return it clears everything that I have in the box. What is going on? I then thought I should put in a table which would make my life easier but it does not allow me to put in a table in the header.. HELP

Open the expresion builder and simply enter the text as you want it to appear (without an equal sign) but with your returns. Even though it will look as if there is only one line, all three will be there when the report is renderred.

PS... only dumb question is the one you do not ask .

|||

Lonnie,

That was easy, thank you very much.. Trust me, I really didn't want to ask this question but nothing seemed like an obvious solution

|||you can also try this way. After you type the first line in the text box, press Shift + Enter. This should take you to the next line.|||

Hi,

I am trying to create a report using reporting services. This report will be displayed to the user in Excel. All this works fine.

Now the report generated in excel needs to have some fields locked down while others will remain edittable. Is this possible?

Please let me know asap...

Thanks in advance.

SR