first row in each page

Hi,
Can i know the first RowNumber in each page on a table ?
Thanks
--
Pony TsuiHi Pony,
Thank you for using Microsoft MSDN Managed Newsgroup Support.
In Reporting Services, you could use the RowNumber function to refer the
RowNumber of each row.
Here is an article for your reference:
http://msdn2.microsoft.com/en-us/library/ms159225(d=ide).aspx
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Lu,
Thanks for your reply.
I saw the RowNumber online help page before, RowNumber(Nothing) get the
RowNumber of a table, but i don't know how to get the first row in each page,
please help me.
--
Pony Tsui
"Wei Lu [MSFT]" wrote:
> Hi Pony,
> Thank you for using Microsoft MSDN Managed Newsgroup Support.
> In Reporting Services, you could use the RowNumber function to refer the
> RowNumber of each row.
> Here is an article for your reference:
> http://msdn2.microsoft.com/en-us/library/ms159225(d=ide).aspx
> Hope this will be helpful!
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi Pony,
Thank you for your update.
I would like to know how you pagination the report. Do you use any group?
If so, you could add a hidden column and add a textbox which contain a
value of First row of your group.
For example, if you are using the Group "tbl_Group", and your dataset have
a field named "field1". You could use the following expression in the
hidden textbox:
=first(Fields!field1.Value,"tbl_Group")
Then, you could use the expression to control the visibility of the
Rownumber textbox:
=IIf(ReportItems!txt_field1.Value = ReportItems!First_field1.Value
, false,true)
Hope this will be helpful for you. If you have any quesion, please feel
free to let me know.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi Lu,
Thanks for your reply.
Acturally, i need to change the row backgroud color, for example, set odd
rows to blue, other to red, i use the table, but the rows of each page was
not fixed, maybe page 1 is 15, page 2 is 16, but i try to set the first row
to blue in each page.
i don't use any gruop, any suggest ?
--
Pony Tsui|||Hi Lu,
I don't see any attachment, can you send to me again?
Thanks,
--
Pony Tsui|||Hi Lu,
I got the Demo Report, thanks.
I try the Demo Report, the backgroud color of first row in each page is
blue, other rows is red, but i need alternate background color, and the rows
in each page is not fix number, i can set alternate background color, but i
want the color of first row in each page is fix.
For example:
=iif(RowNumber(Nothing) Mod 2=1, "blue", "red")
page 1(15 Rows)
row 1 blue
row 2 red
row 3 blue
row 4 red
row 5 blue
row 6 red
...........
...........
...........
row 15 blue
page 2(14 Rows)
row 1 red
row 2 blue
row 3 red
row 4 blue
row 5 red
row 6 blue
...........
...........
...........
row 14 red
the background color of first row in page 1 is blue
the background color of first row in page 2 is red
because the rows in each page is not fix in 15 or 14, so the background
color of first row in each page is variation also.
is there any way to solve this problem?
Pony Tsui|||Hello Pony,
Thank you for your reply.
In this case, I suggest you to limit the rows per page to a fixed amount so
that you could use the expression in your post to control the background
color.
To limit the rows per page to a fixed number, you could do the following:
1. Add a details grouping on the table based on a group expression similar
to this:
=Ceiling(RowNumber(Nothing)/20)
2. Make sure to select "page break at end" on the detail group dialog.
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hello Pony,
How is everythin going? If you have any question, please feel free to let
me know.
Sincerely,
Wei Lu
Microsoft Online Community Support