Hi, check the size of the cells in the report designer (development studio) and look at the width size of the cell and then preview, do they preview ok? the...

Not sure about ssrs2008 but with ssrs2005 making the changes should work.

Hi,

You can do this simply in your sql query in the Design tab of your report.

You will need something like

Select * from Table_Cost_Types CT

where

CT.cost_type in

( case when...

Hi, you will need to check the page layout of the report. Menu Report > Report properties > Layout tab and change the page width to 11.27in and height to...

Hi,

Check the status of the subscription for the report in report manager, there should be a row for each subscription.

The status should read something like ' Done: 422...

Hi , you should be able to create a text box for each of the parameters. Right click on the text box select expression and then in the expression window...

Hi,

For the main table edit the properties and insert a page break after the table.

For the totals I would copy your original table and past it below your main...

Hi,

All you need to is select the relevent cell in your table and then in the properties window (press f4 if you can't see it)

under the font heading you will...

It would probably easier just to use the sql command in the report, which would be something like

select * from mytable

where date_of_visit >=

--time element has been stripped out

CONVERT(SMALLDATETIME,CONVERT(VARCHAR(20),getdate(),101)...

No it is a global field and is already there, in the expression window click on globals in the menu and you will see it there.

Hi,

This should be possible.

There is a globals field (=User!UserID) which returns the id for the user who is running the report.

I would first of all place the user...

Thanks for your replies guys.

I agree that creating an extra group for users who need access to other folders makes sense as it is a lot easier to manage in...

I think it is possible but you have to write your own report schedule see the link below;

http://msdn.microsoft.com/en-us/library/aa258073(SQL.80).aspx

HI, I think the reason your query is slow is due to the calculated fields within the main select statement. Try changing the query and use derived tables this should...

Hi,

I think this very much depends on what type of databases you will reporting on in your organization and the reporting requirements.

If most of your databases are sql server...