hello ,i hv a problem while doing print session , i hv done a report on which i need a multiple phone numbers against one field(table.field).the table contain 10 values for that phone number field so how to show those 10 phone numbers in my report..

thank you...

In fact it is very easy If you know programming logic. I suggest you
on report main session script find values according to your table field and
for each selection sent it to report.
For example :

select table.pnumber
from table
where table.id = :table.field
selectdo
rprt_send() | sending each phone number to report
endselect


On report side add table.pnumber field into reports input field. Sort your report according to table.field (1) table.pnumber(2).

This is only idea for your case. You should some arranement on report side.
I think that you can handle it .


That'all.

thanks 4 ur reply......
but this u hv told me against single value.........
if i hv multiple value on a same field n i hv to show thm all.......

why dont u use arrays.

This is you want. It prints multi values according to one table field. If there are multi table fields it could also print it by using the script. What's problem ?

G.Luck !

Do you mean that one long string field contains several phone numbers? Like "020/63.59.69 050/59.58.58 070/58.48.70"? If so (although I find it a strange way of working) you should have a seperator between each number - for instance "," or ";" or "|" and then you define an array of 5 elements (or alternatively 5 single fields), and use string.scan() to fill the fields.

Code example:
string tel.str(512)
domain tcmcs.str20 telp(5)
ret = set.mem(telp, "")
tel.str = "020/63.59.69;050/59.58.58;070/58.48.70"
retval = string.scan(tel.str, "telp(1,1)|telp2(1,2)|telp(1,3)|telp(1,4)|telp(1,5)")
(retval will contain 3)
and on the report layout you place the fields telp(1,1) -> telp(1,5)

Regards,
Eli Nager

hello,

i am not able to print multiple values of one column of a table in report
e.g 5 phone no r there against one supplier

i am getting only 1 ph no printed
i have concated all ph no in string and passed that value to report variabl
but nt able to get correct value
if any body have coded this plzz mail me immediately
plz send me to my mail
haraprasad.patra@yahoo.co.in

hprhpr,

I have merged your post with this thread since you asked here the same question.

Can you please post your report code? Also what is the (phone) variable type?

- George

Check the string length / domain in input variables or program declaration . It should have proper length in each places .

hello all,how to declare email id and phone number while inserting table field in table creation,similar to enumerate has tcyesno,just like that,is there any domain for mailid andd phone number or i need to create a new domain for it ???,please help,waiting for reply..... urgent

The filter column may help. See screenshot.

In 4c4 the mail id was tcinfo which was like a string of 50. Maybe I do not understand the exact question.

hello all,how to declare email id and phone number while inserting table field in table creation,similar to enumerate has tcyesno,just like that,is there any domain for mailid andd phone number or i need to create a new domain for it ???,please help,waiting for reply..... urgent

hii,,

You are searching domain is exist in standard.
- Email domain is "tcmail"
- Telephone domain is "tctelp"

Hope this will helpful.



Regards,
DDPatel

thank you for your reply sir,but even i entered above 10 numbers it accepts it never giving even a warning message and also mail id also not giving any intimation even i am not entering @ ,gmail ,.in sir,but i need a domains ,which should matches the constrains sir, thank you ....... did you find anything other than this two.

I see what you are looking for. But that's not how domain works. Domain just let you set properties like data type(string/int/double/enum), length, supported/unsopported characters etc Domain's do not handle complex validations like email address validations,phone number validations. You will need to write your custom code to do that.