try http://yourip/reports instead of /reportserver

Excel 2003 hat a max dimension of 65'335 Rows x 256 columns

In excel 2007 this has greatly increased, but still not to infinity. I guess that just nobody has reached...

Hi Eddy

Good point, i missed the space in the Check clause. 🙂

best is to go to the field and drag the action you want performed first,

cause the most sum() i...

From your reply I gather that one or the other solution worked out for you.

Make sure that the report area doesn't have a blank space below the matrix in design...

If you want to hide the complete row, then conditionally set the visibility of that row using something like "iif(sum(datacolumn)=0,false,true) "

If its just the 0 that you want to disappear,...

Hi Sing4you

How about grouping by all fields except comment?

Please post some sample-data.

Hi Nemo,

if I understand you right, then the AccountCode can hold multiple AccountNames. In matrix, you can add groupings on both Columns and Rows.

Could you provide some Sample-data?

Hi Keywest,

From what I know the answer is No.

I've ran into the same problem some time ago and ended up writing a custom web-app to handle that.

Hi Nemo,

Given the Fact that your expression displays 0 when there is no data shows, that the IIF-Clause works. Therefore the error must be in the Sum-Clause.

My first suggestion would...

You can also add it by yourself. Imagine that you have an unsorted dataset that consists of two columns.

the Customer Name and the date of the orders that customer has...

Always bear in mind, that when you do a first(), SSRS will show the first record that comes to the Row. Be sure that you know exactly which record that...

If I read your expression correctly, you have just one decision to make with two criteria. For that, the IIF-Function is just fine. But like...

Within Reporting Services you can use Switch instead of Case. Functionality is pretty much the same.

you could create a string-parameter that fills in to the Report.Downside: you need to run the report twice.

or

you could just leave a placeholder and take the detour through excel...

Both...

Hi Paula,

In the Group-Row there are multiple Fields, all that are contained in the details of that group to be exact. The IIF-Clause gets confused because it doesn't know which...