Viewing 15 posts - 76 through 90 (of 219 total)
I agree with Will. When time is required in your warehouse, it's best to split this into it's own dimension.
November 17, 2008 at 5:47 am
You can use either a list or rectangle to accomplish this. Both give you control over positioning of data in the report.
November 4, 2008 at 5:51 am
If your two columns are DebitAmt and Credit Amt and this is displaying in the details section of the report, you could use =RunningValues(Fields!DebitAmt.Value - Fields!CreditAmt.Value, Sum, nothing) as the...
October 27, 2008 at 5:39 am
You can't update this field through Report Manager. If you have a custom site though for creating subscriptions, you can change this field.
October 24, 2008 at 7:23 am
Did you yerify your server IP address and that you have permissions on the server? Also make sure you have the from: field set in the task.
September 17, 2008 at 6:27 am
No, this is not customizable. You're very limited on what you can do in the report viewer window.
September 16, 2008 at 5:30 am
My experience on this agrees with what Michael said. I had 16 feeds coming and and then tried to load these to the same table. At times it...
September 16, 2008 at 4:18 am
Assuming you're doing this in SSIS, drag a Send Mail Task onto the Control Flow. Double click on it to open the editor and select Mail in the left...
September 16, 2008 at 4:14 am
SSIS is a very robust tool and there's way too much to cover in an article on how to design and deploy packages. My best suggestion is if you...
September 16, 2008 at 4:03 am
Have you considered moving to SQL Server 20008 for the Report Server? It is no longer restricted by memory and on initial tests I've run, I've been able to...
September 4, 2008 at 7:02 am
You need to reduce the size of the body, plus any margins you have defined in the report properties, to be less than or eqal to the size of the...
August 26, 2008 at 6:31 am
There's an article here that may help... http://www.sqlservercentral.com/articles/Integration+Services/61714/
August 26, 2008 at 6:24 am
Yes, SSIS packages can be a source for a SSRS report. There's an MS article here on the subject http://msdn.microsoft.com/en-us/library/ms345250.aspx.
August 26, 2008 at 6:21 am
Have you tried setting the group to Page Break at Start rather than Page Break at End? This may cause you issues at the beginning of the report though...
August 15, 2008 at 5:53 am
You can change some settings (including your email settings) by going to Microsoft Sql Server 2005 -> Configuration Tools -> Reporting Services Configuration and the clicking on Email Settings.
Dave
August 12, 2008 at 6:10 am
Viewing 15 posts - 76 through 90 (of 219 total)