×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Urgent : How can I generate Parent - Child kind of report..

Urgent : How can I generate Parent - Child kind of report..

Urgent : How can I generate Parent - Child kind of report..

(OP)
Hi, I want to generate following kind of sample report.    
                    
Title :
    Store Name : Land Side            

Table 1:                        
    Total Customers     Total Sale        
    200          2,500            

Table 2:                    
    Customer Name    Date        Qty    
    Steve        01/01/03    20    
    Paul        10/05/03    30    
                        

Title                        
    Store Name : West Side            

Table 1:                    
    Total Customers     Total Sale        
    150          1,700            

Table 2:                    
    Customer Name    Date        Qty    
    Herald        01/01/03    21    
    Hexcot        10/05/03    67    

For above requirement I am creating two database stored procedure.

In Webfocus, I am creating two individual hold files. This two hold file is called from one .FEX file. Title is actually group-by field.

Webfocus is putting the file one-after other and not one within another.

So, my requirement is with-in a report group, I want to add another report (Here table2) by passing related parameter.

How can I do this...?

Thanx for help..

RE: Urgent : How can I generate Parent - Child kind of report..

It's really not clear what you are asking, but it sounds like you want two TABLEs to contribute to the same report. TABLE does not work that way. Each one produces an independent report. With that said, TABLE is capable of using multiple 'sections' with different types of verbs. I think what you want is someting like:

TABLE FILE yourfile
HEADING
"Store Name : <Store"
SUM CNT.Customers Sales
BY Store NOPRINT
ON Store PAGE-BREAK
PRINT Customer Date Qty
BY Store NOPRINT
END

You will, of course, have to add column titles, or use other methods like SUBFOOT to format the report.

RE: Urgent : How can I generate Parent - Child kind of report..

(OP)
Hi..

Thanx for reply..

But My problem.. is I am having two different hold files and I want to generate above report..

In my question, i have displayed two sets of data. like that there can be n-number of stores.

Also, it will be one title but table1 and/or table2, each can have any number of records. Also table2 data-records will be base on the current store name.

Looking for your reply.

RE: Urgent : How can I generate Parent - Child kind of report..

I'm assuming that both tables have "Store Name" in them.  If so, you should be able to join them together and create your report.  You could display the information from table one in a subhead and table 2 as your report data.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close