Amnat--
Sorry, I don't understand what the current problem is, and can't help you with the SQL without knowledge of the structure of your data.



>>>I have some reports e.g. Item List Report etc. which print out the detail more than 1 line. My detail in report look like as belows:
>>>
>>>Desc uom ucost
>>>--------------------
>>>desc1 xxxx xxxx
>>>desc2
>>>desc3
>>>
>>>Some items have only desc1 or desc2 ... or all.
>>>I already defined "Remove Line If Blank" for desc2 and desc3.
>>>It seems like correct, but Vfp didn't print the last two lines of each page. My report should be printed as 15 detail lines per page, but it printed only 13 lines per page. How should I do ?
>>>Hope that someone understand my question.
>>>
>>>Thanks in advance
>>>amnatn
>>
>>Amnat--
>>This has happened to me, too. The report probably thinks you're out of space on the current page. Try changing the size of the detail band. Double click on the detail bar to see if it has been set to "constant height". You can try to put the three description lines in one "stretchable" field with the expression:
>>
>>desc1+iif(empty(desc2),'',chr(13))+desc2+iif(empty(desc3),'',chr(13))+desc3
>>
>>Then make the field box only one line long and mark it "stretch with overflow".
>>
>>You may have to experiment with a combination of approaches.
>>
>>Good luck.
>Thanks for your reply, it's ok !
>But I have some problem again, my user want to add lines between each desc1-3 too. Let's say that this report looks like excel spreadsheet:
>
>| Desc | uom | cost
>|------+------+-------------------------------
>|xxxxx | xxx | xxx <-- Desc1
>|------+------------------------------------ Line1
>|xxxxx | <<--- Print Desc2 if not blank
>|------+------------------------------------ Line2 :Print if Desc isn't blank
>|xxxxx | <<--- Print Desc3 if not blank
>|------+------------------------------------ Line3 :Print if Desc3 isn't blank
>
>I cannot use 'strech overflow' for desc field. Because items that have more than 1 description (desc) will not print the line between them. These lines in report should be printed as 15 lines per page too.
>I try to use SQL command to create temporary table but I don't know how to write it in this case. Could you give me some ideas ?