Home » Developer & Programmer » Reports & Discoverer » Reports Help
Reports Help [message #89242] Mon, 22 December 2003 05:17 Go to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4578
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Frank Naude
Messages: 4578
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 Go to previous message
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
Previous Topic: RWBLD60.EXE has generated errosrs will be closed by windows. You will need to restart the program.
Next Topic: change report fields lables and direction daynamicly??
Goto Forum:
  


Current Time: Sun Mar 03 10:37:09 CST 2024