KPI graphic in RS2005

Hi,
Does anybody know how to show a SS2005 KPI image in reporting services?
Thanks.You can't just show the image that you see in SSAS because it is not
streamed back. Instead, you need to load you image based on the KPI value.
The image Value property can be controlled programatically. I have a sample
project (http://prologika.com/CS/blogs/blog/archive/2005/10/05/687.aspx)
that demonstrates how you can manipulate the image source programically. It
doesn't show KPI values, but it should be able to steer you in the right
direction.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Fernando Marçal" <FernandoMaral@.discussions.microsoft.com> wrote in message
news:14EC6E85-C505-443E-B2D9-5FF923133B4C@.microsoft.com...
> Hi,
> Does anybody know how to show a SS2005 KPI image in reporting services?
> Thanks.|||Hi Teo,
Will look into it. Thanks.
"Teo Lachev [MVP]" wrote:
> You can't just show the image that you see in SSAS because it is not
> streamed back. Instead, you need to load you image based on the KPI value.
> The image Value property can be controlled programatically. I have a sample
> project (http://prologika.com/CS/blogs/blog/archive/2005/10/05/687.aspx)
> that demonstrates how you can manipulate the image source programically. It
> doesn't show KPI values, but it should be able to steer you in the right
> direction.
> --
> HTH,
> ---
> Teo Lachev, MVP, MCSD, MCT
> "Microsoft Reporting Services in Action"
> "Applied Microsoft Analysis Services 2005"
> Home page and blog: http://www.prologika.com/
> ---
> "Fernando Marçal" <FernandoMaral@.discussions.microsoft.com> wrote in message
> news:14EC6E85-C505-443E-B2D9-5FF923133B4C@.microsoft.com...
> > Hi,
> >
> > Does anybody know how to show a SS2005 KPI image in reporting services?
> >
> > Thanks.
>
>

Killing Locks by Object - SS2005

splocI can't restore a database due to a locking issue. While I've killed
the Process in Activity Monitor, I still see the database listed on the Locks
By Object page. The Process ID is a negative number. Any ideas as to what I
can do to get rid of this lock?
Here's the output from sp_lock: -2 7 0 0 DB
S GRANT
Thanks in advance.
JohnOn Oct 5, 1:49 am, John Roberts
<JohnRobe...@.discussions.microsoft.com> wrote:
> splocI can't restore a database due to a locking issue. While I've killed
> the Process in Activity Monitor, I still see the database listed on the Locks
> By Object page. The Process ID is a negative number. Any ideas as to what I
> can do to get rid of this lock?
> Here's the output from sp_lock: -2 7 0 0 DB
> S GRANT
> Thanks in advance.
> John
After killing the process you may try putting database in single user
mode which would prevent application or user establishing connection.
Thanks
VS|||Thanks for the response..
When I do a select distinct req_transactionuow, req_transactionID from
syslockinfo where req_spid = -2
I see the follwing:
req_transactionuow req_transactionID
--
--
00000000-0000-0000-0000-000000000000 0
When I try to kill this UOW using the guid of all zeroes, we get the
following error:
Msg 6110, Level 16, State 1, Line 1
The distributed transaction with UOW {00000000-0000-0000-0000-000000000000}
does not exist.
Anybody out there familiar with killing orphaned transactions where the UOW
GUID is all zeros? My only solution now is to restart the service and, as
you might have imagined, that's NOT the only database running!!
Thanks in advance.
John
"vijay" wrote:
> On Oct 5, 1:49 am, John Roberts
> <JohnRobe...@.discussions.microsoft.com> wrote:
> > splocI can't restore a database due to a locking issue. While I've killed
> > the Process in Activity Monitor, I still see the database listed on the Locks
> > By Object page. The Process ID is a negative number. Any ideas as to what I
> > can do to get rid of this lock?
> >
> > Here's the output from sp_lock: -2 7 0 0 DB
> > S GRANT
> >
> > Thanks in advance.
> >
> > John
> After killing the process you may try putting database in single user
> mode which would prevent application or user establishing connection.
> Thanks
> VS
>

Key cannot be null. Parameter name: key

We just upgraded to SS2005. After the upgrade, we can no longer create
subscriptions out of Execution Snapshot.
Try this experiment:
Create a report, with a simple SQL statement like "select * from CustomerDim
where CustomerPk = @.CustomerPk"
Go to Report Parameter, check the "Allow Null" box
Deploy the report
Go to the report on report server, render the report from Execution Snapshot
Now go to Subscription, and try to create a new subscription. The Parameter
CustomerPk will be grayed out, because of the Execution Snapshot
After you clicked OK, the subscription will return the error:
Key cannot be null. Parameter name: key
This error does not occur before the upgrade.
How can we create subscriptions out of Execution Snapshot in SS2005?
Thanks,
John WI've got the same problem. Did you find any solution?
Regards,
/Mattias
"LBJOHN" wrote:
> We just upgraded to SS2005. After the upgrade, we can no longer create
> subscriptions out of Execution Snapshot.
> Try this experiment:
> Create a report, with a simple SQL statement like "select * from CustomerDim
> where CustomerPk = @.CustomerPk"
> Go to Report Parameter, check the "Allow Null" box
> Deploy the report
> Go to the report on report server, render the report from Execution Snapshot
> Now go to Subscription, and try to create a new subscription. The Parameter
> CustomerPk will be grayed out, because of the Execution Snapshot
> After you clicked OK, the subscription will return the error:
> Key cannot be null. Parameter name: key
> This error does not occur before the upgrade.
> How can we create subscriptions out of Execution Snapshot in SS2005?
> Thanks,
> John W