| Reports Help [message #89242] |
Mon, 22 December 2003 05:17  |
jan
Messages: 71
Registered: August 2002
|
Member |
|
|
I HAVE DIIFERENT TABLES
WHICH CONTAIN USAGE OF DIFFERENT ITEM ON A SPECIFIC DATE
FOR EXAMPLE POTATOS ,MANGOES ETC
DATE QTY TOT_PRICE QTY TOT_PRICE
1 1 11 1 22
2 2 44
3
ETC
MY PROBLEM IS THAT I HAVE TO PRINT DATE ONCE FOR EVERY ELEMENT
NOTE IAM MAINTAING DIFFERENT TABLE FOR EACH ITEM ,IT IS PREREQUISITE
BY USER.
HOW CAN PRINT IN ABOVEMENTIONED FORMAT PLS HELP
|
|
|
|
| Re: Reports Help [message #89246 is a reply to message #89242] |
Fri, 26 December 2003 21:07  |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Hi Jan,
I'm no Reports expert, but you can probably change your query to UNION ALL your item tables; then do a group by date. I can help you to formulate a query if you post you table layouts and a clear description of the output required.
Best regards.
Frank
|
|
|
|
| Re: Reports Help [message #89248 is a reply to message #89242] |
Sat, 27 December 2003 21:57 |
jasn
Messages: 39
Registered: October 2002
|
Member |
|
|
i have three table
table_ 1 is
date1, head1,qty1,tot_price1
table_2 is
date2,haed2,tot_price2
same is table3
now i want that a column of date should be generated from 1 to 31 and corresponding heads of corresponding dates must be printed
such as on 1-12-2003 etc
date head1 head2 head3
1 $200 $10
2 $100 $20
|
|
|
|
| Re: Reports Help [message #89249 is a reply to message #89248] |
Sun, 28 December 2003 22:23 |
Frank Naude
Messages: 4579
Registered: April 1998
|
Senior Member |
|
|
Nobody will be able to provide a solution on the info provided. Please provide a test case - include the exact table structures, sample data, and expected output!
Best regards.
Frank
|
|
|
|
| Re: Reports Help [message #89253 is a reply to message #89249] |
Tue, 30 December 2003 06:07 |
jan
Messages: 71
Registered: August 2002
|
Member |
|
|
Sir iam actualy developing a software for a resturant
now i have tables
for rent_a_car,meals etc
rent_a_car
has
name visitor_no,transaction_date,car_type,rate,tot_price
similar is meals table
i have one more table
visitor_mast
which contains
v_name v_no,date_in,date_out etc
now i want to print a report in the format
***************************
date rent_a_car meals
***************************
1 200 10
2 20
3
.
.
********************************
hope you have understood
regards
and tanx in advance
.
31 210 100
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
