Hi

To count you need to create a field for each category and then you should be able to do a simple sum expression.

so for over 16s you will have an...

Hi,

I think the best way to do this is to use the switch statement. You can place the date formula you have in a cell and then refer...

Sherri Barkley (7/14/2010)

---

I don't write a lot of SSRS reports, but I am trying to create a fairly simple report, but I am having a bit of trouble with thinking...

I'm pretty sure in ssrs 2008 the table object and the tablix object are exactly the same. To create a simple table in 2008 is more cumbersome they have taken...

Was going to ask you whether you were looking at a table or matrix, but was afraid to ask due to fear of sounding silly :hehe:

I think if the reports are hidden and not accessed through report manager you could place them in a certain folder and then just look at the reports in that...

The sql scirpt can be edited to filter the reports as shown below

SELECT Name, Path, UserName

FROM Catalog INNER JOIN dbo.Users ON Catalog.CreatedByID = Users.UserID

--LEFT JOIN C

WHERE Type = 2 AND...

can you not just use the undo button, to take you back a step(s)?

You should be able to edit sql script and filter it down so that it only returns reports which are visible, it should be easier than looking at the data...

Select any of the rows in the table, right click and then click on the detail rows option.

Hi,

Your calculation for the completed field will be something like

=sum(completed_field)

and for the % calculation it will be

=sum(completed_field)/sum(enrolled_field)

if this returns a divide by zero error the formula will...

Hi ,

I think I know what you mean.

The group total would be sum(Fields!Loan_Cat.Value)

The total grand total would be the same expression but you would place it in the...

I am not sure why the extra 2 cells are showing. Have you tried to remove the GTC field and then exported to excel to see what happens. Try removing...

Hi, The field in the cells in EFH needs to be in a single cell in your report. Right click on the cells in designer and split them and then...

Hi, can you provide a screen shot or a copy of the report so I can see what is wrong?