Only seeing data from last row in dataset

I have a master detail report that I'm having trouble
with, I have the report layed out and populating fields in
the master report with data, my report uses fields from the
master report and passes it as parameters to the subreport, that's all
working well, the problem is I only get data for the last
record in the master dataset... It's not displaying a new
page for each records in the master dataset... None of my
fields use the First function... My grouping in my query
is setup correctly, is there any other place to setup
grouping in the report designer...? What am I doing
wrong...? In the wizard it asks me how I would like to scope my fields
either Page, Group or Details, where can I access this functionality outside
the wizard, I created all of my reports without the wizard...I am not sure but it sounds like you need to put either a table or rectangle
onto the report that you can tie back to you dataset. If you just create a
report and put textboxes on the blank page you will only get the last row of
data.
"Alien2_51" wrote:
> I have a master detail report that I'm having trouble
> with, I have the report layed out and populating fields in
> the master report with data, my report uses fields from the
> master report and passes it as parameters to the subreport, that's all
> working well, the problem is I only get data for the last
> record in the master dataset... It's not displaying a new
> page for each records in the master dataset... None of my
> fields use the First function... My grouping in my query
> is setup correctly, is there any other place to setup
> grouping in the report designer...? What am I doing
> wrong...? In the wizard it asks me how I would like to scope my fields
> either Page, Group or Details, where can I access this functionality outside
> the wizard, I created all of my reports without the wizard...
>|||Hi John,
I'm pretty confident we're on to something here, I'm certain I'm just using
a report with text boxes on it, which is most definately why I'm seeing only
the last row of data. I put my data elements in a rectangle which seemed more
appropriate because I'm displaying header or master data in the "top" report,
so I want a new page for every row in the master dataset. I noticed in the
property pages for the rectangle that there is a drop down list thats labeled
Data region, the description reads: Type or select the data region with which
to repeat the rectangle on every page that the data region appears. My
question is this; Could you define the term "Data region" and how do I create
one in the designer. I typed in the field from the dataset but got an error.
In your post you had mentioned that I can tie it back to the dataset, what
did you mean by that...?
Thanks for your help!!!
Dan
"johnE" wrote:
> I am not sure but it sounds like you need to put either a table or rectangle
> onto the report that you can tie back to you dataset. If you just create a
> report and put textboxes on the blank page you will only get the last row of
> data.
> "Alien2_51" wrote:
> > I have a master detail report that I'm having trouble
> > with, I have the report layed out and populating fields in
> > the master report with data, my report uses fields from the
> > master report and passes it as parameters to the subreport, that's all
> > working well, the problem is I only get data for the last
> > record in the master dataset... It's not displaying a new
> > page for each records in the master dataset... None of my
> > fields use the First function... My grouping in my query
> > is setup correctly, is there any other place to setup
> > grouping in the report designer...? What am I doing
> > wrong...? In the wizard it asks me how I would like to scope my fields
> > either Page, Group or Details, where can I access this functionality outside
> > the wizard, I created all of my reports without the wizard...
> >|||Why do you have two datasets? As far as I know you cannot join two seperate
datasets in a report. I may be wrong. What might be easier is to join the
datsets in your query. When you do that you create a table and create a
group by the changing rows of the master data set. If that won't work then
use a subreport rather than two different datasets. the subreport will bring
in the detail. When you do it this way you put the rectangle on the report
for the master dataset. After you add the rectangle right click on it and
select properties. On the general tab there will be an option to tie it to a
data set. Then inside the main rectangle you add another one and add the
subreport to that. Let me know which way you decide to go and I can help you
with this.
"Alien2_51" wrote:
> Hi John,
> I'm pretty confident we're on to something here, I'm certain I'm just using
> a report with text boxes on it, which is most definately why I'm seeing only
> the last row of data. I put my data elements in a rectangle which seemed more
> appropriate because I'm displaying header or master data in the "top" report,
> so I want a new page for every row in the master dataset. I noticed in the
> property pages for the rectangle that there is a drop down list thats labeled
> Data region, the description reads: Type or select the data region with which
> to repeat the rectangle on every page that the data region appears. My
> question is this; Could you define the term "Data region" and how do I create
> one in the designer. I typed in the field from the dataset but got an error.
> In your post you had mentioned that I can tie it back to the dataset, what
> did you mean by that...?
> Thanks for your help!!!
> Dan
> "johnE" wrote:
> > I am not sure but it sounds like you need to put either a table or rectangle
> > onto the report that you can tie back to you dataset. If you just create a
> > report and put textboxes on the blank page you will only get the last row of
> > data.
> >
> > "Alien2_51" wrote:
> >
> > > I have a master detail report that I'm having trouble
> > > with, I have the report layed out and populating fields in
> > > the master report with data, my report uses fields from the
> > > master report and passes it as parameters to the subreport, that's all
> > > working well, the problem is I only get data for the last
> > > record in the master dataset... It's not displaying a new
> > > page for each records in the master dataset... None of my
> > > fields use the First function... My grouping in my query
> > > is setup correctly, is there any other place to setup
> > > grouping in the report designer...? What am I doing
> > > wrong...? In the wizard it asks me how I would like to scope my fields
> > > either Page, Group or Details, where can I access this functionality outside
> > > the wizard, I created all of my reports without the wizard...
> > >|||I don't have two datasets, I'm using a subreport, the subreports parameters
are tied to fields in my master dataset using the parameters collection in
the subreport, I don't see the option in the general tab to "tie it back to
the dataset" Are you talking about the "Data region"...? How do I create one
in the designer...? I typed in the field from the dataset I'm grouping on but
got an error. In your post you had mentioned that I can tie it back to the
dataset, what did you mean by that...?
I appreciate your help...
"johnE" wrote:
> Why do you have two datasets? As far as I know you cannot join two seperate
> datasets in a report. I may be wrong. What might be easier is to join the
> datsets in your query. When you do that you create a table and create a
> group by the changing rows of the master data set. If that won't work then
> use a subreport rather than two different datasets. the subreport will bring
> in the detail. When you do it this way you put the rectangle on the report
> for the master dataset. After you add the rectangle right click on it and
> select properties. On the general tab there will be an option to tie it to a
> data set. Then inside the main rectangle you add another one and add the
> subreport to that. Let me know which way you decide to go and I can help you
> with this.
> "Alien2_51" wrote:
> > Hi John,
> >
> > I'm pretty confident we're on to something here, I'm certain I'm just using
> > a report with text boxes on it, which is most definately why I'm seeing only
> > the last row of data. I put my data elements in a rectangle which seemed more
> > appropriate because I'm displaying header or master data in the "top" report,
> > so I want a new page for every row in the master dataset. I noticed in the
> > property pages for the rectangle that there is a drop down list thats labeled
> > Data region, the description reads: Type or select the data region with which
> > to repeat the rectangle on every page that the data region appears. My
> > question is this; Could you define the term "Data region" and how do I create
> > one in the designer. I typed in the field from the dataset but got an error.
> > In your post you had mentioned that I can tie it back to the dataset, what
> > did you mean by that...?
> >
> > Thanks for your help!!!
> >
> > Dan
> >
> > "johnE" wrote:
> >
> > > I am not sure but it sounds like you need to put either a table or rectangle
> > > onto the report that you can tie back to you dataset. If you just create a
> > > report and put textboxes on the blank page you will only get the last row of
> > > data.
> > >
> > > "Alien2_51" wrote:
> > >
> > > > I have a master detail report that I'm having trouble
> > > > with, I have the report layed out and populating fields in
> > > > the master report with data, my report uses fields from the
> > > > master report and passes it as parameters to the subreport, that's all
> > > > working well, the problem is I only get data for the last
> > > > record in the master dataset... It's not displaying a new
> > > > page for each records in the master dataset... None of my
> > > > fields use the First function... My grouping in my query
> > > > is setup correctly, is there any other place to setup
> > > > grouping in the report designer...? What am I doing
> > > > wrong...? In the wizard it asks me how I would like to scope my fields
> > > > either Page, Group or Details, where can I access this functionality outside
> > > > the wizard, I created all of my reports without the wizard...
> > > >|||click on the rectangle you drew. Go to the properties tab. One of the
properties is dataset name. there should be a drop down list that allows you
to select the dataset. After you select the data set insert the subreport.
Pass the fieild you want to use as a parameter. On the properties tab for
the sub report set the Page break after to True.
"Alien2_51" wrote:
> I don't have two datasets, I'm using a subreport, the subreports parameters
> are tied to fields in my master dataset using the parameters collection in
> the subreport, I don't see the option in the general tab to "tie it back to
> the dataset" Are you talking about the "Data region"...? How do I create one
> in the designer...? I typed in the field from the dataset I'm grouping on but
> got an error. In your post you had mentioned that I can tie it back to the
> dataset, what did you mean by that...?
> I appreciate your help...
>
> "johnE" wrote:
> > Why do you have two datasets? As far as I know you cannot join two seperate
> > datasets in a report. I may be wrong. What might be easier is to join the
> > datsets in your query. When you do that you create a table and create a
> > group by the changing rows of the master data set. If that won't work then
> > use a subreport rather than two different datasets. the subreport will bring
> > in the detail. When you do it this way you put the rectangle on the report
> > for the master dataset. After you add the rectangle right click on it and
> > select properties. On the general tab there will be an option to tie it to a
> > data set. Then inside the main rectangle you add another one and add the
> > subreport to that. Let me know which way you decide to go and I can help you
> > with this.
> >
> > "Alien2_51" wrote:
> >
> > > Hi John,
> > >
> > > I'm pretty confident we're on to something here, I'm certain I'm just using
> > > a report with text boxes on it, which is most definately why I'm seeing only
> > > the last row of data. I put my data elements in a rectangle which seemed more
> > > appropriate because I'm displaying header or master data in the "top" report,
> > > so I want a new page for every row in the master dataset. I noticed in the
> > > property pages for the rectangle that there is a drop down list thats labeled
> > > Data region, the description reads: Type or select the data region with which
> > > to repeat the rectangle on every page that the data region appears. My
> > > question is this; Could you define the term "Data region" and how do I create
> > > one in the designer. I typed in the field from the dataset but got an error.
> > > In your post you had mentioned that I can tie it back to the dataset, what
> > > did you mean by that...?
> > >
> > > Thanks for your help!!!
> > >
> > > Dan
> > >
> > > "johnE" wrote:
> > >
> > > > I am not sure but it sounds like you need to put either a table or rectangle
> > > > onto the report that you can tie back to you dataset. If you just create a
> > > > report and put textboxes on the blank page you will only get the last row of
> > > > data.
> > > >
> > > > "Alien2_51" wrote:
> > > >
> > > > > I have a master detail report that I'm having trouble
> > > > > with, I have the report layed out and populating fields in
> > > > > the master report with data, my report uses fields from the
> > > > > master report and passes it as parameters to the subreport, that's all
> > > > > working well, the problem is I only get data for the last
> > > > > record in the master dataset... It's not displaying a new
> > > > > page for each records in the master dataset... None of my
> > > > > fields use the First function... My grouping in my query
> > > > > is setup correctly, is there any other place to setup
> > > > > grouping in the report designer...? What am I doing
> > > > > wrong...? In the wizard it asks me how I would like to scope my fields
> > > > > either Page, Group or Details, where can I access this functionality outside
> > > > > the wizard, I created all of my reports without the wizard...
> > > > >|||Hi John,
Sorry man, we must be using different versions of the report designer or
something, I'm just not seeing the "dataset name" property you're talking
about... I've looked both on the property tab in the VS IDE and the property
pages accessed from the context menu... If you send me email at
dan.billow@.re.mo.ve.this.monacocoach.com, I'll send you some screen captures
of my property pages, I don't know what else to do.
"johnE" wrote:
> click on the rectangle you drew. Go to the properties tab. One of the
> properties is dataset name. there should be a drop down list that allows you
> to select the dataset. After you select the data set insert the subreport.
> Pass the fieild you want to use as a parameter. On the properties tab for
> the sub report set the Page break after to True.
> "Alien2_51" wrote:
> > I don't have two datasets, I'm using a subreport, the subreports parameters
> > are tied to fields in my master dataset using the parameters collection in
> > the subreport, I don't see the option in the general tab to "tie it back to
> > the dataset" Are you talking about the "Data region"...? How do I create one
> > in the designer...? I typed in the field from the dataset I'm grouping on but
> > got an error. In your post you had mentioned that I can tie it back to the
> > dataset, what did you mean by that...?
> >
> > I appreciate your help...
> >
> >
> > "johnE" wrote:
> >
> > > Why do you have two datasets? As far as I know you cannot join two seperate
> > > datasets in a report. I may be wrong. What might be easier is to join the
> > > datsets in your query. When you do that you create a table and create a
> > > group by the changing rows of the master data set. If that won't work then
> > > use a subreport rather than two different datasets. the subreport will bring
> > > in the detail. When you do it this way you put the rectangle on the report
> > > for the master dataset. After you add the rectangle right click on it and
> > > select properties. On the general tab there will be an option to tie it to a
> > > data set. Then inside the main rectangle you add another one and add the
> > > subreport to that. Let me know which way you decide to go and I can help you
> > > with this.
> > >
> > > "Alien2_51" wrote:
> > >
> > > > Hi John,
> > > >
> > > > I'm pretty confident we're on to something here, I'm certain I'm just using
> > > > a report with text boxes on it, which is most definately why I'm seeing only
> > > > the last row of data. I put my data elements in a rectangle which seemed more
> > > > appropriate because I'm displaying header or master data in the "top" report,
> > > > so I want a new page for every row in the master dataset. I noticed in the
> > > > property pages for the rectangle that there is a drop down list thats labeled
> > > > Data region, the description reads: Type or select the data region with which
> > > > to repeat the rectangle on every page that the data region appears. My
> > > > question is this; Could you define the term "Data region" and how do I create
> > > > one in the designer. I typed in the field from the dataset but got an error.
> > > > In your post you had mentioned that I can tie it back to the dataset, what
> > > > did you mean by that...?
> > > >
> > > > Thanks for your help!!!
> > > >
> > > > Dan
> > > >
> > > > "johnE" wrote:
> > > >
> > > > > I am not sure but it sounds like you need to put either a table or rectangle
> > > > > onto the report that you can tie back to you dataset. If you just create a
> > > > > report and put textboxes on the blank page you will only get the last row of
> > > > > data.
> > > > >
> > > > > "Alien2_51" wrote:
> > > > >
> > > > > > I have a master detail report that I'm having trouble
> > > > > > with, I have the report layed out and populating fields in
> > > > > > the master report with data, my report uses fields from the
> > > > > > master report and passes it as parameters to the subreport, that's all
> > > > > > working well, the problem is I only get data for the last
> > > > > > record in the master dataset... It's not displaying a new
> > > > > > page for each records in the master dataset... None of my
> > > > > > fields use the First function... My grouping in my query
> > > > > > is setup correctly, is there any other place to setup
> > > > > > grouping in the report designer...? What am I doing
> > > > > > wrong...? In the wizard it asks me how I would like to scope my fields
> > > > > > either Page, Group or Details, where can I access this functionality outside
> > > > > > the wizard, I created all of my reports without the wizard...
> > > > > >