Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Issue in creating 2 table files and making a report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
Issue in creating 2 table files and making a report
 Login/Join
 
Gold member
posted
All,
I am new to webfocus.I have a requirement where i need to show the set of data one by one based on conditions.It has couple of grouping and where conditions.By refering the CAR MAS file specific examples, i tried creating 2 TABLE files with different data and used HOLD to keep the data, then used MORE to display them in a page.I took the example as it is and used them in report, but it says no data in table.But i am able to see data if i have one TABLE file.For commands like -Run,--Can anyone suggest how to make 2 table files and get one report output using report painter.


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP


 
Posts: 80 | Registered: March 21, 2007Report This Post
Virtuoso
posted Hide Post
You're probably getting no data because the two hold files are not similar. You can make them both the same, or create both files with a common key that can be JOINed or MATCHed) and create your final report off that structure.


Regards,

Darin



In FOCUS since 1991
WF Server: 7.7.04 on Linux and Z/OS, ReportCaster, Self-Service, MRE, Java, Flex
Data: DB2/UDB, Adabas, SQL Server Output: HTML,PDF,EXL2K/07, PS, AHTML, Flex
WF Client: 77 on Linux w/Tomcat
 
Posts: 2298 | Location: Salt Lake City, Utah | Registered: February 02, 2007Report This Post
Virtuoso
posted Hide Post
Prasanna,

Can you post some code of what you are trying to obtain?


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Gold member
posted Hide Post
Here is one example that i took from forum.
In this after first execution nothing is visible in the code part except the first one.Output also says no data.
SET ASNAMES = ON;
-* ITEM AA
TABLE FILE CAR
SUM
ITEM
PRICE1 AS 'PRICE'
BY THEMONTH
WHERE ITEM EQ 'AA'
ON TABLE HOLD AS H0 FORMAT ALPHA
END

-* ITEM BB
TABLE FILE CAR
SUM
ITEM
PRICE1 AS 'PRICE'
BY
THEMONTH
WHERE ITEM EQ 'BB'
ON TABLE HOLD AS H1 FORMAT ALPHA
END

TABLE FILE CAR
SUM
ITEM
PRICE2 AS 'PRICE'
BY
THEMONTH
WHERE ITEM EQ 'BB'
ON TABLE HOLD AS H2 FORMAT ALPHA
END

-* ITEM CC
TABLE FILE CAR
SUM
ITEM
PRICE1 AS 'PRICE'
BY
THEMONTH
WHERE ITEM EQ 'BB'
ON TABLE HOLD AS H3 FORMAT ALPHA
END

TABLE FILE CAR
SUM
ITEM
PRICE2 AS 'PRICE'
BY
THEMONTH
WHERE ITEM EQ 'BB'
ON TABLE HOLD AS H4 FORMAT ALPHA
END

TABLE FILE CAR
SUM
ITEM
PRICE3 AS 'PRICE'
BY
THEMONTH
WHERE ITEM EQ 'BB'
ON TABLE HOLD AS H5 FORMAT ALPHA
END

-* FINAL OUTPUT
TABLE FILE H0
PRINT
PRICE
BY
ITEM
ACROSS
THEMONTH
MORE
FILE H1
MORE
FILE H2
MORE
FILE H3
MORE
FILE H4
MORE
FILE H5
END

Regards
R.Prasanna


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP


 
Posts: 80 | Registered: March 21, 2007Report This Post
Virtuoso
posted Hide Post
Prasanna,

Did you notice that in all the HOLD files the data names and formats are the same?
In your application you MUST take care that the HOLD files have the exactly same MASTERs. If so, you shouldn't have any problems.
If however the problem persists, I would suggest you post the problem part of your program on this forum.


Daniel
In Focus since 1982
wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF

 
Posts: 1980 | Location: Tel Aviv, Israel | Registered: March 23, 2006Report This Post
Gold member
posted Hide Post
All,
I am able to see the output.
It was not working with HTML, but it worked with HTMTABLE.So, created 3 repors and 3 dialouge managers(for -RUN), and one HTMLFORM to display the 3 reports one below.
Thanks for your responses.

Regards
R.Prasanna


Dev:
Dev Studio 7.1.6,Report Caster 7.1.1,Servlet
Local:
Dev Studio 7.1.6,Report Caster 7.1.1,Apache 5.0.2,
Win XP


 
Posts: 80 | Registered: March 21, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Issue in creating 2 table files and making a report

Copyright © 1996-2020 Information Builders