Reports

[Former Member]

Hi,

I have two tables table1 and table 2 .These tables are related with doc field .doc if primary key in table1 and primary key in table2 .Now i need to report the data as like following.

DOCK NO: 1

Name CITY

a b

c n

here i need to enter into next page and display details for another dock NO

DOCK NO: 2

Name CITY

e r

t u

How is it possible?

Regarding ,

M.Thippa Reddy

[Former Member · Accepted solution]

Hi Thippa Reddy,

It is so simple create a group on Doc and go in Report--Section Expert and select Group Header then click on New Page Before or select Group Footer and click on New Page After.

This will print each group in new page

Thanks,

Sastry

[Former Member]

I would say what is not possible in this? I mean you have two tables,

Table 1 and table 2.

You would like to show the Doc_no from table one into the report. Are you counting those Doc_nos? If you are then you can use Running Total of Doc_no from table 1 and choose Summary type as Count, or Distinct Count which ever way you want to count them.

On the report create two groups, one group would be of Doc_No from table 1, then create a 2nd group which will be of City Name from table 1.

Under the first group (Doc_No) suppress the group footer 1, and under Group footer 2 which is City Name, place the Running total and run the report. See if you get the correct results.

Do the same for the Table 2

Regards

Jehanzeb