Formuls: Concating Strings with parameter and report text fields

[makjoshi]

Hi All,
I'm facing a problem to show a parameter value combined with a two text fields.
e.g. Text1 {?Parameter} Text2
text1 = 'No.of' and text2 ='/week' and parameter value may be 'Days', Minute, Hrs. etc
These Text1 and Text2 i need to use in the formula so that string should lokk like 'no.of days/week' but it looks as
'No.of Days /week', as there are two textboxes and a parameter field.
Is there any property of a parameter filed where i resize the width of a parameter filed as per it's text.Is there any Autosize for a textbox/parameter field.
It's vey urgent for me to incorporate this in my reports.So kindly get back to me ASAP.
Thanks in Advance.
Mak...

 

[Katy44]

Have you tried putting the two strings and the parameter field all into one text box? This might be a good place to start.

 

[makjoshi]

Thanks Katty,
Basically what i need is to read values from Text1 and Text2 field. These values comes from xml file, and they are different for different languages, so is the width. That is why i have kept maximum width of textboxes to accomodate that word in all languages, but for english, the words are (e.g.Day) which is smaller in length compared the same word of Russian.So i need that textbox should be Autosize or CanGrow type.But 'Can grow' takes this to multiple line which is not accepted. I want single line only.
Suugest me a way out to it,
thanks for your prompt response.

-Mak

 

[Madawc]

You can adjust the font size of a field, using right-click and format field. Among other options, you can testlength({your.field}) to control this. I did this on a customer list, in my case modifying the font, using Ariel Narrow rather than Ariel for the longer names.

Madawc Williams (East Anglia, UK)

 

[lbass]

If the text fields are database fields, you could create a formula:

{table.text1}+" "+{?parameter}+{table.text2}

...without using text boxes at all. But perhaps I'm misunderstanding.

-LB

 

[makjoshi]

HI LB,
These are not database fields, but comes from XML file so it is difficult to read a value from them. Even i have tried to incorporate parameter field in XML file and manipulated with Text1 Field but it's not working.
Let me know if there are any workout.
Thanks,,,

-Mak