Thanks you both for your help. I was able to resolve the SSIS issue.

Regards,

leonie6214

Sean,

I removed the partition and it worked - see revised table below:

IF OBJECT_ID ('tempdb..#Tmp1') IS NOT NULL DROP TABLE #Tmp1 --all transactions + SN

CREATE TABLE #Tmp1(

[SN] [int]...

Sean,

I removed the partition and it worked. I will definitely take a look at this article.

Thanks so much for your help.

Hi Jeff ,

I was able to resolve my sorting issue with your code example.

Thanks so much for your help.

Leonie6214

I am sorry but I was not aware of the rules. However, I did include the table structure w/insert statements; I also attached an excel spreadsheet with the desired output...

See query with groupings below. I have also attached an excel spreadsheet with the sample output.

SELECT

Name as StreetName,

MeterId,

CollectionDate,

CollectionAmount,

SpaceUniqueID as MeterNumber,

Blockface

FROM dbo.CollectionSummaries C WITH(NOLOCK)

JOIN Meters M WITH(NOLOCK) ON M.MeterId =...

Thanks for your help and suggessions.

Your code is very close to resolving my sorting issue. However, I am still having problems getting it to work so I am...

I have already tried the order by clause in the query. It sorts only 1 column in ASC order.

Thank you for your suggession.

Thanks for providing this solution. I will respond and let you know if it works out.

Regards,

leonie6214

The report is showing blank lines that looks like rows. I a doing a count on one of the fields (filepath) and it is also counting and displaying the...

Thank you so much for the information. I will read through the link.

I have never tried matrix report. I am not sure if it would be appropriate for this report, but I will give it a shot.

thx

I tried grouping on division name and I am still getting the value for the entire field (Gas_Usage) instead of the value based on the filter criteria: DivisionName = "Gas".

Thanks Niraj,

The problem is that all the values in these fields are summing up. I need to be able to filter the fields by DivisionName.

How would I filter...

Christophe,

I was able to resolve this issue about a week ago using the an expression similar to yours.

Thanks for responding.

leonie6214