Viewing 15 posts - 1,261 through 1,275 (of 2,278 total)
Andy Leonard has a great blog on this subject. Take a look and come back with more questions if you still have any.
http://sqlblog.com/blogs/andy_leonard/archive/2009/01/30/ssis-expression-language-and-variables.aspx
April 26, 2011 at 11:13 am
Have you had a Sharepoint installation done recently? Has SSRS been changed from/to native mode/Sharepoint integrated mode recently?
April 25, 2011 at 12:58 pm
Don't know if this will help. Try putting C0 in the Format property of the textbox.
SSRS has a number of shorthand number formatting codes. C = currency, P...
April 25, 2011 at 12:56 pm
Do you know what industry your companies are in? Are you going to be bulk inserting this data, or is the data coming one at a time from an...
April 25, 2011 at 10:20 am
If you have a good connection to both servers/databases in SSRS you can stick to SSRS.
Make one dataset to be the parameter choice for Agency. Something like
SELECT AgencyID, AgencyName
FROM...
April 25, 2011 at 10:08 am
No a report user does not have to be part of the admin group.
What we did is create a Report Browser group in AD. Then we added...
April 25, 2011 at 9:51 am
I format multiple cells at one time, all the time. Hi-lite all the cells you want to format the same, then go to the properties tab (not the text...
April 25, 2011 at 7:45 am
Ray K (4/22/2011)
WOTD#1: Tee. Gee. Eye. Eff.WOTD#2: Vacation (as in I'm on next week!!! :hehe:)
Don't eat too much Dinosaur BBQ. Have fun.
April 22, 2011 at 7:04 am
I have been using report templates for some time. I didn't know it was possible to make a package template for SSIS. Thanks. You also mention it...
April 22, 2011 at 6:58 am
You can find bits and pieces of the XML disected online, but I have never seen the whole thing. I have read on the MS social/support site that MS...
April 21, 2011 at 10:36 am
Take a look at the reporting services database catalog table. It has pretty much everything you want already. Not in the most usable format, but it is all...
April 21, 2011 at 8:23 am
Brandie Tarvin (4/21/2011)
Kit G (4/20/2011)
Tom.Thomson (4/20/2011)
Brandie Tarvin (4/20/2011)
Terry Low-350996 (4/20/2011)
In a pre-SQL-geek incarnation I managed Food and retail sales at Anchorage International Airport. I had an employee(cashier) who was...
April 21, 2011 at 8:12 am
I was at the SQL Saturday in Boston on 4/2 and Matt Masson did a presentation on SSIS design patterns. He uploaded his presentation to the SQL Saturday site.
http://www.sqlsaturday.com/viewsession.aspx?sat=71&sessionid=3881
Click...
April 20, 2011 at 11:05 am
Build a calendar/date table with all the date variations you can think of
DateID
Date
Day of Week
Calendar Month
Calendar Quarter
Calendar Year
Fiscal Month
Fiscal Quarter
Fiscal Year
and so on.
Once you have it built and populated all...
April 20, 2011 at 8:33 am
Viewing 15 posts - 1,261 through 1,275 (of 2,278 total)