Showing posts with label link. Show all posts
Showing posts with label link. Show all posts

Wednesday, March 28, 2012

ReportViewer AspNetSessionExpiredException

I get a

Microsoft.Reporting.WebForms.AspNetSessionExpiredException: ASP.NET session has expired

immediately when a user clicks the Export link on the ReportViewer. I tested it on two other machines and it works. What would cause this?

I have a similar problem but could not solve it yet (as a matter of fact, did not go deep into it). Here is a post that I posted in MSDN forums, which has some possible solutions. It might solve your problem. If it does, please let me know what you did to solve it.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1357694&SiteID=1

|||

I had the same trouble and the solution of limit MaxWorkingProcesses to 1 commented in that post, solved the problem.

ReportViewer and Click through links

I am creating a .Net application using the ReportViewer, which is working fine.
But when I have a report that has a link to another report, upon clicking
the link it takes the new report to full screen.
What I want to happen is for the new report stay in the ReportViewer.
Any ideas?
--
Regards
<<<Bryan Avery>>Ok I just did this and it was kind of a pain. Too me all day to work it out.
1. You need to use 'Jump to URL' instead of the other options.
2. Open Report Viewer project and add the following code:
Private _linktarget As String = "_self"
<Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
iFrame target")> _
Public Property LinkTarget() As String
Get
Return Me._linktarget
End Get
Set(ByVal Value As String)
Me._linktarget = Value
Me.SetParameter("rc:LinkTarget", Value)
End Set
End Property
3. Recompile and place dll in project bin.
Now the default is _self and you have the option to change the target from
your code.
This solution isn't ideal because you have to use the jump to url which
means more work in creating the url with params, and you may have to hard
code your servername.
--
Message posted via http://www.sqlmonster.com|||Hi Patrick,
Thanks for the quick response, but I'm a little lost to where I should be
entering line 2, could you give me any more pointers please?
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> Ok I just did this and it was kind of a pain. Too me all day to work it out.
> 1. You need to use 'Jump to URL' instead of the other options.
> 2. Open Report Viewer project and add the following code:
> Private _linktarget As String = "_self"
> <Category("HTMLViewer Commands"), Description("Sets rc:linktarget to change
> iFrame target")> _
> Public Property LinkTarget() As String
> Get
> Return Me._linktarget
> End Get
> Set(ByVal Value As String)
> Me._linktarget = Value
> Me.SetParameter("rc:LinkTarget", Value)
> End Set
> End Property
> 3. Recompile and place dll in project bin.
> Now the default is _self and you have the option to change the target from
> your code.
> This solution isn't ideal because you have to use the jump to url which
> means more work in creating the url with params, and you may have to hard
> code your servername.
> --
> Message posted via http://www.sqlmonster.com
>|||No problem. There are a few changes I discovered since the last post, I'll
note them the end here.
You can find the reportviewer project here:
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\
Applications\ReportViewer\vb
Open the project and open the ReportViewer.vb class file.
in the "Private Member Variables" region add:
Private _linktarget As String = "_self"
in the "Properties" region add the property in the above thread.
Now here is the addition to the above.
in the "Render" region add the following line to the Render sub:
output.WriteAttribute("name", "ifmReport")
You need this when you call the viewer property you created. Compile and
drop in your bin/GAC.
So now in your app you will add the following line:
rvwReport.LinkTarget = "ifmReport"
rvwReport being your declared instance of the object. In this bit of code:
Protected WithEvents rvwReport As
Microsoft.Samples.ReportingServices.ReportViewer
Now the good news is that I discovered that the "Jump to Report" option
works when I do this, which is great because the "Jump to URL" was a real
pain.
I'm assuming you are a VB and not a C# person.
Hope this helps... now I'm off to post more questions.
--
Message posted via http://www.sqlmonster.com|||Good news is that it is working :-)
Bad news is, it is only working in part.
What I mean is that you can display the first report, and a click to the
next report works okay, but on the third click to the third report it goes
back to full screen :-(
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> No problem. There are a few changes I discovered since the last post, I'll
> note them the end here.
> You can find the reportviewer project here:
> C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\
> Applications\ReportViewer\vb
> Open the project and open the ReportViewer.vb class file.
> in the "Private Member Variables" region add:
> Private _linktarget As String = "_self"
> in the "Properties" region add the property in the above thread.
> Now here is the addition to the above.
> in the "Render" region add the following line to the Render sub:
> output.WriteAttribute("name", "ifmReport")
> You need this when you call the viewer property you created. Compile and
> drop in your bin/GAC.
> So now in your app you will add the following line:
> rvwReport.LinkTarget = "ifmReport"
> rvwReport being your declared instance of the object. In this bit of code:
> Protected WithEvents rvwReport As
> Microsoft.Samples.ReportingServices.ReportViewer
> Now the good news is that I discovered that the "Jump to Report" option
> works when I do this, which is great because the "Jump to URL" was a real
> pain.
> I'm assuming you are a VB and not a C# person.
> Hope this helps... now I'm off to post more questions.
> --
> Message posted via http://www.sqlmonster.com
>|||I know, I'm trying to work that out now. So annoying, thought I had it solved.
Seems that when the report goes back to the server it "forgets" the target
and goes back to "_top". :-\ There has to be a config setting on the server
that we can change. So can anyone out there find it?
--
Message posted via http://www.sqlmonster.com|||Thanks for all your effort.
I was wondering if you know how we can control the tool bar that is within
the ReportViewer so we can have external controls controlling the Zoom,
Export, etc.
Is this something you've come across and is it easy to do?
--
Regards
<<<Bryan Avery>>
"Patrick P via SQLMonster.com" wrote:
> I know, I'm trying to work that out now. So annoying, thought I had it solved.
> Seems that when the report goes back to the server it "forgets" the target
> and goes back to "_top". :-\ There has to be a config setting on the server
> that we can change. So can anyone out there find it?
> --
> Message posted via http://www.sqlmonster.com
>

Monday, March 26, 2012

Reportviewer - How to link multiple tables into a single dataset

Hi,

I want to design a report in which it will contain fields derived from 2 different stored procedures. I understand a 'table' can display data from a single dataset. How can i bind these two stored procedures into a single dataset so as when i click on the table and use its property 'DataSetName', to be able to select the dataset which holds all columns from stored proc 1 and stored proc 2. How can i link multible tables ( multible stored procedures with different column names in each one) into a single dataset to feed the report?

Thank you
George

Hey George.

That is true about a table only being able to access a single dataset, so you will have to combine those 2 datasets somehow. Here are a couple of ways:

1. Write a 'wrapper' Sproc that gets you what you need

2. In the dataset itself combine the output of the Sprocs (probably not viable as I am sure you want to join somehow)

3. Change the Sprocs to UDFs and join them in your dataset.

Good luck,

Mike

Reportviewer - few questions...

Hello!
I need help with my page.., If someone would help me (information or link)
how to do any step...
I'm creating a asp.net page with reportviewer control.
My idea is:
- three parameters to list (standart dropdownlist like in Reporting
Services)
a) computername (query from database "SELECT ComputerName FROM DATA")
b) countername (query from database "SELECT CounterName FROM COUNTERS")
c) countertype (query from database "SELECT CounterType FROM COUNTERS")
In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
cannot set "Available values - from query"...
So my question is "How to fill parameter with values from SQL database?"
Thanks for helpC#:
ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
ReportParameter rp2 = new ReportParameter("userID", userID, false);
ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
rp2 });
Leszek wrote:
> Hello!
> I need help with my page.., If someone would help me (information or link)
> how to do any step...
> I'm creating a asp.net page with reportviewer control.
> My idea is:
> - three parameters to list (standart dropdownlist like in Reporting
> Services)
> a) computername (query from database "SELECT ComputerName FROM DATA")
> b) countername (query from database "SELECT CounterName FROM COUNTERS")
> c) countertype (query from database "SELECT CounterType FROM COUNTERS")
> In Reporting Services 2.0 (SP2) where three tabs - data, layout and preview.
> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
> cannot set "Available values - from query"...
> So my question is "How to fill parameter with values from SQL database?"
> Thanks for help|||Thanks!!
I made it other way - ojectdatasource, that is created on load aspx page.
Uzytkownik <mark.feferman@.gmail.com> napisal w wiadomosci
news:1149797507.592285.30150@.i39g2000cwa.googlegroups.com...
> C#:
> ReportParameter rp = new ReportParameter("risk_rating", "LOW", false);
> ReportParameter rp2 = new ReportParameter("userID", userID, false);
> ReportViewer1.ServerReport.SetParameters(new ReportParameter[] { rp,
> rp2 });
>
> Leszek wrote:
>> Hello!
>> I need help with my page.., If someone would help me (information or
>> link)
>> how to do any step...
>> I'm creating a asp.net page with reportviewer control.
>> My idea is:
>> - three parameters to list (standart dropdownlist like in Reporting
>> Services)
>> a) computername (query from database "SELECT ComputerName FROM DATA")
>> b) countername (query from database "SELECT CounterName FROM
>> COUNTERS")
>> c) countertype (query from database "SELECT CounterType FROM
>> COUNTERS")
>> In Reporting Services 2.0 (SP2) where three tabs - data, layout and
>> preview.
>> In Visual Studio 2005 is control "reportviewer". In "Report parameters" I
>> cannot set "Available values - from query"...
>> So my question is "How to fill parameter with values from SQL database?"
>> Thanks for help
>sql

Tuesday, March 20, 2012

Reports Security--Windows authnetication

Hi,
I have created a user and a link in our website which links to the report.
Now whenever anyone clicks the button to view the report,a prompt comes up
for Uers name & password. But if wrong password id enterd it shows Reporting
services error-- The permissions granted to the user are insufficient . See
rsOnline for help." Till yesterday, when the person entered a wrong user
name & password. It would prompt the user name & password again & again and
after 3-4 time it would take you to the page... "You are not authoized to
view the page..Plz click the refresh button..."
I tdont want the users to see any reporting svcs error but this general
error : "You are not authoized to view the page..Plz click the refresh
button..." > I think its related to IIS.
How to get over this?
--
pmudI hope you are using Form Authentication example from Microsoft site. All you
have to do is edit the UILogon.aspx page. You have to redirect to the page
where you say that user credential is invalid to see the report.
HTH
--
Rajesh
MCSD.NET
http://meenrajan.blogspot.com
"pmud" wrote:
> Hi,
> I have created a user and a link in our website which links to the report.
> Now whenever anyone clicks the button to view the report,a prompt comes up
> for Uers name & password. But if wrong password id enterd it shows Reporting
> services error-- The permissions granted to the user are insufficient . See
> rsOnline for help." Till yesterday, when the person entered a wrong user
> name & password. It would prompt the user name & password again & again and
> after 3-4 time it would take you to the page... "You are not authoized to
> view the page..Plz click the refresh button..."
> I tdont want the users to see any reporting svcs error but this general
> error : "You are not authoized to view the page..Plz click the refresh
> button..." > I think its related to IIS.
> How to get over this?
> --
> pmud

Reports navigation target

We use frames in our web application and display reports in one of the
frame. When there is a link within a report to navigate to aother report,
the the target report would take over the entire browser window. How can I
set the navigation target to force the new report to stay within its own
frame?
Thanks in advance for any tips.Check out the topic "Using URL Access Parameters" in Books Online. I'm amking an assumption that in one frame you have links to reports that will appear in another frame. You should be able to use the rc:LinkTarget parameter in your "menu" link to the frame you want the report to appear in. This should set the report's hyperlinks to the correct target.
I have not tested this but the documentation makes it appear that this is the way it works.
HTH
"Audrey See" wrote:
> We use frames in our web application and display reports in one of the
> frame. When there is a link within a report to navigate to aother report,
> the the target report would take over the entire browser window. How can I
> set the navigation target to force the new report to stay within its own
> frame?
> Thanks in advance for any tips.
>
>|||I just did a quick test and indeed setting rc:LinkTarget="your target" will modify the report's hyperlinks so that appear in the given target.
"C Addison Ritchie" wrote:
> Check out the topic "Using URL Access Parameters" in Books Online. I'm amking an assumption that in one frame you have links to reports that will appear in another frame. You should be able to use the rc:LinkTarget parameter in your "menu" link to the frame you want the report to appear in. This should set the report's hyperlinks to the correct target.
> I have not tested this but the documentation makes it appear that this is the way it works.
> HTH
> "Audrey See" wrote:
> > We use frames in our web application and display reports in one of the
> > frame. When there is a link within a report to navigate to aother report,
> > the the target report would take over the entire browser window. How can I
> > set the navigation target to force the new report to stay within its own
> > frame?
> >
> > Thanks in advance for any tips.
> >
> >
> >|||Thanks for your tip.
I didn't get a chance to apply this on my report until yesterday. But I
found that your suggestion would not work on my situation.
My problem is that I can't use URL access directly. On the 'Navigation' tab
of the link's 'Advanced Properties' sheet, I have to choose 'Jump to report'
option rather than 'Jump to URL' because I need to carrier report parameters
from the source reprot to the target report.
Does anyone else have any other opinion? I believe this should be a very
common issue.
"C Addison Ritchie" <CAddisonRitchie@.discussions.microsoft.com> wrote in
message news:486EB530-AFC2-42BE-8035-B23708B79FD3@.microsoft.com...
> I just did a quick test and indeed setting rc:LinkTarget="your target"
will modify the report's hyperlinks so that appear in the given target.
> "C Addison Ritchie" wrote:
> > Check out the topic "Using URL Access Parameters" in Books Online. I'm
amking an assumption that in one frame you have links to reports that will
appear in another frame. You should be able to use the rc:LinkTarget
parameter in your "menu" link to the frame you want the report to appear in.
This should set the report's hyperlinks to the correct target.
> >
> > I have not tested this but the documentation makes it appear that this
is the way it works.
> >
> > HTH
> >
> > "Audrey See" wrote:
> >
> > > We use frames in our web application and display reports in one of the
> > > frame. When there is a link within a report to navigate to aother
report,
> > > the the target report would take over the entire browser window. How
can I
> > > set the navigation target to force the new report to stay within its
own
> > > frame?
> > >
> > > Thanks in advance for any tips.
> > >
> > >
> > >|||Did you ever come up with a solution to this?
Thanks,
John Hennesey
JohnHennesey82@.hotmail.com
"Audrey See" wrote:
> Thanks for your tip.
> I didn't get a chance to apply this on my report until yesterday. But I
> found that your suggestion would not work on my situation.
> My problem is that I can't use URL access directly. On the 'Navigation' tab
> of the link's 'Advanced Properties' sheet, I have to choose 'Jump to report'
> option rather than 'Jump to URL' because I need to carrier report parameters
> from the source reprot to the target report.
> Does anyone else have any other opinion? I believe this should be a very
> common issue.
> "C Addison Ritchie" <CAddisonRitchie@.discussions.microsoft.com> wrote in
> message news:486EB530-AFC2-42BE-8035-B23708B79FD3@.microsoft.com...
> > I just did a quick test and indeed setting rc:LinkTarget="your target"
> will modify the report's hyperlinks so that appear in the given target.
> >
> > "C Addison Ritchie" wrote:
> >
> > > Check out the topic "Using URL Access Parameters" in Books Online. I'm
> amking an assumption that in one frame you have links to reports that will
> appear in another frame. You should be able to use the rc:LinkTarget
> parameter in your "menu" link to the frame you want the report to appear in.
> This should set the report's hyperlinks to the correct target.
> > >
> > > I have not tested this but the documentation makes it appear that this
> is the way it works.
> > >
> > > HTH
> > >
> > > "Audrey See" wrote:
> > >
> > > > We use frames in our web application and display reports in one of the
> > > > frame. When there is a link within a report to navigate to aother
> report,
> > > > the the target report would take over the entire browser window. How
> can I
> > > > set the navigation target to force the new report to stay within its
> own
> > > > frame?
> > > >
> > > > Thanks in advance for any tips.
> > > >
> > > >
> > > >
>
>|||We are having the same issue, has a solution been found?
"JohnHennesey" wrote:
> Did you ever come up with a solution to this?
> Thanks,
> John Hennesey
> JohnHennesey82@.hotmail.com
> "Audrey See" wrote:
> > Thanks for your tip.
> > I didn't get a chance to apply this on my report until yesterday. But I
> > found that your suggestion would not work on my situation.
> > My problem is that I can't use URL access directly. On the 'Navigation' tab
> > of the link's 'Advanced Properties' sheet, I have to choose 'Jump to report'
> > option rather than 'Jump to URL' because I need to carrier report parameters
> > from the source reprot to the target report.
> > Does anyone else have any other opinion? I believe this should be a very
> > common issue.
> > "C Addison Ritchie" <CAddisonRitchie@.discussions.microsoft.com> wrote in
> > message news:486EB530-AFC2-42BE-8035-B23708B79FD3@.microsoft.com...
> > > I just did a quick test and indeed setting rc:LinkTarget="your target"
> > will modify the report's hyperlinks so that appear in the given target.
> > >
> > > "C Addison Ritchie" wrote:
> > >
> > > > Check out the topic "Using URL Access Parameters" in Books Online. I'm
> > amking an assumption that in one frame you have links to reports that will
> > appear in another frame. You should be able to use the rc:LinkTarget
> > parameter in your "menu" link to the frame you want the report to appear in.
> > This should set the report's hyperlinks to the correct target.
> > > >
> > > > I have not tested this but the documentation makes it appear that this
> > is the way it works.
> > > >
> > > > HTH
> > > >
> > > > "Audrey See" wrote:
> > > >
> > > > > We use frames in our web application and display reports in one of the
> > > > > frame. When there is a link within a report to navigate to aother
> > report,
> > > > > the the target report would take over the entire browser window. How
> > can I
> > > > > set the navigation target to force the new report to stay within its
> > own
> > > > > frame?
> > > > >
> > > > > Thanks in advance for any tips.
> > > > >
> > > > >
> > > > >
> >
> >
> >|||Yep - we are using a report proxy that sits between our clients and the
reporting server. When it relays the html to the client it uses regular
expressions to search for "target=_top" and change it to the proper window.
As far as I am concerned this is an enhancement that needs to be addressed -
if we weren't using a proxy I don't know of a way around it.
Bummer.
Good luck,
John
"Ray Seppala" wrote:
> We are having the same issue, has a solution been found?
> "JohnHennesey" wrote:
> > Did you ever come up with a solution to this?
> >
> > Thanks,
> > John Hennesey
> > JohnHennesey82@.hotmail.com
> >
> > "Audrey See" wrote:
> >
> > > Thanks for your tip.
> > > I didn't get a chance to apply this on my report until yesterday. But I
> > > found that your suggestion would not work on my situation.
> > > My problem is that I can't use URL access directly. On the 'Navigation' tab
> > > of the link's 'Advanced Properties' sheet, I have to choose 'Jump to report'
> > > option rather than 'Jump to URL' because I need to carrier report parameters
> > > from the source reprot to the target report.
> > > Does anyone else have any other opinion? I believe this should be a very
> > > common issue.
> > > "C Addison Ritchie" <CAddisonRitchie@.discussions.microsoft.com> wrote in
> > > message news:486EB530-AFC2-42BE-8035-B23708B79FD3@.microsoft.com...
> > > > I just did a quick test and indeed setting rc:LinkTarget="your target"
> > > will modify the report's hyperlinks so that appear in the given target.
> > > >
> > > > "C Addison Ritchie" wrote:
> > > >
> > > > > Check out the topic "Using URL Access Parameters" in Books Online. I'm
> > > amking an assumption that in one frame you have links to reports that will
> > > appear in another frame. You should be able to use the rc:LinkTarget
> > > parameter in your "menu" link to the frame you want the report to appear in.
> > > This should set the report's hyperlinks to the correct target.
> > > > >
> > > > > I have not tested this but the documentation makes it appear that this
> > > is the way it works.
> > > > >
> > > > > HTH
> > > > >
> > > > > "Audrey See" wrote:
> > > > >
> > > > > > We use frames in our web application and display reports in one of the
> > > > > > frame. When there is a link within a report to navigate to aother
> > > report,
> > > > > > the the target report would take over the entire browser window. How
> > > can I
> > > > > > set the navigation target to force the new report to stay within its
> > > own
> > > > > > frame?
> > > > > >
> > > > > > Thanks in advance for any tips.
> > > > > >
> > > > > >
> > > > > >
> > >
> > >
> > >

Monday, March 12, 2012

Reports Deployed on a local machine cannot be viewd from internet

We have deployed our reports on a local machine say "MC230" which is the
local intranet. Now we have created a asp.net page and given a link to one of
the reports by mentioning "MC230" in the URL of the link. After hosting this
page on out web site, we are able to take the reports by clicking the link in
the local intranet. But when v take the reports out side the domain we are
not getting the reports, instead it is showing Page Cannot be Displayed. As
mentioned in this group v tried changing the url in RSWebApplication.config.
still v r getting the same error.
Can any one please help us. As we are developing a corporate application it
is very urgent.The Reporting Services setup program assumes that you will be accessing the
Reports website using an address similar to http://servername/Reports. This
works fine inside your network, but it probably isn't going to work well if
you want to make the Reports website available from outside your network.
In this case you should make a change to the RSWebApplication.config file.
Find lines like
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
</UI>
and replace <ReportServerUrl></ReportServerUrl> parameter like
<Configuration>
<UI>
<ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
</UI>
you can write servers IP too, like http://212.212.222.222/ReportServer
After this change you may need to restart the IIS service for this change to
take effect.
"Bigil" <Bigil@.discussions.microsoft.com> wrote in message
news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> We have deployed our reports on a local machine say "MC230" which is the
> local intranet. Now we have created a asp.net page and given a link to one
of
> the reports by mentioning "MC230" in the URL of the link. After hosting
this
> page on out web site, we are able to take the reports by clicking the link
in
> the local intranet. But when v take the reports out side the domain we are
> not getting the reports, instead it is showing Page Cannot be Displayed.
As
> mentioned in this group v tried changing the url in
RSWebApplication.config.
> still v r getting the same error.
> Can any one please help us. As we are developing a corporate application
it
> is very urgent.
>|||Hi,
Tanks for de reply, but it culd'nt solve the issue, u have asked me to give
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> </UI>
right, since reporting services isnstalled on a localmachine "MC230" how
should i give the url "http://MC230/ReportServer"'? how will this b
recognized on internet
"saglamtimur" wrote:
> The Reporting Services setup program assumes that you will be accessing the
> Reports website using an address similar to http://servername/Reports. This
> works fine inside your network, but it probably isn't going to work well if
> you want to make the Reports website available from outside your network.
> In this case you should make a change to the RSWebApplication.config file.
> Find lines like
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> </UI>
> and replace <ReportServerUrl></ReportServerUrl> parameter like
> <Configuration>
> <UI>
> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
> </UI>
> you can write servers IP too, like http://212.212.222.222/ReportServer
> After this change you may need to restart the IIS service for this change to
> take effect.
>
> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> > We have deployed our reports on a local machine say "MC230" which is the
> > local intranet. Now we have created a asp.net page and given a link to one
> of
> > the reports by mentioning "MC230" in the URL of the link. After hosting
> this
> > page on out web site, we are able to take the reports by clicking the link
> in
> > the local intranet. But when v take the reports out side the domain we are
> > not getting the reports, instead it is showing Page Cannot be Displayed.
> As
> > mentioned in this group v tried changing the url in
> RSWebApplication.config.
> > still v r getting the same error.
> >
> > Can any one please help us. As we are developing a corporate application
> it
> > is very urgent.
> >
> >
>
>|||Talk to your IT person about mapping an internet DNS address (or public IP
address) to the report server. If that's not done, it's not possible.
Whatever the IT guy tells you is the correct address, put that in the config
file.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Bigil" <Bigil@.discussions.microsoft.com> wrote in message
news:626225B4-BDF0-45B9-81F9-93E5573F195F@.microsoft.com...
> Hi,
> Tanks for de reply, but it culd'nt solve the issue, u have asked me to
> give
>> <UI>
>> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
>> </UI>
> right, since reporting services isnstalled on a localmachine "MC230" how
> should i give the url "http://MC230/ReportServer"'? how will this b
> recognized on internet
> "saglamtimur" wrote:
>> The Reporting Services setup program assumes that you will be accessing
>> the
>> Reports website using an address similar to http://servername/Reports.
>> This
>> works fine inside your network, but it probably isn't going to work well
>> if
>> you want to make the Reports website available from outside your network.
>> In this case you should make a change to the RSWebApplication.config
>> file.
>> Find lines like
>> <Configuration>
>> <UI>
>> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
>> </UI>
>> and replace <ReportServerUrl></ReportServerUrl> parameter like
>> <Configuration>
>> <UI>
>> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
>> </UI>
>> you can write servers IP too, like http://212.212.222.222/ReportServer
>> After this change you may need to restart the IIS service for this change
>> to
>> take effect.
>>
>> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
>> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
>> > We have deployed our reports on a local machine say "MC230" which is
>> > the
>> > local intranet. Now we have created a asp.net page and given a link to
>> > one
>> of
>> > the reports by mentioning "MC230" in the URL of the link. After hosting
>> this
>> > page on out web site, we are able to take the reports by clicking the
>> > link
>> in
>> > the local intranet. But when v take the reports out side the domain we
>> > are
>> > not getting the reports, instead it is showing Page Cannot be
>> > Displayed.
>> As
>> > mentioned in this group v tried changing the url in
>> RSWebApplication.config.
>> > still v r getting the same error.
>> >
>> > Can any one please help us. As we are developing a corporate
>> > application
>> it
>> > is very urgent.
>> >
>> >
>>|||Hi,
Thanks!! it was really helpful.
This was the answer i was looking for "If that's not done, it's not possible."
Best Regards
Bigil Kuriyan
"Jeff A. Stucker" wrote:
> Talk to your IT person about mapping an internet DNS address (or public IP
> address) to the report server. If that's not done, it's not possible.
> Whatever the IT guy tells you is the correct address, put that in the config
> file.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> news:626225B4-BDF0-45B9-81F9-93E5573F195F@.microsoft.com...
> > Hi,
> >
> > Tanks for de reply, but it culd'nt solve the issue, u have asked me to
> > give
> >> <UI>
> >> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> >> </UI>
> > right, since reporting services isnstalled on a localmachine "MC230" how
> > should i give the url "http://MC230/ReportServer"'? how will this b
> > recognized on internet
> >
> > "saglamtimur" wrote:
> >
> >> The Reporting Services setup program assumes that you will be accessing
> >> the
> >> Reports website using an address similar to http://servername/Reports.
> >> This
> >> works fine inside your network, but it probably isn't going to work well
> >> if
> >> you want to make the Reports website available from outside your network.
> >>
> >> In this case you should make a change to the RSWebApplication.config
> >> file.
> >>
> >> Find lines like
> >>
> >> <Configuration>
> >> <UI>
> >> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> >> </UI>
> >>
> >> and replace <ReportServerUrl></ReportServerUrl> parameter like
> >>
> >> <Configuration>
> >> <UI>
> >>
> >> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
> >> </UI>
> >>
> >> you can write servers IP too, like http://212.212.222.222/ReportServer
> >>
> >> After this change you may need to restart the IIS service for this change
> >> to
> >> take effect.
> >>
> >>
> >> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> >> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> >> > We have deployed our reports on a local machine say "MC230" which is
> >> > the
> >> > local intranet. Now we have created a asp.net page and given a link to
> >> > one
> >> of
> >> > the reports by mentioning "MC230" in the URL of the link. After hosting
> >> this
> >> > page on out web site, we are able to take the reports by clicking the
> >> > link
> >> in
> >> > the local intranet. But when v take the reports out side the domain we
> >> > are
> >> > not getting the reports, instead it is showing Page Cannot be
> >> > Displayed.
> >> As
> >> > mentioned in this group v tried changing the url in
> >> RSWebApplication.config.
> >> > still v r getting the same error.
> >> >
> >> > Can any one please help us. As we are developing a corporate
> >> > application
> >> it
> >> > is very urgent.
> >> >
> >> >
> >>
> >>
> >>
>
>

Reports asking for username and password

I have two questions -

1. I have deployed the reports on our webserver. When I access the link http://servername/Reports from IE it asks me for a username and password the first time. I tried all the passwords including admin user/pwd but the dialog remains there. I close IE and start again I can access the reports. For your information, the checkbox 'Save my password' is checked in the reports. Does anyone know why the username/password dialog appears the first time?

2. Sometimes some of us get a 'Page cannot be displayed' while the others can access it. I have to start Reporting services and everyone can access the reports. Any ideas?

Thanks!!

Kind of sounds like the same problem we had when I started deploying reports out to the server. We were accessing the Report server through another program that I was using to hold the reports to make it easier for the customers to access them without going out of the original program

What we done was build a dummy account on our intranet and put that in Security portion of the Report Manager and set it so that was the password for users to access the system without having to have them type in their Windows Password or whatever password your administrator has set up to access the server.

Make sure the box is checked under the security to store the password on the server if that's how you're going to do it, otherwise it doesn't matter whether you have the Save password box checked or not the server won't save it.

As far as you have to consistently start Reporting services I don't know. I know ours runs as long as the server is running so it's accessable all the time.

Hope this helps some

|||

Wayne,

How did you create a dummy account and attach it to the security portion of the Report Manager. Did you do it through the reporting config tools -> Specify Execution Account.

|||

Our system administrator set up the dummy account just like any other Windows account and put in our Doman Users Group which is the group that has access to the majority of the areas.

What we do instead of having to put every user with having access to the sites with their windows logon we put the main user group with rights and then in the Report Manager under the Data Sources/Security you can set whether or not they use windows logon or a password stored on the server and that is where you put in the dummy account User Name and password.

You also have to make sure that the User Groups have rights to not only the reports and the data source but are also on the user permissions for the database itself other wise you will still get an error that they can't access the report. We made the group just as a browser in the report manager so they couldn't do anything and just as a datareader on the database, although they can't access it anyway.

Hope this helps

Saturday, February 25, 2012

reporting services--preview error

I am ceating reports using VS 2005, for sql 2005(don't know if you can do it for sql 2000 also). but here is the link for tutorial,http://msdn2.microsoft.com/en-us/library/ms171046.aspx. When I add the query from Step 2. it get the following error, I have tried the code with "=" and "&" also.

"[rsFieldReference] The Value expression for the textbox 'FirstName' refers to the field 'FirstName'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

[rsFieldReference] The Value expression for the textbox 'LastName' refers to the field 'LastName'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

[rsFieldReference] The Value expression for the textbox 'Title' refers to the field 'Title'. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.

Build complete -- 3 errors, 0 warnings".

Can someone help me?

thanks in advance!

you might want to try runing the query in the data view or try removing the field entries and replacing them. i think what is happening is there's a problem when you update a dataset sometimes the field elements no longer reconize the dataset not to sure.|||

I figured it out today, you have to use generic query designer to execute the Parameter!... stuff. Apparently whan i toggled it; i was in the wrong query designer.