In have a main report in which for the same name we have two records as we have two dates related to that query and we get two rows.
I have an Applicant whose information is being displayed and I have a sub report which is linked to the main report Applicant name so it is being shown for each Applicant(in a way I wanted).
But I want to show sub report only for the second row of the same applicant, not for both the rows as sub report has a simple detail of the Applicant and it looks vague when it shows same data fro first row as well as second row.
Is there any way I achieve this?
Applicant City Date
A City1 2012/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
A City1 2011/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
And I want display like:
Applicant City Date
A City1 2012/01/01
A City1 2011/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
What I have done now, is I added a Running Total field under my group, it gave record number for each row within group, how to do that you can see here:
itityagi
Member
460 Points
176 Posts
Hide Sub Report for First Record
Feb 13, 2013 05:34 AM|LINK
In have a main report in which for the same name we have two records as we have two dates related to that query and we get two rows.
I have an Applicant whose information is being displayed and I have a sub report which is linked to the main report Applicant name so it is being shown for each Applicant(in a way I wanted).
But I want to show sub report only for the second row of the same applicant, not for both the rows as sub report has a simple detail of the Applicant and it looks vague when it shows same data fro first row as well as second row.
Is there any way I achieve this?
Applicant City Date
A City1 2012/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
A City1 2011/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
And I want display like:
Applicant City Date
A City1 2012/01/01
A City1 2011/01/01
Subreport:
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
CruzerB
Contributor
5399 Points
1098 Posts
Re: Hide Sub Report for First Record
Feb 13, 2013 08:10 AM|LINK
Hi,
You can use the Suppress with condition for this requirement.
http://www.opensymmetry.co.uk/askjon/viewtopic.php?t=781&f=66
My Technical Blog
itityagi
Member
460 Points
176 Posts
Re: Hide Sub Report for First Record
Feb 13, 2013 09:41 AM|LINK
What I have done now, is I added a Running Total field under my group, it gave record number for each row within group, how to do that you can see here:
http://vbcity.com/forums/t/76847.aspx
Now I set the supress formula for the section containing sub report like of
in this way when we have more than one record in the same group, in my case I will only have same Applicant in Group(so it worked)
then it is going to hide the second subreport.