Hi ,
I have to develop a report in BOXIR3
My requirment is like this
I have a condition prompt where a state will be selected
In the report window i have to display all the city’s for the state selected in a single cell seperated by " , "
Note: I tried this formula =[city] & " ,"
But i am geting an error (WIS 10018)
kindly help me out on this
Thanks in Advance
casrs (BOB member since 2010-10-01)
The only way I have ever found of doing it is to create a function. I remember doing this a long time ago.
see the UDF section in this link:
jonathanstokes (BOB member since 2004-09-17)
Hi Nithin
Thanks for your solution but still i amfacing a problem with the last formula
Code’s
This is the formula i created using the document attached in your link
=If (IsNull(Previous([c]));Substr([c];1;(Length([c])-3));
(Substr([c];1;(Pos([c];Previous([c]))-4))))
Kindly help me out
casrs (BOB member since 2010-10-01)
Can you post the error that you are getting.
BTW its Nitin not Nithin. 
nitin_gons 
(BOB member since 2009-05-26)
Try this…Make the object as measure then use in the report.
amitrathi1234 (BOB member since 2007-10-15)
i had made the objects as measure object
casrs (BOB member since 2010-10-01)
(BOB member since 2009-05-26)