One more...

You can execute this in the DB where you want to check

execute sp_MSforeachtable @command1= 'select ''?'' TableName,count(*) NumberOfRecords from ?'

Luke you are correct , In the above reply I have pasted the complete script but in this forum it is removing that initial part...

But in the expression of the...

Hi Luke,

This is the full script I have used.

="void window.open('"+Globals!ReportServerUrl+"?"+Globals!ReportFolder+"/"+"MyReport&rs:Command=Render&rc:Parameters=false&ID="+Parameters!ID.Value.ToString()"')"

And as I mentioned this was working with SSRS 2005 , but not in SSRS 2008 🙁

Hi Luke,

Thanks for your reply.

In SSRS 2005 I was doing it like this , so when moved to SSRS 2008 I was trying the same.

And as I'm using the JS...

Hi,

You mean to say the section where you need to pass the default value ?

As it is an integer, can you try giving = sign just infront of the default...

Hi thanks for reply,

What I was trying to use is in the Jump to URL option we can give as

"void window.open('"+Globals!ReportServerUrl+"?"+Globals!ReportFolder+"/"+

but when I tried to use this in SSRS 2008...

Hi thanks for reply.

I know SSRS 2008 has no dependency on IIS , so you mean to say we need to give the report server link http://locahost/reports... ?

In that case...

Hi,

Will the data will be like this always ,how you provided , I mean only two record for one model? If so do like this

1) Insert a table group on...

Hi Lowell,

Could you please explain the steps for 'send mail' in SQL Jobs. Im confused about the SMTP server and I doubt whether I can do this in my...

Hi,

Try this

=iif(Hour(Fields!TOTHR.Value)< 8 , "Red", "White")

This code is in SSRS 2008 , If you are using SSRS 2005 , please check Hour() is there or note, try using some function...

Hi all,

Many thanks for the reply...

Hi Jeff,

I tried to solve this by using CTE, but no luck.. 🙁 . Can I get some more ideas to approach this.

Below is code what I tried.

create table Test...

Hi ,

Could you please try the below thin and let me know,

While running the report , using profile get the parameter values you are passing, then sun the SP separately...

Hi ,

In general to navigate to a report using hyper link,

Rigth Click the cell-->Property-->Navigation . In the Jump to URL section give the expression as

=void window.open('"+Globals!ReportServerUrl+"?"+Globals!ReportFolder+"/"+"Sub&rs:command=render&rc:Parameters=false&sd="+Parameters!sd.Value.ToString()+"')"

here Sub is...

Hi,

Could you please provide the details

1. Name of main report.

2. Screenshot of the property of the cell where you have given the Navigation.(right click the cell-->Property)

3. Expression you have give...