Bookmarks

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?
ThanksThis 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
Eric wrote:
> 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|||Thanks Chris,
But this is not an option because the report isn't based on one dataset or
table, the report format is mixed.
"Chris" wrote:
> 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
>
> Eric wrote:
> > 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
>
> --
>|||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.|||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?
Thanks|||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.|||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.
>>I don't think you can use the bookmark directly in a report designer.
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
>>You can use the class only in your custom rendering extensions for
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

Bookmarks

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?
ThanksHi Eric,
Thank you for posting here!
However, I notice you have posted the same question in this newsgroup,
which MVP have already responded. So please check the answer there and if
you need any further assistance on this particular issue, please reply to
me in that thread so I can follow up with you in time. Also, please don't
cross-post the same question in multiple newsgroups in the future so that
our engineers can work on your question efficiently. Your understanding and
cooperation is appreciated.
Thank you and Have a nice day!
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.

Bold AND Italic Text Not Possible?

Is it not possible to format text as bold and italic in SRS? I find
this hard to believe, but whenener I specify both properties
(FontWeight and FontStyle), the italic property overrides the bold
property. Anyone else encountered this problem? Is there a work-
around?On Feb 8, 10:40 am, m...@.swbell.net wrote:
> Is it not possible to format text as bold and italic in SRS? I find
> this hard to believe, but whenener I specify both properties
> (FontWeight and FontStyle), the italic property overrides the bold
> property. Anyone else encountered this problem? Is there a work-
> around?
Are you using RS 2005?|||On Feb 8, 10:19 am, "DMcM" <mcmah...@.twcny.rr.com> wrote:
> On Feb 8, 10:40 am, m...@.swbell.net wrote:
> > Is it not possible to format text as bold and italic in SRS? I find
> > this hard to believe, but whenener I specify both properties
> > (FontWeight and FontStyle), the italic property overrides the bold
> > property. Anyone else encountered this problem? Is there a work-
> > around?
> Are you using RS 2005?
Thanks for your reply. Yes I am. I am setting both properties at
design time. It appears that FontStyle is the dominant property. Its
strange. You can do this with every other Microsoft product...

BOL in Printed Format

Does anyone know of a copy of BOL in a printed format?
Thanks,
--
Ben M"Ben" <ben@.brainspout.com> wrote in message
news:%23p4xsSe4DHA.360@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Does anyone know of a copy of BOL in a printed format?

---

The closest thing you will get is
http://www.microsoft.com/mspress/books/5001.asp|||The nearest thing is
Microsoft SQL Server 2000 Reference Library
http://www.microsoft.com/mspress/books/5001.asp
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ben" <ben@.brainspout.com> wrote in message
news:%23p4xsSe4DHA.360@.TK2MSFTNGP12.phx.gbl...

quote:

---

> Does anyone know of a copy of BOL in a printed format?
> Thanks,
> --
> Ben M
>

---

BOL in Printed Format

Does anyone know of a copy of BOL in a printed format?
Thanks,
--
Ben M"Ben" <ben@.brainspout.com> wrote in message
news:%23p4xsSe4DHA.360@.TK2MSFTNGP12.phx.gbl...
> Does anyone know of a copy of BOL in a printed format?
The closest thing you will get is
http://www.microsoft.com/mspress/books/5001.asp|||The nearest thing is
Microsoft SQL Server 2000 Reference Library
http://www.microsoft.com/mspress/books/5001.asp
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Ben" <ben@.brainspout.com> wrote in message
news:%23p4xsSe4DHA.360@.TK2MSFTNGP12.phx.gbl...
> Does anyone know of a copy of BOL in a printed format?
> Thanks,
> --
> Ben M
>

BLOB data

I am working on integrating Novell's IDM JDBC driver with a SQL 2005
database to retrieve user photos. The photos are in BLOB format, however
they are too large for eDirectory to handle. Is there a way to resize data
that is already stored in a BLOB field? If not, what's the easiest (and can
be automated easiest) way to export and resize these files? Thanks in
advance!!
Joey
Write a C# app to do it (there are all kinds of image libraries available
out there). SQL Server just sees a big string, basically, that represents
the graphic. There is no way for SQL Server to resize or resample graphics
you store, just like your fridge can't change a 2 L bottle of milk into a
500 mL bottle. :-)
"Joey Kinney" <joey.kinney@.rackspace.com> wrote in message
news:uQM%23dnFlIHA.5160@.TK2MSFTNGP05.phx.gbl...
>I am working on integrating Novell's IDM JDBC driver with a SQL 2005
>database to retrieve user photos. The photos are in BLOB format, however
>they are too large for eDirectory to handle. Is there a way to resize data
>that is already stored in a BLOB field? If not, what's the easiest (and
>can be automated easiest) way to export and resize these files? Thanks in
>advance!!
> Joey

BLOB data

I am working on integrating Novell's IDM JDBC driver with a SQL 2005
database to retrieve user photos. The photos are in BLOB format, however
they are too large for eDirectory to handle. Is there a way to resize data
that is already stored in a BLOB field' If not, what's the easiest (and can
be automated easiest) way to export and resize these files' Thanks in
advance!!
JoeyWrite a C# app to do it (there are all kinds of image libraries available
out there). SQL Server just sees a big string, basically, that represents
the graphic. There is no way for SQL Server to resize or resample graphics
you store, just like your fridge can't change a 2 L bottle of milk into a
500 mL bottle. :-)
"Joey Kinney" <joey.kinney@.rackspace.com> wrote in message
news:uQM%23dnFlIHA.5160@.TK2MSFTNGP05.phx.gbl...
>I am working on integrating Novell's IDM JDBC driver with a SQL 2005
>database to retrieve user photos. The photos are in BLOB format, however
>they are too large for eDirectory to handle. Is there a way to resize data
>that is already stored in a BLOB field' If not, what's the easiest (and
>can be automated easiest) way to export and resize these files' Thanks in
>advance!!
> Joey

blank pages inserted on exported pdf and tif format

Hi,
After I export the report to PDF or TIF format, the pages became double. It
inserts a blank sheet on every page of the report. Does anyone know how to
fix this issue? Any help is appreciate it.
Thanks,
LianneLianne,
I had that problem too. Some of your report items are wider than the page.
Look on the ruler above your report page and make sure that you do not have
any report items that go to the right more than the width of your page
(usually it's 8.5 inches).
Good luck.
"Lianne Kwock" wrote:
> Hi,
> After I export the report to PDF or TIF format, the pages became double. It
> inserts a blank sheet on every page of the report. Does anyone know how to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne|||Not greater than the width of the page when considering your margins plus
the ruler.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Simon Gold" <SimonGold@.discussions.microsoft.com> wrote in message
news:862C6173-C1F9-40B2-8C4E-1B1333BEA0ED@.microsoft.com...
> Lianne,
> I had that problem too. Some of your report items are wider than the page.
> Look on the ruler above your report page and make sure that you do not
> have
> any report items that go to the right more than the width of your page
> (usually it's 8.5 inches).
> Good luck.
> "Lianne Kwock" wrote:
>> Hi,
>> After I export the report to PDF or TIF format, the pages became double.
>> It
>> inserts a blank sheet on every page of the report. Does anyone know how
>> to
>> fix this issue? Any help is appreciate it.
>>
>> Thanks,
>> Lianne|||You will also need to make sure that your report respect the following:
Body:Width > (Report:PageWidth - Report:LeftMargin -
Report:RightMargin).
A similar restriction exists for Body:Height and Report:PageHeight.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lianne Kwock" <LianneKwock@.discussions.microsoft.com> wrote in message
news:509E186D-CBBD-4725-B46C-47F175AEAA6F@.microsoft.com...
> Hi,
> After I export the report to PDF or TIF format, the pages became double.
> It
> inserts a blank sheet on every page of the report. Does anyone know how
> to
> fix this issue? Any help is appreciate it.
>
> Thanks,
> Lianne

Bizarre behavior rendering Web Archive format

I have a report that displays summary information, I've setup a subscription
on the report that attaches a web archive copy of the report to the
distribution list. When the report is rendered for the attachment in the
middle of the result set for no apparent reason it randomly displays the
values in the report using a different format, like larger font, left
justification where right justification should be. I can send an example of
this for anyone would like to help but the data is sensitive so I'll not post
it publicly..Hi,
Thanks for using Microsoft MSDN Managed Newsgroup.
I would like to work with you on this issue.
Could you please mail me (changliw@.microsoft.com) your example so that I
can reproduce your issue?
Best regards,
Charles Wang
Microsoft Online Community Support
=====================================================Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
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.
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Hello Danny,
We have recieved your test html and rdl files. I've view the html copy, and
I only see some bold text in the summary/total rows, while the text in
other rows are of the same layout(size , font). Would you tell me the
locatio of the problem text in it? Since the datasources are specific to
your environment, I can not try running it on my local test machine. Is it
possible that you try generate a simplified report with some test data(xml
or a test database file) that can reproduce the same error behavior? if so,
I can perform a complete test on my side. You can reach me through the
email in my signature(remove "online" )
Please feel free to let me know if you have any further concerns.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hello Danny,
Have you got any further progress on this issue? As mentioned in the last
reply, the problem may need more info to repro, and due to the complexity
and specific nature of the problem, I would suggest you consider contact
CSS for further troubleshooting if this is an urgent issue.
http://msdn.microsoft.com/subscriptions/support/default.aspx
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.

Bitwise operator question

This is a multi-part message in MIME format.
--=_NextPart_000_002D_01C4F892.984E52C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
What is the biggest values that SQL Server supports for bitwise AND and = OR.
The BOL says any of the integer datatypes. But in the examples, it = only references int, smallint and tinyint (and binary conversion stuff).
Does SQL support bigint values as well? eg. 64-bit comparisons?
I've run a couple of sample scripts to test, but I would like some = confirmation from others.
Thanks
Rick Sawtell
MCT, MCSD, MCDBA
--=_NextPart_000_002D_01C4F892.984E52C0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
What is the biggest values that SQL = Server supports for bitwise AND and OR.

The BOL says any of the integer datatypes. But in the examples, it only references = int, smallint and tinyint (and binary conversion stuff).

Does SQL support bigint values as = well? eg. 64-bit comparisons?


I've run a couple of sample scripts to = test, but I would like some confirmation from others.


Thanks


Rick Sawtell
MCT, MCSD, MCDBA


--=_NextPart_000_002D_01C4F892.984E52C0--This is a multi-part message in MIME format.
--=_NextPart_000_00C3_01C4F89B.FAB67F60
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Sure:
SELECT CONVERT(BIGINT, 35184372088833) & 1
Note: You do need to explicitly convert it to BIGINT or else SQL Server =will try to implicitly convert it to NUMERIC, which does not support =bitwise comparisons.
-- Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Rick Sawtell" <quickening@.msn.com> wrote in message =news:eBlLVTM%23EHA.1396@.tk2msftngp13.phx.gbl...
What is the biggest values that SQL Server supports for bitwise AND =and OR.
The BOL says any of the integer datatypes. But in the examples, it =only references int, smallint and tinyint (and binary conversion stuff).
Does SQL support bigint values as well? eg. 64-bit comparisons?
I've run a couple of sample scripts to test, but I would like some =confirmation from others.
Thanks
Rick Sawtell
MCT, MCSD, MCDBA
--=_NextPart_000_00C3_01C4F89B.FAB67F60
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

---

Sure:
SELECT CONVERT(BIGINT, 35184372088833) =& 1
Note: You do need to explicitly =convert it to BIGINT or else SQL Server will try to implicitly convert it to NUMERIC, =which does not support bitwise comparisons.
-- Adam MachanicSQL Server MVPhttp://www.sqljunkies.com/weblog/amachanic">http://www.sqljunkies=.com/weblog/amachanic--
"Rick Sawtell" wrote in =message news:eBlLVTM%23EHA.=1396@.tk2msftngp13.phx.gbl...
What is the biggest values that SQL =Server supports for bitwise AND and OR.

The BOL says any of the integer datatypes. But in the examples, it only references =int, smallint and tinyint (and binary conversion stuff).

Does SQL support bigint values as well? eg. 64-bit comparisons?


I've run a couple of sample scripts =to test, but I would like some confirmation from others.


Thanks


Rick Sawtell
MCT, MCSD, MCDBA

---

--=_NextPart_000_00C3_01C4F89B.FAB67F60--|||Bitwise operaters are supported with BIGINT. Bitmaps are a lousy way to hold
data in a strongly-typed database though, so you shouldn't need bitwise
operators very often.
--
David Portas
SQL Server MVP
--|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> wrote in message
news:F3772EF4-A53D-4740-9835-642A6BBF767F@.microsoft.com...
> Bitwise operaters are supported with BIGINT. Bitmaps are a lousy way to
> hold
> data in a strongly-typed database though, so you shouldn't need bitwise
> operators very often.
> --
> David Portas
> SQL Server MVP
> --
>
How would you suggest tracking 16000 different options.
Rick|||"Rick Sawtell" <quickening@.msn.com> wrote in message
news:%23svAjAO%23EHA.1524@.TK2MSFTNGP09.phx.gbl...
> How would you suggest tracking 16000 different options.
Certainly not in a 16000-bit bitmask... Assuming those options were for
users, I would do something like this:
CREATE TABLE Options
(
OptionID INT PRIMARY KEY,
OptionName VARCHAR(50),
...
)
CREATE TABLE UserOptions
(
OptionID INT,
UserID INT,
CONSTRAINT FK_UserOptions_Options FOREIGN KEY (OptionID) REFERENCES
Options (OptionID),
CONSTRAINT FK_UserOptions_Users FOREIGN KEY (UserID) REFERENCES
Users (UserID),
CONSTRAINT PK_UserOptions PRIMARY KEY (OptionID, UserID)
)
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--|||In a table, with atomic columns representing real attributes. How else? :-)
If you have that many elements to track then I would say bitmaps are
definitely no-go. Bitmaps don't benefit from optimization on individual
attributes and every query will force a table-scan with the bitwise
operations performed on every row.
--
David Portas
SQL Server MVP
--