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.

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.

Prasanna,

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

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

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.

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