[CLOSED] How calculate the sum for two tables

Hi All,

I am having two tables in one FEX file like below.

SQL SQLORA PREPARE SQLOUT FOR
-INCLUDE app/tshares_bal1.sql
END
TABLE FILE SQLOUT
PRINT
SEQUENCENUMBER
SHAREAMOUNT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF OPEN
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

SQL SQLORA PREPARE SQLOUT FOR
-INCLUDE app/tshares_prf.sql
END
TABLE FILE SQLOUT
PRINT
PROCESSDATE
AMOUNT
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT PDF CLOSE
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
ENDSTYLE
END

Now i need to calcualte the total of SHAREAMOUNT column of first table and AMOUNT column of second table and need to display this total at the end of second table.

How to solve this?
can anyone please help me?

Thanks in advance.......

This message has been edited. Last edited by: <Kathryn Henning>,

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

FrankDutch

Virtuoso

posted

Hide Post

Many ways to skin a cat, but I would in this case create an union query on the SQL part.
Then you have all the data in on report.

Of course the fields need to have the same name and format. And you might want to add a resource code to the two parts.

Of course you also can do this after you selected the data with SQL
In that case you in fact create a 3th report With the sum of both data sets.

In that case I would put the 2 data sets first in 2 different hold files.

But I am sure you will come up with aditional questions.
To much to explane in one single answer.

How about some basic training.?

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Show Post

santu

Gold member

posted

Hide Post

Hi FrankDutch,

I am new to webfocus. I didn't got any basic training.

My two tables having different types of columns.
I will merge the two SQL queries into one.

After that how to seperate the datesets into two hold files and do the sum calculation.

I am doing this for PDF reports. Here one more problem, two tables should come in one page like appending one table after another.In this case your idea will work.

Can you please provide me some rough code in the form of steps.

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted

Show Post

FrankDutch

Virtuoso

posted

Hide Post

Step one

Try to get some training

Step two

Study the databases that are mentioned in the manuals, like the CAR table. Many examples are made on that table

Step three

I would recommend to create masters for these database tables if you need to build reports more then once.
Then you can rename and reformat the fields so they are the same.
You can add a defined field to both tables like Tblname and give them a basic.
Now you can create a report based on these two tables as if it is one table
And you still have because of the table name a way to split the report in two separate subtotals and an overall total.

Step ...

Good luck..

	*Frank*
	prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7

Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006

Ignored post by FrankDutch posted

Show Post

Guru

posted

Hide Post

Santu, I see you are new to the forums and focus in general. I also see several topics in a row with your name. Training is great and will save you a lot of time.

Also, you DO have time to read up on the documentation, trust me. Although the members of this forum are great and quick to respond, they have their work too. Sometimes you may not get a response for a couple of days. Looking up something in the documentation usually only takes a minute (especially if you are familiar).

We are here to help, not to do your work. When I started off, I didn't receive training off the bat either. Instead I toyed around, read the documentation, and read through many of the previous posts already in these forums that answered many of my questions. I didn't post a question until after several months in FOCUS.

WebFOCUS 7.7.03/8.0.08
Dev Studio 7.7.03/8.0.08
App Studio 8.0.08
Windows 7
ALL Outputs

Posts: 402 | Location: Upland, IN | Registered: June 08, 2012

Ignored post by J posted

Show Post

santu

Gold member

posted

Hide Post

Sorry for this.

I will follow your path.

Thankyou............

Web FOCUS 7.7.03
PDF

Posts: 69 | Registered: May 24, 2013

Ignored post by santu posted