Newbie - Report

Hi all,

I would like to print this in report:-

item Description of Goods Quantity
1 Apple 10
2 Banana 20
3 Orange 30

I just don't know how to print out the ITEM column, by
writing up SQL statement properly.

Many thanks.

Regards,
Wandy

Josh
Mon Dec 29 21:37:07 CST 2003



I guess that would depend on your data structure...

On Mon, 29 Dec 2003 19:08:55 -0800, "Wandy Tang"
<anonymous@discussions.microsoft.com> wrote:

>Hi all,
>
>I would like to print this in report:-
>
>item Description of Goods Quantity
>1 Apple 10
>2 Banana 20
>3 Orange 30
>
>I just don't know how to print out the ITEM column, by
>writing up SQL statement properly.
>
>Many thanks.
>
>Regards,
>Wandy


---
Remove x's to send.

swdev2
Tue Dec 30 00:08:07 CST 2003

Wandy ??? a small prg to drive the cursor building and report generation ?
something like this ->
select item, descrip, quantity from tablename into cursor rep_curs
report form WT_repo to printer

*----
that is it, in its most basic form.
xie xie [Bill]
--
William Sanders / Electronic Filing Group Remove the DOT BOB to reply via
email.
FREE LONG DISTANCE -> mailto:excel-info@efgroup.net
Free Satellite Receivers and installation ->
http://www.vmcsatellite.com/?aid=58456
mySql / VFP / MS-SQL
"Wandy Tang" <anonymous@discussions.microsoft.com> wrote in message
news:000401c3ce82$427ffbe0$a001280a@phx.gbl...
> Hi all,
>
> I would like to print this in report:-
>
> item Description of Goods Quantity
> 1 Apple 10
> 2 Banana 20
> 3 Orange 30
>
> I just don't know how to print out the ITEM column, by
> writing up SQL statement properly.
>
> Many thanks.
>
> Regards,
> Wandy

Dan
Tue Dec 30 12:20:39 CST 2003

Wandy,

I think you really mean line number instead of item.

You'll have to "fake" it by using a temporary cursor:

SELECT 0 as item, Descript, Qty from Source into cursor temp READWRITE
REPLACE ALL item WITH Recno() IN temp

Now you have a field carrying line number you can include in your report.

Dan

"Wandy Tang" <anonymous@discussions.microsoft.com> wrote in message
news:000401c3ce82$427ffbe0$a001280a@phx.gbl...
> Hi all,
>
> I would like to print this in report:-
>
> item Description of Goods Quantity
> 1 Apple 10
> 2 Banana 20
> 3 Orange 30
>
> I just don't know how to print out the ITEM column, by
> writing up SQL statement properly.
>
> Many thanks.
>
> Regards,
> Wandy

Josh
Tue Dec 30 14:37:41 CST 2003

if ti's recno; why not put the recno() in report text field on the report?

On Tue, 30 Dec 2003 10:20:39 -0800, "Dan Freeman" <spam@microsoft.com> wrote:

>Wandy,
>
>I think you really mean line number instead of item.
>
>You'll have to "fake" it by using a temporary cursor:
>
>SELECT 0 as item, Descript, Qty from Source into cursor temp READWRITE
>REPLACE ALL item WITH Recno() IN temp
>
>Now you have a field carrying line number you can include in your report.
>
>Dan
>
>"Wandy Tang" <anonymous@discussions.microsoft.com> wrote in message
>news:000401c3ce82$427ffbe0$a001280a@phx.gbl...
>> Hi all,
>>
>> I would like to print this in report:-
>>
>> item Description of Goods Quantity
>> 1 Apple 10
>> 2 Banana 20
>> 3 Orange 30
>>
>> I just don't know how to print out the ITEM column, by
>> writing up SQL statement properly.
>>
>> Many thanks.
>>
>> Regards,
>> Wandy
>


---
Remove x's to send.

Anders
Tue Dec 30 19:06:22 CST 2003

Wandy
I suppose Item is not part of your data; it's a sequential number you want
to insert int the report. The easiest way is to create a report varible in
the Report -> Variables.. menu. Give it an Inital Value of 1 and check (*)
Count
-Anders


"Wandy Tang" <anonymous@discussions.microsoft.com> wrote in message
news:000401c3ce82$427ffbe0$a001280a@phx.gbl...
> Hi all,
>
> I would like to print this in report:-
>
> item Description of Goods Quantity
> 1 Apple 10
> 2 Banana 20
> 3 Orange 30
>
> I just don't know how to print out the ITEM column, by
> writing up SQL statement properly.
>
> Many thanks.
>
> Regards,
> Wandy