What about indexes on MSDB that are highly fragmented? Like sysjobhistory, index "clust". Do I need to manually reorg or rebuild? I'm not really...

It was in my table properties, I had the wrong dataset name. This was my first SSRS report so I was lost a lot of the times.

I do not want the subreport to print if there is no data. I have a main report that has embedded subreport, the subreport only has one table,...

That is what I would normally do but for this report I am using a Data Viewer Web Part and Web Site Data Sources so I am not actually...

Thanks, I'll start looking at BOL and go from there

Kept experimenting and got this to work:

=IIF(Fields!ColumnName.value=0,"",Fields!ColumnName.value)

Thanks all. It is duplicate data on one page, which I did. I had to send in a paramenter to the subreport for the vehicle #. Once...

Figured it out

I will give it a try.

Thanks, I needed that in a hurry, got bunches of detail reports to do in real short time and research time is soooo limited.

Thanks again:D:D:D

I found the problem.

This problem was only affecting one user. the application name will be blank in Activity Monitor if setting are changed to open new query window...

Checked his laptop and he has full management studio installed. The application name does not show up in activity monitor either. Only him!

Anyone one got any...

Did find one user who was using express, had him log on and checked both users in Activity Monitor. the application name for him was in there as Microsoft...

Not really, he is the only one using Express and nobody else wants it installed.

I am getting the same error only I can execute my package manually and it works fine but when I set it up in a job the job fails: ...

Anyone got a way to get the last excel file using SSIS? I currently have a job that gets the last file in a folder like: ...