all groups > sql server reporting services > march 2006 >
You're in the

sql server reporting services

group:

Bookmarks


Re: Bookmarks Chris
3/8/2006 1:45:14 PM
sql server reporting services:
This is something I asked for in the early days of RS2000,
it was a problem that could only be resolved by using two passes.
Generate the data, save it into a data table adding a row number to
each record. If you know how many rows fit a page you can then generate
the report then construct an index at the end using the row number.

I'm aware this is far from ideal, but I can't think of another way.
The reason it's difficult is that the different rendering methods all
have different ideas about what a page is.

Cheers
Chris


[quoted text, click to view]



--
Bookmarks Eric
3/8/2006 8:52:00 PM
Hi,

How I can create an index in a report which are referencing bookmarks in the
report?

I would like to have this format:

[Name / Title of bookmark] [Page Number]
....
[Name / Title of bookmark] [Page Number]


Can I get the page numer with an expression?

Thanks

Re: Bookmarks Eric
3/9/2006 1:49:28 AM
Thanks Chris,

But this is not an option because the report isn't based on one dataset or
table, the report format is mixed.

[quoted text, click to view]
Re: Bookmarks t-weilu NO[at]SPAM online.microsoft.com
3/10/2006 4:01:56 AM
Hi Eric,

Based on my research, Chris's suggestion seems to be the only way to do
this. You have to do this with the dataset. Hope you can understand.

You may submit feedback on this via the link below to improve our product.
http://lab.msdn.microsoft.com/productfeedback/default.aspx

Thanks!


Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
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.
Re: Bookmarks Eric
3/12/2006 1:29:29 PM
Hi Wei

Thanks, but how you want to calculate the pagenumber if you havbe different
tables, freetext, charts, etc.

My questions was also about a custom render item.

Because in the SRSS2005 library you have also a class named 'Bookmark' &
'Bookmarks', where all the bookmarks are stored.

It's there no way to access these classes / properties?

Re: Bookmarks t-weilu NO[at]SPAM online.microsoft.com
3/13/2006 8:43:55 AM
Hi Eric,

Thanks for the update.

I don't think you can use the bookmark directly in a report designer.

You can use the class only in your custom rendering extensions for
Reporting Services.

A rendering extension is a component or module of a report server that
transforms report data and layout information into a device-specific
format. SQL Server Reporting Services includes six rendering extensions:
HTML, Excel, CSV or Text, XML, Image, and PDF. You can create additional
rendering extensions to generate reports in other formats.

The Reporting Services Extension Library is a set of classes, interfaces,
and value types that are included in Reporting Services. This library
provides access to system functionality and is designed to be the
foundation on which Microsoft .NET Framework applications can be used to
extend Reporting Services components.

You may find the information in the Reporting Services Extensions section
in SQL Books online.

Wei Lu
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
=====================================================
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.
Re: Bookmarks Eric
3/14/2006 12:51:28 PM
Hi Wei,

Thanks for your answer.
I have read the documentation and I'm aware of the rendering extension and
also the custom render item.

[quoted text, click to view]
I was talking about a custom report item, like a rendering extension but one
level deeper.
http://msdn2.microsoft.com/en-us/library/ms345259(SQL.90).aspx


[quoted text, click to view]
Reporting Services.
And for a custom report item? Or can the item not access all bookmarks,
because the report wasn't yet rendered fully?

Thanks
AddThis Social Bookmark Button