Add an alert/warning via report Builder

Hi !
Is it possible to add an alert/warning via reportBuilder ?
An alert is for example a value which is superior of a nominal value for example...
I saw in a demo, it is possible to have it by creating a function, but this way is for the developper, if the user wants to add an alert himself ? how can he do ?
and maybe how can the developper help him ?

thank you for your answerthank you for your answer.

Excuse me, I think I didn't good explain my need.
I want to display a grid with duration values in the last colum (for example), if one of my duration is superior of 1 second, I want the cell (where the value is ) become red (background color).
I saw in a demo, (webCast in french) it is possible to add a function in the code tab or the report to select the color of the cell is the value is superior, but I want to know if somethings similaire exist for a simple user via report Builder ?
I think no, but I want to be sure....

|||Don′t think that this is possible, never saw such an option.

Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

Alineo wrote:

thank you for your answer.

Excuse me, I think I didn't good explain my need.
I want to display a grid with duration values in the last colum (for example), if one of my duration is superior of 1 second, I want the cell (where the value is ) become red (background color).
I saw in a demo, (webCast in french) it is possible to add a function in the code tab or the report to select the color of the cell is the value is superior, but I want to know if somethings similaire exist for a simple user via report Builder ?
I think no, but I want to be sure....

Hi I never did the duration before, but if you want to change the color of the cell, you can use an IIF statement in the background color property.

=IIF("Condition", "Red", "White")

Hope this helps

Bernard

|||Thank you for your help, I know what you explain but I ask to know, if it possible for a simple user via report Builder and not report designer...
But apparement it is not possible
|||

Alineo wrote:

Hi !
Is it possible to add an alert/warning via reportBuilder ?
An alert is for example a value which is superior of a nominal value for example...
I saw in a demo, it is possible to have it by creating a function, but this way is for the developper, if the user wants to add an alert himself ? how can he do ?
and maybe how can the developper help him ?

thank you for your answer

HI alineo,

It sounds like you are having the same problem or concept as I do. I am not sure whether this is the same problem as I am having, but here is the post that started this discussion. hope it might shed some light or else maybe someone can provide some enlightenment to us.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1450478&SiteID=1

Is there a way where you can show where this is working ? the demo you were speaking of?

thanks

Hope this helps.

Bernard

|||No, there is no way to place custom error messages in the user interface.

Jens K. Suessmeyer.

http://www.sqlserver2005.de