Report name (XYZ.rpt) to be printed on the report without the path where its sav

Hi,
Can anyone tell me how to print the name of the report (XYZ.rpt) without the path. In special fields there is a field called "File Path and Name". I need to print only the name and not the path of the report.
If anyone has done this before please let me know.
Thanks,Soething like

select reverse(substring(reverse(path),1,charindex('/',reverse(path),1)-1))

Report must be on one 'screen-page'

We are producing a Matrix report that we want to have on one page. The width of the height is unpredictable.

This report is never printed, only used for browsing of export to excel.

How can we achieve this, w've tried to play with the sizes but this is still 'hardcoded', and setting height and with to 400 makes DevStudio crash, over and over.

Any suggestions ....

With suggestions we mean, on the 'one' page, not for the crash .....

If this is Reporting Services 2005, you can set the Report.InteractiveHeight property to 0 which means unlimited height in interactive renderers (HTML, preview).

-- Robert

|||Works perfect, thx.|||

Hi anyone,

my problem is a bit simillar with harry but we are making a report and when viewing it, we still see one page even how long the report is, I had viewed the XML code and search fot the property Report.InteractiveHeight but I fouond nothing.

Can anyone help me with this? thanks a lot... we need to cut the report in pages.....God Speed

Report header and footer only to appear in printed version

HI

I have a report that I view in Sql 2005 reporting services that contains no header or footer. I do not want these to be displayed in the browser.

I would like to add a header and perhaps footer which will only appear on the printed document but not in the web browser.

Is there any way to accomplish this task?

Thanks

Further to the question posted above, as an alternative ...

Is it possible to view one version of a report and print a different version ?

I am considdering using the ReportViewer control and disabling the print button. Replacing print functionality by putting a link to a second, printable version, of the report and printing it without rendering.

A more elegant approach would be preferred. Any suggestions?