Error when alternating background color in table rows

Hi All,

I have a table containing 21 columns. I want to alternate the color on the rows, to make it more radable and nocer to the eye. As such I set the BackgroundColor property on the entire TableRow (so it is applied to every textbox) to the following:

Code Snippet

=iif(RowNumber(nothing)Mod 2,"LightGray","White")

In theory it should work. I checked a few of the texboxes to make sure everything was okay and indeed the BackgroundColor property on each one of them was properly set to the above expression.

When I tried to build the report, I was prompted by 21 errors (one per textbox) stating the following:

[rsCompilerErrorInExpression] The BackgroundColor expression for the textbox 'FIELDNAME' contains an error: [BC30455] Argument not specified for parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart As Object, FalsePart As Object) As Object'.

Obviously the TruePart parameter has been specified ("LightGray" in my expression), so what could be wrong?

Thanks in advance for the help

Idelso

Hello,

Your function is good. Check the spelling of "LightGray". Try "LightGrey".

Regards...|||

Hi asiaindian,

Unfortunately that didnt do the trick. This time around a went with much simpler, one word, color names and still nothing.

The error messages keep popping up.

Code Snippet

=iif(RowNumber(nothing)Mod 2,"Silver","White")

Thanks,

Idelso

|||

Well, I found the solution to the problem, for those of you who might have to face it in the future....it is a very simple fix.

Amazing what a great "compiler" SSRS has (I am being sarcastic for the record).

It so happens that you can enter the expression as previously shown without the system indicating any syntax problem with it. Well, we are wrong, the only way this is going to be built is if you keep a space between your RowNumber function call and the "Mod" call. So the correct format is:

Code Snippet

=iif(RowNumber(nothing) Mod 2, "Silver","White")

(Pay attention to the space between (nothing) and Mod)

Yup, this was the problem.....interesting

Idelso

Error source KDC

I'm getting errors in the W2000 SystemLog containing a error with source
KDC. The description of the alert is:
There are multiple accounts with name MSSQLSvc/TEST-SERVER.didoc.local:1433
of type 10
And guess what? This user doesn't even exist.
The questions are:
what is KDC? and what does this alert mean?
Thanks,
Ruud.Originally posted by Ruud
> I'm getting errors in the W2000 SystemLog containing a error
> with source
> KDC. The description of the alert is:
> There are multiple accounts with name
> MSSQLSvc/TEST-SERVER.didoc.local:1433
> of type 10
> And guess what? This user doesn't even exist.
> The questions are:
> what is KDC? and what does this alert mean?
> Thanks,
> Ruud.
KDC = Key Distirbution Centre ?
--
Posted via http://dbforums.com|||From: Charles Allard -
Date: 03-14-02 02:03
Subject:
----
--
>>
| I am getting the following entry in my system log every 30 minutes.
|
| The description is as follows Event Type: Error Event Source: KDC
| Event Category:
| None Event ID: 11 Date: 1/3/2002 Time: 11:55:18 AM User: N/A
| Computer: SERVER NAME
| Description: There are multiple accounts with name
| MSSQLSvc/SERVERNAME.DOMAINNAME.com:1232 of type 10.
|
| In the System log I get this
|
| Event Type: Failure Audit Event Source: Security Event Category:
| Account Logon
| Event ID: 677 Date: 1/3/2002 Time: 12:44:02 PM User: NT
| AUTHORITY\SYSTEM Computer:
| servername Description: Service Ticket Request Failed: User Name:
| ebjsql User
| Domain: EBIZJETS.COM Service Name:
| MSSQLSvc/servername.domainname.com:1232 Ticket
| Options: 0x40810010 Failure Code: 0x7 Client Address: 127.0.0.1
|
| Any ideas on how to solve this would be greatly appreciated.
<<<<<<<<<<< Multiply Accounts with the Domain have been configured as a
SQL Service
account for the Servername server. This causes both service accounts to
have the same
SPN registered.
If the accounts are known then use ADSI (Active Directory Serivces) edit
and remove
then SPN on the account that is no longer used to start the service on
servername. An
approach you can take would be to run LDP.exe (a utility available from
the Windows
2000 resource kit). This utility is documented within the following
articles. I am
also posting possible steps you can take to resolve this using LDP:
Q224543 Using Ldp.exe to Find Data in the Active Directory
http://support.microsoft.com/defaul...b;EN-US;Q224543
Q260745 XADM: Using LDP to Modify Active Directory Object Attributes
http://support.microsoft.com/defaul...b;EN-US;Q260745
Use LDP.EXE to determine the location of the duplicate name:
1. Click Start & select Run.
2. Type LDP and click OK.
3. Click Connection and select Connect.
4. Leaving the Server field blank, click OK.
5. Click Connection and select Bind.
6. Leaving all fields blank, click OK.
7. Click View and select Tree.
8. Set the Base DN as DC=Home, DC=com
9. Click Browse and select Search.
10. Set the Base DN as DC=Home, DC=com.
11. Set the filter as the following:
(serviceprincipalname=HOST/BOT-PC0295.home.com )
12. Set Scope to Subtree.
13. Click Run.
In either case, this indicates that you have a duplicate machine name
registered
within the Active Directory on your domain.
HTH...
Sincerely,
Charles Allard Microsoft SQL Support
--
Posted via http://dbforums.com