Best place for job posting?

We are looking to place a job posting for a developer experienced in SSIS
and SSRS. Are there any recommendations for the best place to post the job
offer?
thank you,
Bob M..http://jobs.sqlservercentral.com/
"Bob Murdoch" <ram_re_move_5@.erols.com> wrote in message
news:eeG7TzXAIHA.4956@.TK2MSFTNGP06.phx.gbl...
> We are looking to place a job posting for a developer experienced in SSIS
> and SSRS. Are there any recommendations for the best place to post the
> job offer?
> thank you,
> Bob M..
>|||"Dean" <deanl144@.hotmail.com.nospam> wrote:..
> http://jobs.sqlservercentral.com/
>
Thank you for the reply Dean. It looks like there is a grand total of four
job postings on this site, which seems to indicate it may not be one of the
'best' places to post a job offer.
Am I reading the site correctly?
Bob M..

Best parctices in SSRS 2000 reports development

Any ideas or known approaches on how to better develop reports. I have
about 30 Crystal Reports based on stored procedures. Now I need to develop
SSRS 2000 reports. What is the best way to achieve this in terms of layout
development? Is there any kind of a style sheet or templates in SSRS 2000 ?
( many reports look alike, and most of them are just tables, with no charts
or any other complicated structures). From what Iâ've known so far ( I
developed quite a few reports in RS), Iâ'd develop it one by one , changing
all color/font settings for each report individually. Is it possible to do
it in a more sophisticated way?
Any response/ideas would be really appreciated
LenaI'd reccomend figuring out how to do this with SQL Server 2005 instead
of SQL Server 2000.
2005 is a very nice product
Lena wrote:
> Any ideas or known approaches on how to better develop reports. I have
> about 30 Crystal Reports based on stored procedures. Now I need to develop
> SSRS 2000 reports. What is the best way to achieve this in terms of layout
> development? Is there any kind of a style sheet or templates in SSRS 2000 ?
> ( many reports look alike, and most of them are just tables, with no charts
> or any other complicated structures). From what I've known so far ( I
> developed quite a few reports in RS), I'd develop it one by one , changing
> all color/font settings for each report individually. Is it possible to do
> it in a more sophisticated way?
> Any response/ideas would be really appreciated
> Lena

Best Development Machine Configuration Recommendations

What is the best / recommended setup for a development system where you want
to develop using .NET 2.0 using VS 2005 against both SSRS 2000 and SSRS
2005?VS 2005 does not create reports that are compatible with SRS 2000. However,
the SRS 2000 report designer works against both SRS 2000 and 2005.
Thanks
Tudor
"Jim" wrote:
> What is the best / recommended setup for a development system where you want
> to develop using .NET 2.0 using VS 2005 against both SSRS 2000 and SSRS
> 2005?
>
>|||But, and this is important, those reports cannot provide for any of the 2005
features like end user sorting, multi-valued parameters etc.
I suggest installing both development environments. To do this you need VS
2003 and VS 2005. They will install side by side and both be usable (that is
what I have done).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Tudor Trufinescu (MSFT)" <TudorTrufinescuMSFT@.discussions.microsoft.com>
wrote in message news:BEF6807F-D848-4C1E-AC6A-32706D9B8F33@.microsoft.com...
> VS 2005 does not create reports that are compatible with SRS 2000.
> However,
> the SRS 2000 report designer works against both SRS 2000 and 2005.
> Thanks
> Tudor
> "Jim" wrote:
>> What is the best / recommended setup for a development system where you
>> want
>> to develop using .NET 2.0 using VS 2005 against both SSRS 2000 and SSRS
>> 2005?
>>

behavior change in SSRS2005? bring up new IE window at a drillthrough action

Hi,
I just noticed a behavior change from SSRS 2000 (SP2 version) to SSRS
2005 (RTM version).
With SSRS 2000, if I use IE to bring up a report that can drillthrough
to other report, I can right-click at the textbox (where drillthrough
action would take place) to select "Open New Window". It will bring up
the drillthrough report in ANOTHER IE window along with the original
report in the original IE window.
Now with SSRS2005, if I do the same thing, right-click at the textbox
(where drillthrough would take place) does not give me "Open New
Window" selection any more.
Of course, in both cases, a simple click at the textbox would jump to
the drillthrough report which REPLACES the original report in the IE
window. But we really would like to see both reports at the same time.
To reproduce, one can try the sample AdventureWorks reports, open up
"Employee Sales Summary", select December 2003, Syed Abbas, view
report, then try right-click at order number SO58915. The followings
are the actual url (from right-click -> Properties) at the textbox for
drillthrough action.
SSRS2000:
http://kong-dell-4600/Reports$SONATA/Pages/Report.aspx?ServerUrl=http%3a%2f%2fkong-dell-4600%2fReportServer%24SONATA%3f%252fSampleReports%252fSales%2bOrder%2bDetail%26SalesOrderNumber%3dSO5421%26rs%253aParameterLanguage%3d%26rc%253aParameters%3dCollapsed%26rc%253aReplacementRoot%3dhttp%253a%252f%252fkong-dell-4600%252fReports%2524SONATA%252fPages%252fReport.aspx%253fServerUrl%253d
SSRS2005:
http://kong-dell-4600/Reports$MINUET/Reserved.ReportViewerWebControl.axd?ReportSession=nj1154fxuqxsxfn5rwz4wb55&ControlID=a97df556-62d2-4614-a898-ce42b4c28881&Culture=1033&UICulture=9&ReportStack=1&OpType=ReportArea&Controller=ClientControllerctl161&PageNumber=1&ZoomMode=Percent&ZoomPct=100&ReloadDocMap=true&EnableFindNext=False&LinkTarget=_top
Is there any way to bring back the SSRS2000 behavior in SSRS2005?
Any pointers or hints are welcome. Thanks.
KongKong,
Can you use the HTML Device Setting of LinkTarget to open all your
links in a new window? This would eliminate the need to right click at
all.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
Andy Potter|||Hi, Andy,
Thanks for this suggestion.
I think if I write my own application then controlling HTML device
settings as you suggested would be easier.
All of my users are using report manager/report server from IE
directly. So I have to find a way to set LinkTarget to _blank (which
becomes default) in order to create a new window. Based on BOL, I
thought I could modify rsreportserver.config to specify LinkTarget
under Render ... HTML extension. Unfortunately the URL at the textbox
in SSRS 2005 is still http://...&LinkTarget=_top.
Any idea how to set LinkTarget to _blank as default in report
manager/report server config file?
Thanks.
Kong
Potter wrote:
> Kong,
> Can you use the HTML Device Setting of LinkTarget to open all your
> links in a new window? This would eliminate the need to right click at
> all.
> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
> Andy Potter|||Kong,
You can change your navigation to use a 'Jump to URL' and do some
javascript:window.open(blah) expression in the jump to URL. Search the
group, there are a few examples.
Andy Potter|||Here is an example for CSV format. Just remove the rs:Format and rc:Encoding
parts if you are doing HTML (HTML is the default). The
Globals!ReportServerURL allows you to not hardcode the name of your server.
Here is an example of a Jump to URL link I use. This causes Excel to come up
with the data in a separate window:
="javascript:void(window.open('" & Globals!ReportServerUrl &
"?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
"&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
If you don't want to have it appear in a new window then do this in jump to
URL:
=Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<likong@.email.com> wrote in message
news:1137023689.498483.253560@.g14g2000cwa.googlegroups.com...
> Hi, Andy,
> Thanks for this suggestion.
> I think if I write my own application then controlling HTML device
> settings as you suggested would be easier.
> All of my users are using report manager/report server from IE
> directly. So I have to find a way to set LinkTarget to _blank (which
> becomes default) in order to create a new window. Based on BOL, I
> thought I could modify rsreportserver.config to specify LinkTarget
> under Render ... HTML extension. Unfortunately the URL at the textbox
> in SSRS 2005 is still http://...&LinkTarget=_top.
> Any idea how to set LinkTarget to _blank as default in report
> manager/report server config file?
> Thanks.
> Kong
>
> Potter wrote:
>> Kong,
>> Can you use the HTML Device Setting of LinkTarget to open all your
>> links in a new window? This would eliminate the need to right click at
>> all.
>> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
>> Andy Potter
>|||Andy and Bruce, thanks for the great suggestion. It works perfectly.
Thanks.
Kong
Bruce L-C [MVP] wrote:
> Here is an example for CSV format. Just remove the rs:Format and rc:Encoding
> parts if you are doing HTML (HTML is the default). The
> Globals!ReportServerURL allows you to not hardcode the name of your server.
> Here is an example of a Jump to URL link I use. This causes Excel to come up
> with the data in a separate window:
> ="javascript:void(window.open('" & Globals!ReportServerUrl &
> "?/SomeFolder/SomeReport&ParamName=" & Parameters!ParamName.Value &
> "&rs:Format=CSV&rc:Encoding=ASCII','_blank'))"
> If you don't want to have it appear in a new window then do this in jump to
> URL:
> =Globals!ReportServerUrl & "?/SomeFolder/SomeReport&ParamName=" &
> Parameters!ParamName.Value & "&rs:Format=CSV&rc:Encoding=ASCII"
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <likong@.email.com> wrote in message
> news:1137023689.498483.253560@.g14g2000cwa.googlegroups.com...
> > Hi, Andy,
> >
> > Thanks for this suggestion.
> >
> > I think if I write my own application then controlling HTML device
> > settings as you suggested would be easier.
> >
> > All of my users are using report manager/report server from IE
> > directly. So I have to find a way to set LinkTarget to _blank (which
> > becomes default) in order to create a new window. Based on BOL, I
> > thought I could modify rsreportserver.config to specify LinkTarget
> > under Render ... HTML extension. Unfortunately the URL at the textbox
> > in SSRS 2005 is still http://...&LinkTarget=_top.
> >
> > Any idea how to set LinkTarget to _blank as default in report
> > manager/report server config file?
> >
> > Thanks.
> >
> > Kong
> >
> >
> > Potter wrote:
> >> Kong,
> >>
> >> Can you use the HTML Device Setting of LinkTarget to open all your
> >> links in a new window? This would eliminate the need to right click at
> >> all.
> >>
> >> http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsprog/htm/rsp_prog_soapapi_dev_3i49.asp
> >>
> >> Andy Potter
> >