Viewing 8 posts - 16 through 23 (of 23 total)
Answer:
http://msdn2.microsoft.com/en-us/library/ms190626.aspx
"You cannot reference a synonym that is located on a linked server."
Heigh-ho back to using OPENQUERY...:)
April 1, 2008 at 11:22 pm
Thanks for this, sorry for tardy response, just got back from Xmas hols so will look into this and see how I go, help much appreciated.
January 8, 2008 at 4:00 pm
"Try placinig a scope parameter in your Grand Total Summation. You can take the text from your subtotal and paste it into the grand total, then add the dataset scope"
Yes,...
December 10, 2007 at 4:39 pm
"I think I understand your issue but without being able to see the code behind your Dataset and Also how you have laid out your data in your RDL this...
December 10, 2007 at 4:38 pm
select [the columns] from [the table] where [the date] between StartDate and EndDate ?
September 10, 2007 at 9:34 pm
I don't think that this is possible as SQLS seems to store these templates internally somewhere (anyone know where?). I guess the alternative is to create a new template folder, add...
August 15, 2007 at 12:19 am
I use Ctrl_Alt_T to bring up the template explorer in SQLS 2005 Query Analyzer and can add and modify my templates from there. Is this what you are after ?
August 13, 2007 at 4:12 pm
If you are not worried in what order the parent's names appear and they do not have the same name then this should work 🙂
SELECT
a.[FacilityNum]
,a.facilityID
,a.[FamilyName]
,b.Firstname
,c.Firstname AS other1stname
FROM [Facility] a
INNER...
August 12, 2007 at 8:36 pm
Viewing 8 posts - 16 through 23 (of 23 total)