[data_item] between TEXT line

[pooja]

we need to keep [data_item] between text lines. please advice any help.
say--

we have production report with 1-paragraph summary written on top where we used TEXT ITEM. now we need to put [data_item]
bettwen text.

how it s is possible..??

thank you in advance

[blom0344]

If your [data_item]  stores a string, you can easily define a new one that concatenates the fixed text with the [data_item]:

Code Select Expand


'The first part of the text '||[data_item]||' second part of the text'


[pooja]

you mean--
we need to do by creating new data item..????

actually what we are trying to achieve is--
say below ex is our text summary and this '<>' where we need to place our [data_item](calculated amount)

adsds adsdsd dfsafds kkdfkd fdlfkdlfka lfdlfkf <> skdjaskdjs jkdfjd
adskldjs  <>  sjksjksl jaskdjsd.

thank you in advance

[Gopinath]

why can't you split your text by having multiple text items and placing the data items inbetween.

Blom's suggestion is the Ideal way of doing this.

[kattaviz]

Hi Pooja,

If you are trying to display the total value, u can reference that value in another query and use "Singleton" to place the Data item between the text.

[pooja]

..SALUTE.....

read my mind....yea we have list report with [grand total] column which we need to display on summary.

would you please explore little more...we are using 8.4

thankx a lot in advance

[kattaviz]

Hi Pooja,

1. create a new query.
2. Drag the original query to the right side of newly created query.
3. Double click the new query. You can see the data items in the insertable objects pane.
4. Double cick the [grand total] to add to the new query.
5. Run the new query. You should see a signle value.
6. Use singleton object to place the [grand total] at the desired position.

HTH
Satish Kumar Katta