Hi guys,
i have sql table which look like this
---------------------------------|
REC_ID | FID | TC | DESCRIPTION |
-------|-----|----|--------------|
1 | 1 | 1 | ABC |
-------|-----|----|--------------|
2 | 1 | 1 | ASD |
-------|-----|----|--------------|
3 | 1 | 2 | QWE |
-------|-----|----|--------------|
4 | 1 | 2 | OIU |
-------|-----|----|--------------|
5 | 2 | 1 | ABC |
-------|-----|----|--------------|
6 | 2 | 1 | ASD |
-------|-----|----|--------------|
7 | 2 | 2 | QWE |
-------|-----|----|--------------|
8 | 2 | 2 | OIU |
---------------------------------|
i have create a crystal report for this.
so that, what i did is, i have created main report in that i have inserted
sub-report(to display all fid's).
now in sub report i have used 'tc' and 'description', now, distinct 'tc' should come each on one page(i mean, for tc 1 one page, for tc 2 second page, so on).
i want to write the formula for 'new page after' in the section expert.
crystal report, should look like this
page 1:
REC_ID | FID | TC | DESCRIPTION |
-------|-----|----|--------------|
1 | 1 | 1 | ABC |
-------|-----|----|--------------|
2 | 1 | 1 | ASD |
-------|-----|----|--------------|
<pre>
page 2:
REC_ID | FID | TC | DESCRIPTION |
-------|-----|----|--------------|
3 | 1 | 2 | QWE |
-------|-----|----|--------------|
4 | 1 | 2 | OIU |
-------|-----|----|--------------|
</pre>
<pre>
page 3:
REC_ID | FID | TC | DESCRIPTION |
-------|-----|----|--------------|
5 | 2 | 1 | ABC |
-------|-----|----|--------------|
6 | 2 | 1 | ASD |
-------|-----|----|--------------|
</pre>
<pre>
page 4:
REC_ID | FID | TC | DESCRIPTION |
-------|-----|----|--------------|
7 | 2 | 2 | QWE |
-------|-----|----|--------------|
8 | 2 | 2 | OIU |
-------|-----|----|--------------|
</pre>
How to write this formula using tc column, can anyone plz help me...
Thanks