defining background color in matrix

Hi All
In my report there is a dynamic matrix.
two section inside the data region need to be paint in two different
color.
i defined an Expression in the background properties.
the Expression define two ranges(four cordinates) in order to paint one
section
and more two ranges for the other section.
the problem occour while examine the data come from the DB. in those
junction
that there was no data involve the cell was'nt paint although it is in
the
range
of the painting.
i try to solve this by using the " is nothing" function but without any
successes.
one solution i had which is works was declaring temporary table int he
procedure ,addind rows to the temporary table plus the data it self
while
running
and then in the report to blank those cells by filter them.it work's
paint
those cells but damage the subtotal line(because new rows were adding
to the
table source).
if any knows how to solve this conflic i will very much appreciate
this.
thanks in advanced
Amir KrugliakHi
If this is reporting services then you may be better off posting to the
microsoft.public.sqlserver.reportingsvcs newsgroup.
John
"amir.krugliak@.gmail.com" wrote:

> Hi All
> In my report there is a dynamic matrix.
> two section inside the data region need to be paint in two different
> color.
> i defined an Expression in the background properties.
> the Expression define two ranges(four cordinates) in order to paint one
> section
> and more two ranges for the other section.
> the problem occour while examine the data come from the DB. in those
> junction
> that there was no data involve the cell was'nt paint although it is in
> the
> range
> of the painting.
> i try to solve this by using the " is nothing" function but without any
> successes.
> one solution i had which is works was declaring temporary table int he
> procedure ,addind rows to the temporary table plus the data it self
> while
> running
> and then in the report to blank those cells by filter them.it work's
> paint
> those cells but damage the subtotal line(because new rows were adding
> to the
> table source).
> if any knows how to solve this conflic i will very much appreciate
> this.
> thanks in advanced
> Amir Krugliak
>

Default value with expression doesn't work

I have a problem to set default value with expression like..
=DateSerial( Year(Now), Month(Now) +1, 0).
I try with Today, Globals!ExecutionTime,..but it doesn't work.
In preview and on server parameter filed is disabled. If i press View Report
then fileld gets correnct value. To view report i must press view report
again.
Thanks.I found the problem, but not the solution..
The problem arise when i have multiple parameters with 'expression' default
value.
"AG, NLB d.d." wrote:
> I have a problem to set default value with expression like..
> =DateSerial( Year(Now), Month(Now) +1, 0).
> I try with Today, Globals!ExecutionTime,..but it doesn't work.
> In preview and on server parameter filed is disabled. If i press View Report
> then fileld gets correnct value. To view report i must press view report
> again.
> Thanks.
>|||That's the way it works when parameter's default value is expression.
We do not know if expression depends on other parameters, therefore
expression is evaluated only when values of all preceding parameters are
known.
The workaround is to use default value from query.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
>I found the problem, but not the solution..
> The problem arise when i have multiple parameters with 'expression'
> default
> value.
> "AG, NLB d.d." wrote:
>> I have a problem to set default value with expression like..
>> =DateSerial( Year(Now), Month(Now) +1, 0).
>> I try with Today, Globals!ExecutionTime,..but it doesn't work.
>> In preview and on server parameter filed is disabled. If i press View
>> Report
>> then fileld gets correnct value. To view report i must press view report
>> again.
>> Thanks.|||But if i have only one parameter with expression =DateSerial( Year(Now),
Month(Now) +1, 0) it works fine, i get correct value.
If i have two or three there is a problem?
"Lev Semenets [MSFT]" wrote:
> That's the way it works when parameter's default value is expression.
> We do not know if expression depends on other parameters, therefore
> expression is evaluated only when values of all preceding parameters are
> known.
> The workaround is to use default value from query.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
> news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
> >I found the problem, but not the solution..
> >
> > The problem arise when i have multiple parameters with 'expression'
> > default
> > value.
> >
> > "AG, NLB d.d." wrote:
> >
> >> I have a problem to set default value with expression like..
> >> =DateSerial( Year(Now), Month(Now) +1, 0).
> >>
> >> I try with Today, Globals!ExecutionTime,..but it doesn't work.
> >>
> >> In preview and on server parameter filed is disabled. If i press View
> >> Report
> >> then fileld gets correnct value. To view report i must press view report
> >> again.
> >>
> >> Thanks.
> >>
>
>|||Yes, it would happen if there are two or more such parameters.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
news:E8F7BDB8-3C0D-445D-A90B-7206B62F0698@.microsoft.com...
> But if i have only one parameter with expression =DateSerial( Year(Now),
> Month(Now) +1, 0) it works fine, i get correct value.
> If i have two or three there is a problem?
>
> "Lev Semenets [MSFT]" wrote:
>> That's the way it works when parameter's default value is expression.
>> We do not know if expression depends on other parameters, therefore
>> expression is evaluated only when values of all preceding parameters are
>> known.
>> The workaround is to use default value from query.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "AG, NLB d.d." <AGNLBdd@.discussions.microsoft.com> wrote in message
>> news:956DFDBD-5AA7-4050-866A-12C63E65DF99@.microsoft.com...
>> >I found the problem, but not the solution..
>> >
>> > The problem arise when i have multiple parameters with 'expression'
>> > default
>> > value.
>> >
>> > "AG, NLB d.d." wrote:
>> >
>> >> I have a problem to set default value with expression like..
>> >> =DateSerial( Year(Now), Month(Now) +1, 0).
>> >>
>> >> I try with Today, Globals!ExecutionTime,..but it doesn't work.
>> >>
>> >> In preview and on server parameter filed is disabled. If i press View
>> >> Report
>> >> then fileld gets correnct value. To view report i must press view
>> >> report
>> >> again.
>> >>
>> >> Thanks.
>> >>
>>

Default Value of Parameter using expression - ERROR!

I am trying to use the following expression to establish the default
value for a parameter:
="SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('" & User!UserID
& "', 6, LEN('" & User!UserID & "') - 5))"
The User!UserID resolves as the domain\username or "AERO\username"
When I run the report with this expression in the default value of the
parameter, I get the error:
An unexpected error occurred in Report Processing.
Input string was in the wrong format.
I can use the following query in SQL Query Analyzer to successfully
return all records (or a specific record if I substitute an actual
username).
SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('Aero\' +
UserName, 6, LEN('Aero\' + UserName) - 5))
The return value DefLib is type Int... The value field for the
parameter is also an integer. Why would I receive this error if the
datatypes are the same?
TIA,
FerdBump
Ferd Biffle wrote:
> I am trying to use the following expression to establish the default
> value for a parameter:
> ="SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('" & User!UserID
> & "', 6, LEN('" & User!UserID & "') - 5))"
> The User!UserID resolves as the domain\username or "AERO\username"
> When I run the report with this expression in the default value of the
> parameter, I get the error:
> An unexpected error occurred in Report Processing.
> Input string was in the wrong format.
> I can use the following query in SQL Query Analyzer to successfully
> return all records (or a specific record if I substitute an actual
> username).
> SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('Aero\' +
> UserName, 6, LEN('Aero\' + UserName) - 5))
> The return value DefLib is type Int... The value field for the
> parameter is also an integer. Why would I receive this error if the
> datatypes are the same?
> TIA,
> Ferd|||Hello Ferd,
have you found a solution for this problem?
Tom

Default value for boolean parameter

I am getting very frustrated with SRS! I am trying to set a default
value for a boolean parameter. I used a simple expression =False.
What happens is that then the parameter's True and False buttons grey
out on me. Why would that be? How do I set a default value?
Also, is there some way to get a checkbox instead of a True and False
option button?On Mar 8, 8:13 pm, Doogie <dnlwh...@.dtgnet.com> wrote:
> I am getting very frustrated with SRS! I am trying to set a default
> value for a boolean parameter. I used a simple expression =False.
> What happens is that then the parameter's True and False buttons grey
> out on me. Why would that be? How do I set a default value?
> Also, is there some way to get a checkbox instead of a True and False
> option button?
Never mind. In .net it greyed out. But when I put it out on srs it
wasn't.
If you know of a way to get a checkbox though instead of option
buttons, that would be great.

Default value for a parameter using Expression - ERROR (again)

I posted this last week, and no one answered :-( If at first you don't
succeed...
************************************************************
I am trying to use the following expression to establish the default
value for a parameter:
="SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('" & User!UserID
& "', 6, LEN('" & User!UserID & "') - 5))"
The User!UserID resolves as the domain\username or "AERO\username"
When I run the report with this expression in the default value of the
parameter, I get the error:
An unexpected error occurred in Report Processing.
Input string was in the wrong format.
I can use the following query in SQL Query Analyzer to successfully
return all records (or a specific record if I substitute an actual
username).
SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('Aero\' +
UserName, 6, LEN('Aero\' + UserName) - 5))
The return value DefLib is type Int... The value field for the
parameter is also an integer. Why would I receive this error if the
datatypes are the same?
TIA,
FerdBump - Anyone have any ideas?
Ferd Biffle wrote:
> I posted this last week, and no one answered :-( If at first you don't
> succeed...
> ************************************************************
> I am trying to use the following expression to establish the default
> value for a parameter:
> ="SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('" & User!UserID
> & "', 6, LEN('" & User!UserID & "') - 5))"
> The User!UserID resolves as the domain\username or "AERO\username"
> When I run the report with this expression in the default value of the
> parameter, I get the error:
> An unexpected error occurred in Report Processing.
> Input string was in the wrong format.
> I can use the following query in SQL Query Analyzer to successfully
> return all records (or a specific record if I substitute an actual
> username).
> SELECT DefLib FROM Users WHERE (UserName = SUBSTRING('Aero\' +
> UserName, 6, LEN('Aero\' + UserName) - 5))
> The return value DefLib is type Int... The value field for the
> parameter is also an integer. Why would I receive this error if the
> datatypes are the same?
> TIA,
> Ferd