Hi all,
I am creating a report in BI Dev Studio and use the grouping
functionality to show the number of leads for different sales
representatives. I also use "drill down" to show the leads in detail.
The report also uses a filter to filter out certain time period.
On the sales persons level I use "Rowcount" to show the number of
leads. this works fine as long as I do not use any filter. If I use the
filter, the "Rowcount" function still shows the number of leads for the
whole table, although the sub-group shows the right number of entries.
Where is my mistake?You could place your filter in the WHERE statement under the data tab.
<leebm@.sms.at> wrote in message
news:1156789789.405721.156960@.h48g2000cwc.googlegroups.com...
> Hi all,
> I am creating a report in BI Dev Studio and use the grouping
> functionality to show the number of leads for different sales
> representatives. I also use "drill down" to show the leads in detail.
> The report also uses a filter to filter out certain time period.
> On the sales persons level I use "Rowcount" to show the number of
> leads. this works fine as long as I do not use any filter. If I use the
> filter, the "Rowcount" function still shows the number of leads for the
> whole table, although the sub-group shows the right number of entries.
> Where is my mistake?
>|||Ben Watts schrieb:
> You could place your filter in the WHERE statement under the data tab.
> <leebm@.sms.at> wrote in message
> news:1156789789.405721.156960@.h48g2000cwc.googlegroups.com...
> > Hi all,
> > I am creating a report in BI Dev Studio and use the grouping
> > functionality to show the number of leads for different sales
> > representatives. I also use "drill down" to show the leads in detail.
> > The report also uses a filter to filter out certain time period.
> > On the sales persons level I use "Rowcount" to show the number of
> > leads. this works fine as long as I do not use any filter. If I use the
> > filter, the "Rowcount" function still shows the number of leads for the
> > whole table, although the sub-group shows the right number of entries.
> >
> > Where is my mistake?
> >
Thanks for the answer, but how do I place the filter in the sql
statment exactly? I tried something like: select * from
Adressenherkunft where insertdate = 'Parameters!von.Value' but this
does not work?|||Hi,
The syntax is like
insertdate = @.von
where "von" is the name of the parameter exactly as it shows in the report
parameters dialogbox.
HTH,
Jordi Rambla
MVP SQL Server (Reporting Services)
Solid Quality Learning (http://www.solidqualitylearning.com)
"Markus" <leebm@.sms.at> escribió en el mensaje
news:1156850392.248071.158990@.75g2000cwc.googlegroups.com...
> Ben Watts schrieb:
>> You could place your filter in the WHERE statement under the data tab.
>> <leebm@.sms.at> wrote in message
>> news:1156789789.405721.156960@.h48g2000cwc.googlegroups.com...
>> > Hi all,
>> > I am creating a report in BI Dev Studio and use the grouping
>> > functionality to show the number of leads for different sales
>> > representatives. I also use "drill down" to show the leads in detail.
>> > The report also uses a filter to filter out certain time period.
>> > On the sales persons level I use "Rowcount" to show the number of
>> > leads. this works fine as long as I do not use any filter. If I use the
>> > filter, the "Rowcount" function still shows the number of leads for the
>> > whole table, although the sub-group shows the right number of entries.
>> >
>> > Where is my mistake?
>> >
> Thanks for the answer, but how do I place the filter in the sql
> statment exactly? I tried something like: select * from
> Adressenherkunft where insertdate = 'Parameters!von.Value' but this
> does not work?
>
Showing posts with label grouping. Show all posts
Showing posts with label grouping. Show all posts
Tuesday, March 27, 2012
Monday, March 26, 2012
Fill footer dynamically by group
Hello,
I would like to modify dynamically my footer.
I have a list displayed on several pages and grouping my data on IDCategory. I would like to put on the footer the name of the category on each page of the list.
When I use a textbox (with the name of category) on the body, with a link ReportItems!textbox1.Value on the footer, the value is only displayed on the first page of my report.
Could you tell me how to display it on each page ?
The second footer problem is that I want to hide this footer on the first page of my list. In reporting services, you can hide the footer on the first page, but can you hide the footer of each first page of a list ?
Thanks for all.Report item references from the page header/footer return Nothing if that
report item doesn't appear on the page.
Instead of putting a single textbox in the body (which would only appear on
the first page of the report), put the textbox in your innermost list. That
way it will be certain to appear on every page (mark it as Hidden so that it
is on the page but not visisble to the user).
For the second problem, you need some way of detecting the start of your
inner list. For this, you could add a second (hidden) textbox inside the
outer list. Then the expression in your footer could be something like
this:
=iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
Nothing)
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Drix" <Drix@.discussions.microsoft.com> wrote in message
news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> Hello,
> I would like to modify dynamically my footer.
> I have a list displayed on several pages and grouping my data on
IDCategory. I would like to put on the footer the name of the category on
each page of the list.
> When I use a textbox (with the name of category) on the body, with a link
ReportItems!textbox1.Value on the footer, the value is only displayed on the
first page of my report.
> Could you tell me how to display it on each page ?
> The second footer problem is that I want to hide this footer on the first
page of my list. In reporting services, you can hide the footer on the first
page, but can you hide the footer of each first page of a list ?
> Thanks for all.|||Thanks for your help.
For your first answer, what do you mean with "innermost" ? I've tried to put the textbox at the bottom of the list, but the problem persists : the footer only appears on the last page.
For your second answer, it's not possible to put on the footer more than one reference to the body and I couldn't test other solutions if the first problem isn't resolved !
Thanks for your help for "innermost"...
"Chris Hays [MSFT]" wrote:
> Report item references from the page header/footer return Nothing if that
> report item doesn't appear on the page.
> Instead of putting a single textbox in the body (which would only appear on
> the first page of the report), put the textbox in your innermost list. That
> way it will be certain to appear on every page (mark it as Hidden so that it
> is on the page but not visisble to the user).
> For the second problem, you need some way of detecting the start of your
> inner list. For this, you could add a second (hidden) textbox inside the
> outer list. Then the expression in your footer could be something like
> this:
> =iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
> Nothing)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Drix" <Drix@.discussions.microsoft.com> wrote in message
> news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> > Hello,
> >
> > I would like to modify dynamically my footer.
> > I have a list displayed on several pages and grouping my data on
> IDCategory. I would like to put on the footer the name of the category on
> each page of the list.
> >
> > When I use a textbox (with the name of category) on the body, with a link
> ReportItems!textbox1.Value on the footer, the value is only displayed on the
> first page of my report.
> > Could you tell me how to display it on each page ?
> >
> > The second footer problem is that I want to hide this footer on the first
> page of my list. In reporting services, you can hide the footer on the first
> page, but can you hide the footer of each first page of a list ?
> >
> > Thanks for all.
>
>|||Based on your description, you have two lists (the outer one containing the
inner one).
The outer list groups on IDCategory. The second textbox should be inside
this list.
The inner list doesn't group (it shows detail data). The first textbox
should be inside this list.
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Drix" <Drix@.discussions.microsoft.com> wrote in message
news:E931E967-9FC5-4EA9-9D2A-26554B26AEC4@.microsoft.com...
> Thanks for your help.
> For your first answer, what do you mean with "innermost" ? I've tried to
put the textbox at the bottom of the list, but the problem persists : the
footer only appears on the last page.
> For your second answer, it's not possible to put on the footer more than
one reference to the body and I couldn't test other solutions if the first
problem isn't resolved !
> Thanks for your help for "innermost"...
>
> "Chris Hays [MSFT]" wrote:
> > Report item references from the page header/footer return Nothing if
that
> > report item doesn't appear on the page.
> >
> > Instead of putting a single textbox in the body (which would only appear
on
> > the first page of the report), put the textbox in your innermost list.
That
> > way it will be certain to appear on every page (mark it as Hidden so
that it
> > is on the page but not visisble to the user).
> >
> > For the second problem, you need some way of detecting the start of your
> > inner list. For this, you could add a second (hidden) textbox inside
the
> > outer list. Then the expression in your footer could be something like
> > this:
> >
> > =iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
> > Nothing)
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "Drix" <Drix@.discussions.microsoft.com> wrote in message
> > news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> > > Hello,
> > >
> > > I would like to modify dynamically my footer.
> > > I have a list displayed on several pages and grouping my data on
> > IDCategory. I would like to put on the footer the name of the category
on
> > each page of the list.
> > >
> > > When I use a textbox (with the name of category) on the body, with a
link
> > ReportItems!textbox1.Value on the footer, the value is only displayed on
the
> > first page of my report.
> > > Could you tell me how to display it on each page ?
> > >
> > > The second footer problem is that I want to hide this footer on the
first
> > page of my list. In reporting services, you can hide the footer on the
first
> > page, but can you hide the footer of each first page of a list ?
> > >
> > > Thanks for all.
> >
> >
> >sql
I would like to modify dynamically my footer.
I have a list displayed on several pages and grouping my data on IDCategory. I would like to put on the footer the name of the category on each page of the list.
When I use a textbox (with the name of category) on the body, with a link ReportItems!textbox1.Value on the footer, the value is only displayed on the first page of my report.
Could you tell me how to display it on each page ?
The second footer problem is that I want to hide this footer on the first page of my list. In reporting services, you can hide the footer on the first page, but can you hide the footer of each first page of a list ?
Thanks for all.Report item references from the page header/footer return Nothing if that
report item doesn't appear on the page.
Instead of putting a single textbox in the body (which would only appear on
the first page of the report), put the textbox in your innermost list. That
way it will be certain to appear on every page (mark it as Hidden so that it
is on the page but not visisble to the user).
For the second problem, you need some way of detecting the start of your
inner list. For this, you could add a second (hidden) textbox inside the
outer list. Then the expression in your footer could be something like
this:
=iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
Nothing)
--
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Drix" <Drix@.discussions.microsoft.com> wrote in message
news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> Hello,
> I would like to modify dynamically my footer.
> I have a list displayed on several pages and grouping my data on
IDCategory. I would like to put on the footer the name of the category on
each page of the list.
> When I use a textbox (with the name of category) on the body, with a link
ReportItems!textbox1.Value on the footer, the value is only displayed on the
first page of my report.
> Could you tell me how to display it on each page ?
> The second footer problem is that I want to hide this footer on the first
page of my list. In reporting services, you can hide the footer on the first
page, but can you hide the footer of each first page of a list ?
> Thanks for all.|||Thanks for your help.
For your first answer, what do you mean with "innermost" ? I've tried to put the textbox at the bottom of the list, but the problem persists : the footer only appears on the last page.
For your second answer, it's not possible to put on the footer more than one reference to the body and I couldn't test other solutions if the first problem isn't resolved !
Thanks for your help for "innermost"...
"Chris Hays [MSFT]" wrote:
> Report item references from the page header/footer return Nothing if that
> report item doesn't appear on the page.
> Instead of putting a single textbox in the body (which would only appear on
> the first page of the report), put the textbox in your innermost list. That
> way it will be certain to appear on every page (mark it as Hidden so that it
> is on the page but not visisble to the user).
> For the second problem, you need some way of detecting the start of your
> inner list. For this, you could add a second (hidden) textbox inside the
> outer list. Then the expression in your footer could be something like
> this:
> =iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
> Nothing)
> --
> My employer's lawyers require me to say:
> "This posting is provided 'AS IS' with no warranties, and confers no
> rights."
> "Drix" <Drix@.discussions.microsoft.com> wrote in message
> news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> > Hello,
> >
> > I would like to modify dynamically my footer.
> > I have a list displayed on several pages and grouping my data on
> IDCategory. I would like to put on the footer the name of the category on
> each page of the list.
> >
> > When I use a textbox (with the name of category) on the body, with a link
> ReportItems!textbox1.Value on the footer, the value is only displayed on the
> first page of my report.
> > Could you tell me how to display it on each page ?
> >
> > The second footer problem is that I want to hide this footer on the first
> page of my list. In reporting services, you can hide the footer on the first
> page, but can you hide the footer of each first page of a list ?
> >
> > Thanks for all.
>
>|||Based on your description, you have two lists (the outer one containing the
inner one).
The outer list groups on IDCategory. The second textbox should be inside
this list.
The inner list doesn't group (it shows detail data). The first textbox
should be inside this list.
My employer's lawyers require me to say:
"This posting is provided 'AS IS' with no warranties, and confers no
rights."
"Drix" <Drix@.discussions.microsoft.com> wrote in message
news:E931E967-9FC5-4EA9-9D2A-26554B26AEC4@.microsoft.com...
> Thanks for your help.
> For your first answer, what do you mean with "innermost" ? I've tried to
put the textbox at the bottom of the list, but the problem persists : the
footer only appears on the last page.
> For your second answer, it's not possible to put on the footer more than
one reference to the body and I couldn't test other solutions if the first
problem isn't resolved !
> Thanks for your help for "innermost"...
>
> "Chris Hays [MSFT]" wrote:
> > Report item references from the page header/footer return Nothing if
that
> > report item doesn't appear on the page.
> >
> > Instead of putting a single textbox in the body (which would only appear
on
> > the first page of the report), put the textbox in your innermost list.
That
> > way it will be certain to appear on every page (mark it as Hidden so
that it
> > is on the page but not visisble to the user).
> >
> > For the second problem, you need some way of detecting the start of your
> > inner list. For this, you could add a second (hidden) textbox inside
the
> > outer list. Then the expression in your footer could be something like
> > this:
> >
> > =iif(ReportItems!textbox2.Value is Nothing, ReportItems!textbox1.Value,
> > Nothing)
> >
> > --
> > My employer's lawyers require me to say:
> > "This posting is provided 'AS IS' with no warranties, and confers no
> > rights."
> >
> > "Drix" <Drix@.discussions.microsoft.com> wrote in message
> > news:65779D3C-E124-45D7-AD0A-4D20627F3664@.microsoft.com...
> > > Hello,
> > >
> > > I would like to modify dynamically my footer.
> > > I have a list displayed on several pages and grouping my data on
> > IDCategory. I would like to put on the footer the name of the category
on
> > each page of the list.
> > >
> > > When I use a textbox (with the name of category) on the body, with a
link
> > ReportItems!textbox1.Value on the footer, the value is only displayed on
the
> > first page of my report.
> > > Could you tell me how to display it on each page ?
> > >
> > > The second footer problem is that I want to hide this footer on the
first
> > page of my list. In reporting services, you can hide the footer on the
first
> > page, but can you hide the footer of each first page of a list ?
> > >
> > > Thanks for all.
> >
> >
> >sql
Subscribe to:
Posts (Atom)