CREATE TABLE dbo.TestAsset(AssetID INT IDENTITY(1,1) PRIMARY KEY, SerialNo VARCHAR(100))

--CREATE Filtered UNIQUE Index to allow multiple records of NULL and Unique non-null values in serialNo column

CREATE UNIQUE NONCLUSTERED INDEX UK_TestAsset_SerialNo

...

I'm on SQL Server 2008 R2

Thanks so much. I'm on SQL Server 2008 and decided to use Filtered Index on that column. However the issue i'm having is that i would like to create a...

I was able to figure out the issue.

In SQL Server 2008:

Right Click on the Y-Axis --> Select Axis Properties -> Select "Enable variable interval"

In SQL Server 2008 R2:

Select Y-Axis -->...

Thanks for the reply.

I've added Column group total and getting the totals correctly when the report is fully expanded. But when collapsed i'm getting the total for X category as...

I figured out that the issue is with case-sensitive. Actually i'm comparing two string variables, VarA and VarB and the values in it are as below

VarA = 'Test'

VarB = 'test'

Since...

Hm..That's good to know. Thanks for sharing it.

Hi,

Just wanted to check if there is any way to achieve this. Thanks a lot in advance for your help!

Thanks,

Thanks Roy! The following fixed the issue.

1.Switched the sqlserver service logon account to ‘Local System’

2.Rebooted the server

3.Switched the sqlserver service logon account to ‘Domain/Account’

4.Rebooted the server

Can you please explain this portion of your message a little bit in detail? " "I cut the data from the outer group and then put that data for the...

Thank you so much!

Hi,

When I elimiate NULL values using WHERE clause in the data set or by creating filter expression, i dont get that subcategory = NULL row on the report. I would...

You are really awesome!! I've never seen this detailed explanation for a question on forum with screenshots. I owe you a lot!

Thanks again!

Restarting the SQL Server service on the initiator side resolved the issue.

Thanks so much everyone for the suggestion!!

Restarting SQL Server service on the initiator side fixed the issue.

Thanks so much everyone!!