Tuesday, March 27, 2012

getting textbox to show all values

Is there a way in rs to have a textbox more than the first value when it is dragged on the rs form when creating a report? currently when I drag a text box on the rs form, it only shows the first record on a page/form. There are twenty records on the table where the first value came from. How can I make so that twenty text boxes representing twenty records appear on twenty different pages. In other words, I am trying to build a report with a non - tabular structure that can repeat on different pages.

Drag a list from the toolbox to your report. Place that textbox inside that list. Right click on the List and go to Properties and select the dataset from the list for "Data set name" field.

If your field name is Field1, use this expression in the textbox =Fields!Field1.Value

Then right click on your list and go to Properties and check the box against "Insert a page break after this list"

Shyam

|||Thanks Shyam. worked fantastic! Just what I was looking for.|||

Can you please mark my post as answer?

|||

Hi Shyam!!

I am trying to do something similar but i dont get it: i would like to show a list of computers in a textbox but i have each computer in a different row of the dataset... if i put a list, i have each computer in a different textbox and that is not what i am looking for...

Can u help me? Thanx in advance!!!

Sergi

No comments:

Post a Comment