link target

I have some 'go to' links and 'back to' links in my report. I want the 'go
to' links displays reports in new window and 'back to' links displays the
reports in same window. any idea?You can use javascript in the Jump to URL option of the Action property, so
you can include something like this:
= "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
to open a report in a new window. You can use similar stuff to navagate to
a report in the same window. Hope this helps.
David
"sun" wrote:
> I have some 'go to' links and 'back to' links in my report. I want the 'go
> to' links displays reports in new window and 'back to' links displays the
> reports in same window. any idea?|||Hi,
I have the same problem :(
I want the hyperlinks in my report to open in a new window. I tried doing
this:
in Advanced->Navigation->JumptoURL of the textbox displaying the hyperlink,
I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work - even
the javascript doesnt work :(
plz help
thanks.
"David Siebert" wrote:
> You can use javascript in the Jump to URL option of the Action property, so
> you can include something like this:
> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> to open a report in a new window. You can use similar stuff to navagate to
> a report in the same window. Hope this helps.
> David
> "sun" wrote:
> > I have some 'go to' links and 'back to' links in my report. I want the 'go
> > to' links displays reports in new window and 'back to' links displays the
> > reports in same window. any idea?|||Try a simple test ...
="javascript:void(window.open('http://www.google.com',
'_blank'))"
<Action>
<Hyperlink>="javascript:void(window.open('http://www.google.com',
'_blank'))"</Hyperlink>
</Action>
"Aravind" <Aravind@.discussions.microsoft.com> wrote in message
news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> Hi,
> I have the same problem :(
> I want the hyperlinks in my report to open in a new window. I tried doing
> this:
> in Advanced->Navigation->JumptoURL of the textbox displaying the
> hyperlink,
> I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> even
> the javascript doesnt work :(
> plz help
> thanks.
> "David Siebert" wrote:
>> You can use javascript in the Jump to URL option of the Action property,
>> so
>> you can include something like this:
>> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
>> to open a report in a new window. You can use similar stuff to navagate
>> to
>> a report in the same window. Hope this helps.
>> David
>> "sun" wrote:
>> > I have some 'go to' links and 'back to' links in my report. I want the
>> > 'go
>> > to' links displays reports in new window and 'back to' links displays
>> > the
>> > reports in same window. any idea?|||Thank you very much. This worked perfect
"steve kwon" wrote:
> Try a simple test ...
> ="javascript:void(window.open('http://www.google.com',
> '_blank'))"
>
> <Action>
> <Hyperlink>="javascript:void(window.open('http://www.google.com',
> '_blank'))"</Hyperlink>
> </Action>
>
> "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > Hi,
> > I have the same problem :(
> > I want the hyperlinks in my report to open in a new window. I tried doing
> > this:
> > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > hyperlink,
> > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > even
> > the javascript doesnt work :(
> > plz help
> > thanks.
> >
> > "David Siebert" wrote:
> >
> >> You can use javascript in the Jump to URL option of the Action property,
> >> so
> >> you can include something like this:
> >>
> >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> >>
> >> to open a report in a new window. You can use similar stuff to navagate
> >> to
> >> a report in the same window. Hope this helps.
> >>
> >> David
> >>
> >> "sun" wrote:
> >>
> >> > I have some 'go to' links and 'back to' links in my report. I want the
> >> > 'go
> >> > to' links displays reports in new window and 'back to' links displays
> >> > the
> >> > reports in same window. any idea?
>
>|||Hi steve,
I too have a similar requirement, where in when i click on the image in the
report,it should navigate to the url given in the expression.
I have given
="javascript:void(window.open('http://www.google.com','_blank'))" in the
expression.
But what happens is,a new window is opened with "Page cannot be diaplayed"
and the javascript is pasted on to the addres bar of the the browser.And once
we press the enter key, the page loads successfully.What could be the reason
for such an behaviour.Any settings that i have to explicitly make to get this
working.
I have tried looking almost everywhere and this is the solution that they
have suggested.But then it just doesnt work fime with me.
Any inputs on this would be of great help to me.
waiting for your reply,
Many Thanks,
Archana
"steve kwon" wrote:
> Try a simple test ...
> ="javascript:void(window.open('http://www.google.com',
> '_blank'))"
>
> <Action>
> <Hyperlink>="javascript:void(window.open('http://www.google.com',
> '_blank'))"</Hyperlink>
> </Action>
>
> "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > Hi,
> > I have the same problem :(
> > I want the hyperlinks in my report to open in a new window. I tried doing
> > this:
> > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > hyperlink,
> > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > even
> > the javascript doesnt work :(
> > plz help
> > thanks.
> >
> > "David Siebert" wrote:
> >
> >> You can use javascript in the Jump to URL option of the Action property,
> >> so
> >> you can include something like this:
> >>
> >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> >>
> >> to open a report in a new window. You can use similar stuff to navagate
> >> to
> >> a report in the same window. Hope this helps.
> >>
> >> David
> >>
> >> "sun" wrote:
> >>
> >> > I have some 'go to' links and 'back to' links in my report. I want the
> >> > 'go
> >> > to' links displays reports in new window and 'back to' links displays
> >> > the
> >> > reports in same window. any idea?
>
>|||Hi Steve,
Please also note that ,Javascript works fine in the report.That is when i
try opening the report using the report manager /reportserver it works
fine.When i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi steve,
> I too have a similar requirement, where in when i click on the image in the
> report,it should navigate to the url given in the expression.
> I have given
> ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> expression.
> But what happens is,a new window is opened with "Page cannot be diaplayed"
> and the javascript is pasted on to the addres bar of the the browser.And once
> we press the enter key, the page loads successfully.What could be the reason
> for such an behaviour.Any settings that i have to explicitly make to get this
> working.
> I have tried looking almost everywhere and this is the solution that they
> have suggested.But then it just doesnt work fime with me.
> Any inputs on this would be of great help to me.
> waiting for your reply,
> Many Thanks,
> Archana
>
> "steve kwon" wrote:
> > Try a simple test ...
> >
> > ="javascript:void(window.open('http://www.google.com',
> > '_blank'))"
> >
> >
> > <Action>
> >
> > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > '_blank'))"</Hyperlink>
> >
> > </Action>
> >
> >
> > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > Hi,
> > > I have the same problem :(
> > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > this:
> > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > hyperlink,
> > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > even
> > > the javascript doesnt work :(
> > > plz help
> > > thanks.
> > >
> > > "David Siebert" wrote:
> > >
> > >> You can use javascript in the Jump to URL option of the Action property,
> > >> so
> > >> you can include something like this:
> > >>
> > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > >>
> > >> to open a report in a new window. You can use similar stuff to navagate
> > >> to
> > >> a report in the same window. Hope this helps.
> > >>
> > >> David
> > >>
> > >> "sun" wrote:
> > >>
> > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > >> > 'go
> > >> > to' links displays reports in new window and 'back to' links displays
> > >> > the
> > >> > reports in same window. any idea?
> >
> >
> >|||Hi steve,
My problem got solved.It works fine now.There was a problem with my
sharepoint page and not the script.
Thanks for all the help
Regards
Archana
"Archana" wrote:
> Hi Steve,
> Please also note that ,Javascript works fine in the report.That is when i
> try opening the report using the report manager /reportserver it works
> fine.When i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> >
> > Hi steve,
> >
> > I too have a similar requirement, where in when i click on the image in the
> > report,it should navigate to the url given in the expression.
> >
> > I have given
> > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > expression.
> >
> > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > and the javascript is pasted on to the addres bar of the the browser.And once
> > we press the enter key, the page loads successfully.What could be the reason
> > for such an behaviour.Any settings that i have to explicitly make to get this
> > working.
> >
> > I have tried looking almost everywhere and this is the solution that they
> > have suggested.But then it just doesnt work fime with me.
> >
> > Any inputs on this would be of great help to me.
> >
> > waiting for your reply,
> > Many Thanks,
> > Archana
> >
> >
> > "steve kwon" wrote:
> >
> > > Try a simple test ...
> > >
> > > ="javascript:void(window.open('http://www.google.com',
> > > '_blank'))"
> > >
> > >
> > > <Action>
> > >
> > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > '_blank'))"</Hyperlink>
> > >
> > > </Action>
> > >
> > >
> > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > Hi,
> > > > I have the same problem :(
> > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > this:
> > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > hyperlink,
> > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > even
> > > > the javascript doesnt work :(
> > > > plz help
> > > > thanks.
> > > >
> > > > "David Siebert" wrote:
> > > >
> > > >> You can use javascript in the Jump to URL option of the Action property,
> > > >> so
> > > >> you can include something like this:
> > > >>
> > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > >>
> > > >> to open a report in a new window. You can use similar stuff to navagate
> > > >> to
> > > >> a report in the same window. Hope this helps.
> > > >>
> > > >> David
> > > >>
> > > >> "sun" wrote:
> > > >>
> > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > >> > 'go
> > > >> > to' links displays reports in new window and 'back to' links displays
> > > >> > the
> > > >> > reports in same window. any idea?
> > >
> > >
> > >|||Hello, what was the problem with your sharepoint site exactly? I am just
using the reportserver with the javascript included, and was working just
fine, in many of my reports' action properties. Then one day they all just
stopped working. Perhaps there is a setting that has been changed by some
other install/update to the machine' thanks!
"Archana" wrote:
> Hi steve,
> My problem got solved.It works fine now.There was a problem with my
> sharepoint page and not the script.
> Thanks for all the help
> Regards
> Archana
>
> "Archana" wrote:
> > Hi Steve,
> > Please also note that ,Javascript works fine in the report.That is when i
> > try opening the report using the report manager /reportserver it works
> > fine.When i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Hi steve,
> > >
> > > I too have a similar requirement, where in when i click on the image in the
> > > report,it should navigate to the url given in the expression.
> > >
> > > I have given
> > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > expression.
> > >
> > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > we press the enter key, the page loads successfully.What could be the reason
> > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > working.
> > >
> > > I have tried looking almost everywhere and this is the solution that they
> > > have suggested.But then it just doesnt work fime with me.
> > >
> > > Any inputs on this would be of great help to me.
> > >
> > > waiting for your reply,
> > > Many Thanks,
> > > Archana
> > >
> > >
> > > "steve kwon" wrote:
> > >
> > > > Try a simple test ...
> > > >
> > > > ="javascript:void(window.open('http://www.google.com',
> > > > '_blank'))"
> > > >
> > > >
> > > > <Action>
> > > >
> > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > '_blank'))"</Hyperlink>
> > > >
> > > > </Action>
> > > >
> > > >
> > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > Hi,
> > > > > I have the same problem :(
> > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > this:
> > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > hyperlink,
> > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > even
> > > > > the javascript doesnt work :(
> > > > > plz help
> > > > > thanks.
> > > > >
> > > > > "David Siebert" wrote:
> > > > >
> > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > >> so
> > > > >> you can include something like this:
> > > > >>
> > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > >>
> > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > >> to
> > > > >> a report in the same window. Hope this helps.
> > > > >>
> > > > >> David
> > > > >>
> > > > >> "sun" wrote:
> > > > >>
> > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > >> > 'go
> > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > >> > the
> > > > >> > reports in same window. any idea?
> > > >
> > > >
> > > >|||Hi,
The prerequisite to get the javascript working is you need to have SP1
installed.
And in my case i was trying to include the report in a page viewer web part.
There were 3 frames in my SP page and 2 webparts.I was just not setting the
src property for the web part correctly.But other wise
="javascript:void(window.open('http://www.google.com','_blank'))" javascript
just works fine.
Please make sure you have SP1 update installed on your s/m to get it working.
Thanks !
Archana
"dcray" wrote:
> Hello, what was the problem with your sharepoint site exactly? I am just
> using the reportserver with the javascript included, and was working just
> fine, in many of my reports' action properties. Then one day they all just
> stopped working. Perhaps there is a setting that has been changed by some
> other install/update to the machine' thanks!
> "Archana" wrote:
> > Hi steve,
> >
> > My problem got solved.It works fine now.There was a problem with my
> > sharepoint page and not the script.
> >
> > Thanks for all the help
> >
> > Regards
> > Archana
> >
> >
> > "Archana" wrote:
> >
> > > Hi Steve,
> > > Please also note that ,Javascript works fine in the report.That is when i
> > > try opening the report using the report manager /reportserver it works
> > > fine.When i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Hi steve,
> > > >
> > > > I too have a similar requirement, where in when i click on the image in the
> > > > report,it should navigate to the url given in the expression.
> > > >
> > > > I have given
> > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > expression.
> > > >
> > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > we press the enter key, the page loads successfully.What could be the reason
> > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > working.
> > > >
> > > > I have tried looking almost everywhere and this is the solution that they
> > > > have suggested.But then it just doesnt work fime with me.
> > > >
> > > > Any inputs on this would be of great help to me.
> > > >
> > > > waiting for your reply,
> > > > Many Thanks,
> > > > Archana
> > > >
> > > >
> > > > "steve kwon" wrote:
> > > >
> > > > > Try a simple test ...
> > > > >
> > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > '_blank'))"
> > > > >
> > > > >
> > > > > <Action>
> > > > >
> > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > '_blank'))"</Hyperlink>
> > > > >
> > > > > </Action>
> > > > >
> > > > >
> > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > Hi,
> > > > > > I have the same problem :(
> > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > this:
> > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > hyperlink,
> > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > even
> > > > > > the javascript doesnt work :(
> > > > > > plz help
> > > > > > thanks.
> > > > > >
> > > > > > "David Siebert" wrote:
> > > > > >
> > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > >> so
> > > > > >> you can include something like this:
> > > > > >>
> > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > >>
> > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > >> to
> > > > > >> a report in the same window. Hope this helps.
> > > > > >>
> > > > > >> David
> > > > > >>
> > > > > >> "sun" wrote:
> > > > > >>
> > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > >> > 'go
> > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > >> > the
> > > > > >> > reports in same window. any idea?
> > > > >
> > > > >
> > > > >|||Thanks for the reply. Yes, I had to install SP1 in order to get it working
in the first place, which it was working just fine for awhile anyway.
"Archana" wrote:
> Hi,
> The prerequisite to get the javascript working is you need to have SP1
> installed.
> And in my case i was trying to include the report in a page viewer web part.
> There were 3 frames in my SP page and 2 webparts.I was just not setting the
> src property for the web part correctly.But other wise
> ="javascript:void(window.open('http://www.google.com','_blank'))" javascript
> just works fine.
> Please make sure you have SP1 update installed on your s/m to get it working.
> Thanks !
> Archana
>
>
> "dcray" wrote:
> >
> > Hello, what was the problem with your sharepoint site exactly? I am just
> > using the reportserver with the javascript included, and was working just
> > fine, in many of my reports' action properties. Then one day they all just
> > stopped working. Perhaps there is a setting that has been changed by some
> > other install/update to the machine' thanks!
> >
> > "Archana" wrote:
> >
> > > Hi steve,
> > >
> > > My problem got solved.It works fine now.There was a problem with my
> > > sharepoint page and not the script.
> > >
> > > Thanks for all the help
> > >
> > > Regards
> > > Archana
> > >
> > >
> > > "Archana" wrote:
> > >
> > > > Hi Steve,
> > > > Please also note that ,Javascript works fine in the report.That is when i
> > > > try opening the report using the report manager /reportserver it works
> > > > fine.When i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > >
> > > > "Archana" wrote:
> > > >
> > > > >
> > > > > Hi steve,
> > > > >
> > > > > I too have a similar requirement, where in when i click on the image in the
> > > > > report,it should navigate to the url given in the expression.
> > > > >
> > > > > I have given
> > > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > > expression.
> > > > >
> > > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > > we press the enter key, the page loads successfully.What could be the reason
> > > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > > working.
> > > > >
> > > > > I have tried looking almost everywhere and this is the solution that they
> > > > > have suggested.But then it just doesnt work fime with me.
> > > > >
> > > > > Any inputs on this would be of great help to me.
> > > > >
> > > > > waiting for your reply,
> > > > > Many Thanks,
> > > > > Archana
> > > > >
> > > > >
> > > > > "steve kwon" wrote:
> > > > >
> > > > > > Try a simple test ...
> > > > > >
> > > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > > '_blank'))"
> > > > > >
> > > > > >
> > > > > > <Action>
> > > > > >
> > > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > > '_blank'))"</Hyperlink>
> > > > > >
> > > > > > </Action>
> > > > > >
> > > > > >
> > > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > > Hi,
> > > > > > > I have the same problem :(
> > > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > > this:
> > > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > > hyperlink,
> > > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > > even
> > > > > > > the javascript doesnt work :(
> > > > > > > plz help
> > > > > > > thanks.
> > > > > > >
> > > > > > > "David Siebert" wrote:
> > > > > > >
> > > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > > >> so
> > > > > > >> you can include something like this:
> > > > > > >>
> > > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > > >>
> > > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > > >> to
> > > > > > >> a report in the same window. Hope this helps.
> > > > > > >>
> > > > > > >> David
> > > > > > >>
> > > > > > >> "sun" wrote:
> > > > > > >>
> > > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > > >> > 'go
> > > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > > >> > the
> > > > > > >> > reports in same window. any idea?
> > > > > >
> > > > > >
> > > > > >|||thanks again for responding to my inquiry. turns out some urls to reports
that were getting passed around used an alias for the machine that wasn't set
up as one of the host headers
"dcray" wrote:
> Thanks for the reply. Yes, I had to install SP1 in order to get it working
> in the first place, which it was working just fine for awhile anyway.
> "Archana" wrote:
> > Hi,
> >
> > The prerequisite to get the javascript working is you need to have SP1
> > installed.
> > And in my case i was trying to include the report in a page viewer web part.
> > There were 3 frames in my SP page and 2 webparts.I was just not setting the
> > src property for the web part correctly.But other wise
> > ="javascript:void(window.open('http://www.google.com','_blank'))" javascript
> > just works fine.
> >
> > Please make sure you have SP1 update installed on your s/m to get it working.
> >
> > Thanks !
> > Archana
> >
> >
> >
> >
> > "dcray" wrote:
> >
> > >
> > > Hello, what was the problem with your sharepoint site exactly? I am just
> > > using the reportserver with the javascript included, and was working just
> > > fine, in many of my reports' action properties. Then one day they all just
> > > stopped working. Perhaps there is a setting that has been changed by some
> > > other install/update to the machine' thanks!
> > >
> > > "Archana" wrote:
> > >
> > > > Hi steve,
> > > >
> > > > My problem got solved.It works fine now.There was a problem with my
> > > > sharepoint page and not the script.
> > > >
> > > > Thanks for all the help
> > > >
> > > > Regards
> > > > Archana
> > > >
> > > >
> > > > "Archana" wrote:
> > > >
> > > > > Hi Steve,
> > > > > Please also note that ,Javascript works fine in the report.That is when i
> > > > > try opening the report using the report manager /reportserver it works
> > > > > fine.When i click the link, the page ('google') gets loaded.
> > > > >
> > > > > But when i include the same report in my sharepoint site ,using the page
> > > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > > >
> > > > > Any idea why this behaviour?
> > > > > Many thanks inadvance,
> > > > > Regards,
> > > > > Archana
> > > > >
> > > > > "Archana" wrote:
> > > > >
> > > > > >
> > > > > > Hi steve,
> > > > > >
> > > > > > I too have a similar requirement, where in when i click on the image in the
> > > > > > report,it should navigate to the url given in the expression.
> > > > > >
> > > > > > I have given
> > > > > > ="javascript:void(window.open('http://www.google.com','_blank'))" in the
> > > > > > expression.
> > > > > >
> > > > > > But what happens is,a new window is opened with "Page cannot be diaplayed"
> > > > > > and the javascript is pasted on to the addres bar of the the browser.And once
> > > > > > we press the enter key, the page loads successfully.What could be the reason
> > > > > > for such an behaviour.Any settings that i have to explicitly make to get this
> > > > > > working.
> > > > > >
> > > > > > I have tried looking almost everywhere and this is the solution that they
> > > > > > have suggested.But then it just doesnt work fime with me.
> > > > > >
> > > > > > Any inputs on this would be of great help to me.
> > > > > >
> > > > > > waiting for your reply,
> > > > > > Many Thanks,
> > > > > > Archana
> > > > > >
> > > > > >
> > > > > > "steve kwon" wrote:
> > > > > >
> > > > > > > Try a simple test ...
> > > > > > >
> > > > > > > ="javascript:void(window.open('http://www.google.com',
> > > > > > > '_blank'))"
> > > > > > >
> > > > > > >
> > > > > > > <Action>
> > > > > > >
> > > > > > > <Hyperlink>="javascript:void(window.open('http://www.google.com',
> > > > > > > '_blank'))"</Hyperlink>
> > > > > > >
> > > > > > > </Action>
> > > > > > >
> > > > > > >
> > > > > > > "Aravind" <Aravind@.discussions.microsoft.com> wrote in message
> > > > > > > news:95FC9656-3EC4-49A3-AB75-7881EF58CA07@.microsoft.com...
> > > > > > > > Hi,
> > > > > > > > I have the same problem :(
> > > > > > > > I want the hyperlinks in my report to open in a new window. I tried doing
> > > > > > > > this:
> > > > > > > > in Advanced->Navigation->JumptoURL of the textbox displaying the
> > > > > > > > hyperlink,
> > > > > > > > I added "http://-the url"&" rc:LinkTarget=_blank" but it doesnt work -
> > > > > > > > even
> > > > > > > > the javascript doesnt work :(
> > > > > > > > plz help
> > > > > > > > thanks.
> > > > > > > >
> > > > > > > > "David Siebert" wrote:
> > > > > > > >
> > > > > > > >> You can use javascript in the Jump to URL option of the Action property,
> > > > > > > >> so
> > > > > > > >> you can include something like this:
> > > > > > > >>
> > > > > > > >> = "javascript:void(window.open('" & Fields!url.Value & "','_blank'))"
> > > > > > > >>
> > > > > > > >> to open a report in a new window. You can use similar stuff to navagate
> > > > > > > >> to
> > > > > > > >> a report in the same window. Hope this helps.
> > > > > > > >>
> > > > > > > >> David
> > > > > > > >>
> > > > > > > >> "sun" wrote:
> > > > > > > >>
> > > > > > > >> > I have some 'go to' links and 'back to' links in my report. I want the
> > > > > > > >> > 'go
> > > > > > > >> > to' links displays reports in new window and 'back to' links displays
> > > > > > > >> > the
> > > > > > > >> > reports in same window. any idea?
> > > > > > >
> > > > > > >
> > > > > > >sql

Link Reports to System.Data.DataSets?

The mechanism to link a Crystal Report to data is by giving it a
System.Data.DataSet, I was wondering if this same option is possible in
Reporting Services.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!Today you have to create a data processing extension. In the future
(Widbey/Yukon) there will be a webform control and winform control that
would allow this. If you don't want to create a data processing extension
then the dataset needs to be generated from RS (either embed the SQL or call
a stored procedure). I suggest first looking at using RS without a data
processing extension and make sure you understand RS capabilities then if
you decide you have to do it with a data processing extension.
Remember, RS is a different architecture than Crystal so there will be
plenty of places where you need to approach things differently.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> The mechanism to link a Crystal Report to data is by giving it a
> System.Data.DataSet, I was wondering if this same option is possible in
> Reporting Services.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
>|||Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can be rendered from data tha only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||uhh... I meant:
Thank you. The point is that not allowing to generate the reports from a
system.data.DataSet mean that reports can't be rendered from data that only
exists in memory and this is something that Crystal allows and that one of
my customers supposedly needs.
--
Sergio Florez M.
Miembro activo de www.alianzadev.net
Medellín, Colombia.
El que persevera insiste!!!
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or
call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>|||Well, you can do it, it is just more complex, version 2 this will be much
simplier.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
news:OPn72Nn0EHA.2192@.TK2MSFTNGP14.phx.gbl...
> uhh... I meant:
> Thank you. The point is that not allowing to generate the reports from a
> system.data.DataSet mean that reports can't be rendered from data that
only
> exists in memory and this is something that Crystal allows and that one of
> my customers supposedly needs.
> --
> Sergio Florez M.
> Miembro activo de www.alianzadev.net
> Medellín, Colombia.
> El que persevera insiste!!!
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uFuZgEn0EHA.1404@.TK2MSFTNGP11.phx.gbl...
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing
extension
> > then the dataset needs to be generated from RS (either embed the SQL or
> call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then
if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible
in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
>|||Hi
I am not sure that I fully understand your suggestions. I have an ASP.NET
application that uses a web form to update an XML dataset. I would like to be
able to produce a report from the dataset and ideally I would like to
serialize it and pass it as a data source to an RS web service but RS does
not seem to support this. I could serialise and persist to SQL Server as a
single ntext field that could then be queried to return a complete XML
document. Again RS does not seem to handle this. I do not wish to create a
full set of SQL Server tables to persist the dataset at the field level just
to produce the report (there are rather a lot of items).
You indicated that a "data processing extension" might help with this. Could
you possibly expand a little more or point me in the right direction?
Thanks
"Bruce L-C [MVP]" wrote:
> Today you have to create a data processing extension. In the future
> (Widbey/Yukon) there will be a webform control and winform control that
> would allow this. If you don't want to create a data processing extension
> then the dataset needs to be generated from RS (either embed the SQL or call
> a stored procedure). I suggest first looking at using RS without a data
> processing extension and make sure you understand RS capabilities then if
> you decide you have to do it with a data processing extension.
> Remember, RS is a different architecture than Crystal so there will be
> plenty of places where you need to approach things differently.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > The mechanism to link a Crystal Report to data is by giving it a
> > System.Data.DataSet, I was wondering if this same option is possible in
> > Reporting Services.
> >
> > --
> > Sergio Florez M.
> > Miembro activo de www.alianzadev.net
> > Medellín, Colombia.
> > El que persevera insiste!!!
> >
> >
>
>|||I have had some further thoughts and I would be interested to know if the
following approach might work:
1. Create a web-service report that accepts a string parameter and uses a
stored procedure as a data source to which it passess the parameter.
2. Write the stored procedure to accept a parameter of type ntext which it
passes to sp_xml_preparedocument and then generates the required output using
OPENXML().
3. From the asp.net application, serialise the xml from the dataset as a
string and pass as a parameter to the web-service report.
Thanks
"njr" wrote:
> Hi
> I am not sure that I fully understand your suggestions. I have an ASP.NET
> application that uses a web form to update an XML dataset. I would like to be
> able to produce a report from the dataset and ideally I would like to
> serialize it and pass it as a data source to an RS web service but RS does
> not seem to support this. I could serialise and persist to SQL Server as a
> single ntext field that could then be queried to return a complete XML
> document. Again RS does not seem to handle this. I do not wish to create a
> full set of SQL Server tables to persist the dataset at the field level just
> to produce the report (there are rather a lot of items).
> You indicated that a "data processing extension" might help with this. Could
> you possibly expand a little more or point me in the right direction?
> Thanks
> "Bruce L-C [MVP]" wrote:
> > Today you have to create a data processing extension. In the future
> > (Widbey/Yukon) there will be a webform control and winform control that
> > would allow this. If you don't want to create a data processing extension
> > then the dataset needs to be generated from RS (either embed the SQL or call
> > a stored procedure). I suggest first looking at using RS without a data
> > processing extension and make sure you understand RS capabilities then if
> > you decide you have to do it with a data processing extension.
> >
> > Remember, RS is a different architecture than Crystal so there will be
> > plenty of places where you need to approach things differently.
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Sergio Florez M." <sergioflorezm @. hotmail.com> wrote in message
> > news:OVi4gvm0EHA.4028@.TK2MSFTNGP15.phx.gbl...
> > > The mechanism to link a Crystal Report to data is by giving it a
> > > System.Data.DataSet, I was wondering if this same option is possible in
> > > Reporting Services.
> > >
> > > --
> > > Sergio Florez M.
> > > Miembro activo de www.alianzadev.net
> > > Medellín, Colombia.
> > > El que persevera insiste!!!
> > >
> > >
> >
> >
> >

link reports

can i jump from one table to other table like navigation other reportNot sure exactly what you mean?
You can set hyperlinks to jump to other reports or url's.
Right click the cell you want the link on, choose Properties then
Navigation tab. Here you have a few options!
--
Regards
Chris
NAVIN.D wrote:
> can i jump from one table to other table like navigation other report|||within one .rdl file i might have 3 to 10, tables[or different reports],
intial it shows first report and we will have an link table to left,and i
sould be able from one report to other within that page.
"Chris McGuigan" wrote:
> Not sure exactly what you mean?
> You can set hyperlinks to jump to other reports or url's.
> Right click the cell you want the link on, choose Properties then
> Navigation tab. Here you have a few options!
> --
> Regards
> Chris
> NAVIN.D wrote:
> > can i jump from one table to other table like navigation other report
>sql

Link Report Problems

I have established a set of base reports which are then linked to a variety of department specific folders. Moreover, many of the reports have the capability to "Drill Through". The problem occurs when clicking on a Drill Through field in one of the department specfic folder -- it directs the drill through to a report in the Base folder instead of the department specific folder. Pleaseeeeee help!The behavior you are seeing is the expected behavior for linked reports. Relative paths are resolved based on the location of the source report, and not the linked report.|||Hopefully in a future release there could be an option to select either base or linked folder(s).

Link Report

I have a report A under FolderA , I created a link report for reportA under Folder B.

I am trying to access the names of the reports under FolderB through ASP.Net web application.

But when I do this the link report name is not being displayed since it has the path \FolderA\ReportA.

But the report is visible in the report manager under folder B. Is there a work around to display the name of the link report.please let me know.

Thanks!!

SqlNew

The link report name "does" appear !! it was problem with refresh.

Link directly to PDF version?

I'd like to be able to give users a link that will take them directly to
the PDF version of a report without ever seeing the interactive reports
server pages or having to use the export command manually. The PDF would
have to be freshly generated each time, rather than simply linking to
the PDF output from a subscription delivery.
Is this possible?Yes by using the Format command set to PDF, e.g.:
http://servername/reportserver?/SampleReports/Company
Sales&rs:Format=PDF&rs:Command=Render
If you want to avoid report session caching and generate the report anew
with each user requests, append rs:ClearSession=true to the URL link.
--
Hope this helps.
---
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
http://www.prologika.com
"JC Ford" <johncford@.hotmail.com> wrote in message
news:OGb6H15fEHA.1048@.tk2msftngp13.phx.gbl...
> I'd like to be able to give users a link that will take them directly to
> the PDF version of a report without ever seeing the interactive reports
> server pages or having to use the export command manually. The PDF would
> have to be freshly generated each time, rather than simply linking to
> the PDF output from a subscription delivery.
> Is this possible?sql

Line Chart used in Subreport ...

Hi,
I am using a Main report page which has different subreports and depending
on some data selection, I will show different sub reports.
But when I am using a line diagram in a sub report, this report will show
all the time. The same visible expression works fine on a sub report, which
has
only data values on.
Thanks for any help
RichardHi,
I found a solution by my self.
I just modify the database selection (via code) in that way, that the query
will not find data for this graph.
If anybody knows a better way, feel free to let me know .
Ritchie
"Ritchie" wrote:
> Hi,
> I am using a Main report page which has different subreports and depending
> on some data selection, I will show different sub reports.
> But when I am using a line diagram in a sub report, this report will show
> all the time. The same visible expression works fine on a sub report, which
> has
> only data values on.
> Thanks for any help
> Richard

Line chart threshold

I have numerous reports generating line charts. I would like to have
one more line added to the graphs set to a static value to show what
the threshold would be. I have tried drawing a line on the chart and
this works in BIDS preview, but it does not appear when I publish the
report. Any suggestions on a better way to do this? I have also
tried adding a field with a static value to the dataset, but it draws
the line multiple times and shows multiple instances of the value in
the legend.On Mar 4, 2:03 am, Victag <miketagg...@.gmail.com> wrote:
> I have numerous reports generating line charts. I would like to have
> one more line added to the graphs set to a static value to show what
> the threshold would be. I have tried drawing a line on the chart and
> this works in BIDS preview, but it does not appear when I publish the
> report. Any suggestions on a better way to do this? I have also
> tried adding a field with a static value to the dataset, but it draws
> the line multiple times and shows multiple instances of the value in
> the legend.
Add another data value. add at the place where you can see the
original data you are seeing now.
This should work
Thanks
Raj Deep.A|||On Mar 5, 9:45=A0am, RajDeep <rajalap...@.gmail.com> wrote:
> On Mar 4, 2:03 am, Victag <miketagg...@.gmail.com> wrote:
> > I have numerous reports generating line charts. =A0I would like to have
> > one more line added to the graphs set to a static value to show what
> > the threshold would be. =A0I have tried drawing a line on the chart and
> > this works in BIDS preview, but it does not appear when I publish the
> > report. =A0Any suggestions on a better way to do this? =A0I have also
> > tried adding a field with a static value to the dataset, but it draws
> > the line multiple times and shows multiple instances of the value in
> > the legend.
> Add another data value. add at the place where you can see the
> original data you are seeing now.
> This should work
> Thanks
> Raj Deep.A
I tried adding a value to the dataset and putting that value in the
graph, but now I see more than one line in the graph for the value and
it shows multiple times in the legend.

Limiting Export Rendering Options

I have a request to limit the number of rendering options available for
exporting. I know I can limit the options for all reports by modifying the
RSReportServer.config file. But is there a way programmatically to set the
available rendering options for a single report?The config file setting affects all reports. In order to limit the export
for certain reports, you would need to implement your own front end
application for the report server (similar to report manager) and manage the
restrictions on the report level yourself.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Greg Larsen" <GregLarsen@.discussions.microsoft.com> wrote in message
news:A440907D-0EAB-465E-BA5A-73ECA1EFDD72@.microsoft.com...
>I have a request to limit the number of rendering options available for
> exporting. I know I can limit the options for all reports by modifying
> the
> RSReportServer.config file. But is there a way programmatically to set
> the
> available rendering options for a single report?|||where might I find out some information in how to build my own front end?
"Robert Bruckner [MSFT]" wrote:
> The config file setting affects all reports. In order to limit the export
> for certain reports, you would need to implement your own front end
> application for the report server (similar to report manager) and manage the
> restrictions on the report level yourself.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Greg Larsen" <GregLarsen@.discussions.microsoft.com> wrote in message
> news:A440907D-0EAB-465E-BA5A-73ECA1EFDD72@.microsoft.com...
> >I have a request to limit the number of rendering options available for
> > exporting. I know I can limit the options for all reports by modifying
> > the
> > RSReportServer.config file. But is there a way programmatically to set
> > the
> > available rendering options for a single report?
>
>

Limit the total number of reports submitted

I have a machine with 4 physical processors and 16 logical processors. SSRS
allows up to 32 reports to be submitted for processing through subscriptions.
This fails miserably because the machine does not have the memory or
capacity to process this many at a time. Is there a config parameter that
tells SSRS to never submit more than 4 at a time including retries?On Dec 16, 3:18 pm, Earl Newcomer
<EarlNewco...@.discussions.microsoft.com> wrote:
> I have a machine with 4 physical processors and 16 logical processors. SSRS
> allows up to 32 reports to be submitted for processing through subscriptions.
> This fails miserably because the machine does not have the memory or
> capacity to process this many at a time. Is there a config parameter that
> tells SSRS to never submit more than 4 at a time including retries?
This could be a long shot, but you might try limiting the
MaxActiveReqForOneUser parameter normally found in: C:\Program Files
\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
\RSWebApplication.config. If this does not help, you might try
building a custom .NET delivery application/system to limit the number
of reports. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Ed,
You were right on track. The parameter for subscriptions is in the file:
Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportServer\RSReportServer.config.
The parameter is under the <service> tag and is:
<MaxQueueThreads>0</MaxQueueThreads>
The default of 0 seems to allow SSRS to submit up to 2 reports per
recognized logical processor. I set this value to 3 and no more than 3
reports were submitted at a time even though we have 16 logical processors
and 4 physical processors.
Thanks for jogging my memory and sending me on the hunt.
"EMartinez" wrote:
> On Dec 16, 3:18 pm, Earl Newcomer
> <EarlNewco...@.discussions.microsoft.com> wrote:
> > I have a machine with 4 physical processors and 16 logical processors. SSRS
> > allows up to 32 reports to be submitted for processing through subscriptions.
> > This fails miserably because the machine does not have the memory or
> > capacity to process this many at a time. Is there a config parameter that
> > tells SSRS to never submit more than 4 at a time including retries?
>
> This could be a long shot, but you might try limiting the
> MaxActiveReqForOneUser parameter normally found in: C:\Program Files
> \Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
> \RSWebApplication.config. If this does not help, you might try
> building a custom .NET delivery application/system to limit the number
> of reports. Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||On Dec 19, 4:46 pm, Earl Newcomer
<EarlNewco...@.discussions.microsoft.com> wrote:
> Ed,
> You were right on track. The parameter for subscriptions is in the file:
> Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportServer\RSReportServer.config.
> The parameter is under the <service> tag and is:
> <MaxQueueThreads>0</MaxQueueThreads>
> The default of 0 seems to allow SSRS to submit up to 2 reports per
> recognized logical processor. I set this value to 3 and no more than 3
> reports were submitted at a time even though we have 16 logical processors
> and 4 physical processors.
> Thanks for jogging my memory and sending me on the hunt.
> "EMartinez" wrote:
> > On Dec 16, 3:18 pm, Earl Newcomer
> > <EarlNewco...@.discussions.microsoft.com> wrote:
> > > I have a machine with 4 physical processors and 16 logical processors. SSRS
> > > allows up to 32 reports to be submitted for processing through subscriptions.
> > > This fails miserably because the machine does not have the memory or
> > > capacity to process this many at a time. Is there a config parameter that
> > > tells SSRS to never submit more than 4 at a time including retries?
> > This could be a long shot, but you might try limiting the
> > MaxActiveReqForOneUser parameter normally found in: C:\Program Files
> > \Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager
> > \RSWebApplication.config. If this does not help, you might try
> > building a custom .NET delivery application/system to limit the number
> > of reports. Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
Glad you found your solution. Let me know if I can be of further
assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

Limit Report Server Access

All,

I'm looking at the possibility of allowing only certian tasks and reports to be available to users. I want the user to only have so much control...but would like them to be able to run reports, subscribe to reports and be able to use the query builder. We don't want the user to see all of the reports in the organization, just the reports for there specific department. So I don't know that I want them to see the report server itself...but maybe be able to run certian features.

Can this be done?Sure, look up the security section of the Reporting Services books online. This describes RS 2000 http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rswork/htm/rms_security_v1_3hia.asp
There are some changes for Yukon, but only minor, they have to do with the introduction of Report builder.

Thanks
Tudor|||Tudor,

Thanks. I didn't mention that I am using RS 2005. But I don't know if this article adresses what I am looking for. If I can use the existing RS interface that is great. But I didn't want to show items that are not available. So for example, I will have a person log into a sales region and when they go to run reprots they will only see Sales reports. I don't want them to see executive reports in the list. I know I can limit the permissions on the reprot so they get an error, but I'm really trying to make it so they don't see what they can't run.

If not then I need to try and limit what they can do in my code. But them my question is how I can access report builder and subscription via code.

Thanks for the assistance!|||Is there a way to limit reports listed in the Report Viewer based on groups?
For example, Sales can only see Sales reports in the Report Manager. They can't see reports for other divisions, like IT, Directors, HR.|||If a certain user doesn't have READ permissions on a folder, report, datasource, they won't see it returned from the Report server SOAP APIs, not see it in report manager, SQL Management Studio, etc...

The permissions have changed slightly in RS 2005, but there are only additions to support the new features: report builder, models.

Thanks
Tudor|||Tudor,

Thanks for the answer. However, I'm not seeing the expected results.
I have 5 reports. I took away permissions on 1 report and the item still shows in the Report Manager. When I click on it, it only shows me a few properties instead of showing me the report. How can I prevent the report without adequete security from being displayed?

Thanks!|||

Local administrators on the report server machine will get read properties and read/set security on all items.
If you try to access using an account that's not in the local administrators group, you should get no access at all.

Thanks
Tudor

limit parameters

is there anyway to limit the date ranges that a user can enter?
my reports have a start date and end date as parameters and I would
like to limit the date range to 6 months so that a user cannot enter a
huge date range or something and slow down the database.Just build a custom prompting mechanizm on your own web page, validating
user input there , disable built-in param prompts in RDL,
construct a custom URL query string on your own web page , than simply
redirect.
--
Oleg Yevteyev,
San Diego, CA
It is OK to contact me with a contracting opportunity.
"myfirstname"001atgmaildotcom.
Replace "myfirstname" with Oleg.
--
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1142261128.051458.241930@.v46g2000cwv.googlegroups.com...
> is there anyway to limit the date ranges that a user can enter?
> my reports have a start date and end date as parameters and I would
> like to limit the date range to 6 months so that a user cannot enter a
> huge date range or something and slow down the database.
>