Showing posts with label references. Show all posts
Showing posts with label references. Show all posts

Friday, March 30, 2012

Report parameter metadata not updated during deployment

In 2005, I've experienced a problem when re-deploying reports to the report server. The parameter references don't get updated properly and I would either need to re-deploy several times, or delete the reports and deploy a fresh copy. The latter re-creates the report GUIDs and messes up usage statistics. I've not been able to reproduce this consistently but have aexperienced it on several projects.

Is this issue being adressed in RS 2008?

I've run into this one as well.


I think this also occurred in SSRS 2000 as well.

|||The behavior around parameter metadata has not changed in Katmai. If you have a specific scenario where things get messed up, post a bug over on the connect site and we will take a look.|||

This is raised and explained in this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1

I can't envisage parameter defaults and prompts being maintaned by an administrator. Does an override mechanism exist in RS 2005? If not, then will it be added in 2008?

Report parameter metadata not updated during deployment

In 2005, I've experienced a problem when re-deploying reports to the report server. The parameter references don't get updated properly and I would either need to re-deploy several times, or delete the reports and deploy a fresh copy. The latter re-creates the report GUIDs and messes up usage statistics. I've not been able to reproduce this consistently but have aexperienced it on several projects.

Is this issue being adressed in RS 2008?

I've run into this one as well.


I think this also occurred in SSRS 2000 as well.

|||The behavior around parameter metadata has not changed in Katmai. If you have a specific scenario where things get messed up, post a bug over on the connect site and we will take a look.|||

This is raised and explained in this post http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=100960&SiteID=1

I can't envisage parameter defaults and prompts being maintaned by an administrator. Does an override mechanism exist in RS 2005? If not, then will it be added in 2008?

Wednesday, March 21, 2012

Report Model Expressions

I would like to define a new field in one of my Report Model entities, by
creating an expression that references some attributes of an entity related
by a role. Is this possible?
Also, is there a kludge I can use to handle the fact that there is no IIF
function available?
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.comOK, I upgraded to SP2 (CTP) and now I can get it to work, but it is still
buggy. I need to combine 3 attributes. I was able to concatenate 2 of them
with a new field definition, and add the 3rd as a column expression. When I
tried to combine the 3 in the new field definitiion, I kept getting errors.
Also, I understand that one can inject one's own expression directly into
the rdl, so I am going to experiment with that as a means of getting IIF.
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com
"Helen Warn" wrote:
> I would like to define a new field in one of my Report Model entities, by
> creating an expression that references some attributes of an entity related
> by a role. Is this possible?
> Also, is there a kludge I can use to handle the fact that there is no IIF
> function available?
>
> --
> Helen Warn, PhD
> Agile Software Inc.
> www.agile-soft.com