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
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.
kanth,
I don't see an attachment. Can you repost it?