display Numbers in different tables

[Srik]

Hello.
I have requirement in which i have a category number and corresponding description.
The requirement is Ã, all Cat no. starting with 1xx need to display in one table , 2xx in other table Ã, and 3xx in other table and so on.

do any came accross this kind of report format .
I have attached the mock report for better understanding. and this report uses page break by Contract number.

Thanks,
Kanth

[ole115]

I think you should do 3 separate queries and apply 3 different filters. If the category number is an integer, you may need to convert it to character and compare the first character to 1, something like: substr(category number,1,1) = '1', etc for the other 2. I don't have much info, but I think that's how it would work. Then you create 3 tables and associate every table with a separate query.

[bdybldr]

kanth,
I don't see an attachment.  Can you repost it?