Loosing Bold when exporting to Excel

Hi,
I have a report that bolds font in a table cell based on an expression.
This works fine when I browse the report in reporting services. When I
export the report to Excel - all of the bold text returns to normal weight
text. Any ideas to get around this?
Thanks,
MelissaMelissa, this seems to be a hot topic this week!
I've seen three other posts on this already. This is the same as the
Excel font colour from expressions problem.
Whatever formatting the first cell evaluates too, the whole column is
set too. As far as I can tell, there is no way round this.
I've raised it as a bug with MS
Chris
Melissa wrote:
> Hi,
> I have a report that bolds font in a table cell based on an
> expression. This works fine when I browse the report in reporting
> services. When I export the report to Excel - all of the bold text
> returns to normal weight text. Any ideas to get around this?
> Thanks,
> Melissa|||Thanks Chris for the response!
Melissa
"Chris McGuigan" wrote:
> Melissa, this seems to be a hot topic this week!
> I've seen three other posts on this already. This is the same as the
> Excel font colour from expressions problem.
> Whatever formatting the first cell evaluates too, the whole column is
> set too. As far as I can tell, there is no way round this.
> I've raised it as a bug with MS
> Chris
> Melissa wrote:
> > Hi,
> >
> > I have a report that bolds font in a table cell based on an
> > expression. This works fine when I browse the report in reporting
> > services. When I export the report to Excel - all of the bold text
> > returns to normal weight text. Any ideas to get around this?
> >
> > Thanks,
> > Melissa
>

Loop through the dataset

hello All,
This questione pertains to Sql server 2005 reporting services.
Is there a way to browse through each record in the dataset and also make
changes if required before it is rendered on the report?You would have to create a data processing extension which is non-trivial.
Instead, consider basing the value of the cell as an expression. You do not
have to map to a field of the dataset, you can also use expressions (and
expression can call your code too).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Abby" <Abby@.discussions.microsoft.com> wrote in message
news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
> hello All,
> This questione pertains to Sql server 2005 reporting services.
> Is there a way to browse through each record in the dataset and also make
> changes if required before it is rendered on the report?|||Hi Bruce,
Can you elaborate on the second method u mentioned... In the sense i have
written custom codes and retrived values in the cells using expressions but
how would this work when there is multiple rows of data and i need to do a
comparison between 2 rows of data before deciding what should go in that
field.
Also wouldn't this slow down the process if each cell is calling code to
retrive the value from the db.
"Bruce L-C [MVP]" wrote:
> You would have to create a data processing extension which is non-trivial.
> Instead, consider basing the value of the cell as an expression. You do not
> have to map to a field of the dataset, you can also use expressions (and
> expression can call your code too).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Abby" <Abby@.discussions.microsoft.com> wrote in message
> news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
> > hello All,
> > This questione pertains to Sql server 2005 reporting services.
> >
> > Is there a way to browse through each record in the dataset and also make
> > changes if required before it is rendered on the report?
>
>|||It won't work for what you want, in expressions you can only look at the
current row of data.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Abby" <Abby@.discussions.microsoft.com> wrote in message
news:6FF60E74-4ADF-428A-A8AD-B07E631A3BDD@.microsoft.com...
> Hi Bruce,
> Can you elaborate on the second method u mentioned... In the sense i have
> written custom codes and retrived values in the cells using expressions
> but
> how would this work when there is multiple rows of data and i need to do a
> comparison between 2 rows of data before deciding what should go in that
> field.
> Also wouldn't this slow down the process if each cell is calling code to
> retrive the value from the db.
>
> "Bruce L-C [MVP]" wrote:
>> You would have to create a data processing extension which is
>> non-trivial.
>> Instead, consider basing the value of the cell as an expression. You do
>> not
>> have to map to a field of the dataset, you can also use expressions (and
>> expression can call your code too).
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Abby" <Abby@.discussions.microsoft.com> wrote in message
>> news:FAEFF35F-E9C9-4F07-8573-A689C7A12D67@.microsoft.com...
>> > hello All,
>> > This questione pertains to Sql server 2005 reporting services.
>> >
>> > Is there a way to browse through each record in the dataset and also
>> > make
>> > changes if required before it is rendered on the report?
>>

Looking for tutorials/walkthroughts on Report parameters

Could someone please point me to a tutorial on how to implement complex
parameters in Reporting Services reports? I ask this because the online help
available seems to be extremely minimal.
What I will probably be doing is writing reports with multiple parameters
including single values, dropdown lists, and calendars. Also I probably will
need to hide/expose/change-value-of some parameters based on the selection of
others.
Any sort of info or even a recognizable starting point to research this
would be of help. Thanks!Sorry. False alarm. Please cancel.
(I should say I found the help for the Report Parameters editing screen
minimal. Finally Googled and found the Technet tutorial on cascading
parameters which is roughly what I was looking for.
However this is all academic because I've just been taken off the project.)
"B. Chernick" wrote:
> Could someone please point me to a tutorial on how to implement complex
> parameters in Reporting Services reports? I ask this because the online help
> available seems to be extremely minimal.
> What I will probably be doing is writing reports with multiple parameters
> including single values, dropdown lists, and calendars. Also I probably will
> need to hide/expose/change-value-of some parameters based on the selection of
> others.
> Any sort of info or even a recognizable starting point to research this
> would be of help. Thanks!

Looking for simple sample

Hello

I'm looking around for tutorials and samples for Notification Services applications for a while now, but I just can't find something that covers what I want to do. All I want is to check if a value in my Database changes or exceeds a specific value and then send a mail.

Does anyone know a good sample that show's me how to do this or can anyone explain it in a couple of words?

Thanks in advance!

This is a fairly common scenario. Use the SQL Server Event Provider to query your database table, looking for new or changed records. In your Subscription Class, have each subscriber specify the threshold they are interested in and in the match rule compare the two to produce the notifications.

The Stock sample application that comes with SSNS would be an excellent place to start. Just replace the FileSystemWatcher Event Provider with the SQL Server Event Provider and you're most of the way there.

You'll probably want to use at least one Chronicles table to prevent unwanted/uninteresting notifications. For example, if the threshold is continually exceeded, you probably don't want to continually email your subscribers. To use the Stock sample to illustrate: if I want to know when Microsoft's stock exceeds $45/share. No big deal. But if on 5 consecutive generator firings the stock values are $44.90, $45.10, $45.20, $45.50, and $46.00, without careful planning you will have just generated 4 emails to me. To prevent the unwanted notifications, use the chronicles table - either keep track of the highwater mark, or the fact that you've already sent out a notification, or whatever makes the most sense in your situation. BTW - if you have a copy of my book, I discuss this in Chapter 7, but I'll be glad to continue the conversation here, too.

HTH...

Joe

Looking for good articles/tips/tricks on reporting services.

Hi all,
Does anyone known or recommend for good publisher issues articles which have
good tips/tricks on sql reporting services. Thank you.
LThe Hitchhiker's Guide to SQL Server 2000 Reporting Services is a very good
book.
Brian Welcker has excellent webcasts.
--
Sergio
"Lam Nguyen" wrote:
> Hi all,
> Does anyone known or recommend for good publisher issues articles which have
> good tips/tricks on sql reporting services. Thank you.
>
> L
>|||There are also many sample reports at www.msbicentral.com
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Lam Nguyen" <LamNguyen@.discussions.microsoft.com> wrote in message
news:0030FA35-6653-414F-B747-70BC142051F9@.microsoft.com...
> Hi all,
> Does anyone known or recommend for good publisher issues articles which
> have
> good tips/tricks on sql reporting services. Thank you.
>
> L
>