Home » Developer & Programmer » Reports & Discoverer » How to print vertical records horizontally in single record
How to print vertical records horizontally in single record [message #243615] Fri, 08 June 2007 00:58 Go to next message
aries73
Messages: 4
Registered: March 2007
Junior Member
I have three tables

Voucher_Dtl

invno
main_code
sub_code
amount

Master

Main_code
Sub_code
Description

Detail_File


Invno
Qty

In Voucher_dtl File there are multiple record ag. single invno

invno main_code sub_code Amount
1 1461 1001 100
1 3205 0555 500
1 0250 1234 600

2 3205 0555 500
2 1461 1011 100
2 0250 1222 600

3 3208 0555 500
3 1461 1011 100
3 0250 4561 600

i want to print report first filter code subs(main_code,1,1) = '3' then group records based on main_code,sub_code with corrs. total qty total amt ag. this code and
of tax (main code) 1461 correspoing to '3'.

Report message to a moderator

Re: How to print vertical records horizontally in single record [message #243884 is a reply to message #243615] Sun, 10 June 2007 17:02 Go to previous message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unless I misunderstood the question, you might write several queries and join them using the Data Link tool; or, write a single "large" query and create break groups by drawing certain columns out of the existing group.

Report message to a moderator

Previous Topic: Cnnot Locate the Font File
Next Topic: report headers
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 26 18:48:12 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.