Report, Data sources errors.

Hi,

I have created several reports with Reporting Services and Visual Studio 2005 for an ASP.NET 2 application.

Now, when I want to edit a report and I select Report -> Data Sources in the Visual Studio menu, I get the error "prefix " cannot be mapped to namespace name "xml" or "xmlns". Line 1 position 87." My website datasources are empty and I can't build new reports.

Any idea ?

Thanks for your help.

Nicolas.

I am having this same problem. Does anyone have a solution.

I was able to make 2 Reports, and as I was working on my third report today the same error occured.

When i open the pervious reports i made (which still work), and goto Report > Data Sources I also get the error message:

Prefix '' cannot be mapped to namespace name reserved for "xml" or "xmls". Line 1, position 87

Any help is appreciated - thanks.

sql

Report Viewer shrinking and shows scrollbar

I am using Crystal Report Viewer in ASP.NET page. In some of my reports, the viewer seem to be shrinking to about one third of the page. I have set all properties including width etc properly.
Have anybody seen this behaviour before?I have also faced same problem..If you get any solve pls. post in this forum.|||We found that this problem happens when we install some specific printer drivers. If I uninstall all printers from my server, all reports are working fine. Please post your updates too..|||I was reading something on Crystal KB the other day about print drivers. I can't remember the exact scenario but the gist of it was that the report was misbehaving in the production environment.

The solution was to set the report to "No Printer" in the design environment so that it didn't carry over the print driver settings. Everytime a user prints with a different printer and those settings conflict with the design print settings, it creates havoc.

Just wondering if setting your report to "No Print" would alleviate this problem too?

Linda|||We tried that. And it worked fine until I try to print the report. When I print, it returns to the smaller size.

- Tony|||Sounds like a bug to me!

report viewer problem

I found a few topics about that problem but I'm not sure it solves my
problem.
I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
Each report view is running a diffrent report.
in the code behinde I'm adding each report a parameter from my page.
Now, my site is configure to send me errors to my mail.
I've noticed that every time that I leave the page with the 4 report
viewer open, after about 10-12 minutes (without toucing anything and
without any refresh or postback) I get an error mail with this error:
Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
(rsExecutionNotFound)
The page itself stay OK with the 4 viewer and the user don't know that
there was a problem but I do.
Any thing know way is that?
I saw some thing about session of the report viewer but I'm not sure
about that.
B.T.W
I'm still with sp1on my sql server, Does any body know if it realted
to my problem?
Thanks!On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> I found a few topics about that problem but I'm not sure it solves my
> problem.
> I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> Each report view is running a diffrent report.
> in the code behinde I'm adding each report a parameter from my page.
> Now, my site is configure to send me errors to my mail.
> I've noticed that every time that I leave the page with the 4 report
> viewer open, after about 10-12 minutes (without toucing anything and
> without any refresh or postback) I get an error mail with this error:
> Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> (rsExecutionNotFound)
> The page itself stay OK with the 4 viewer and the user don't know that
> there was a problem but I do.
> Any thing know way is that?
> I saw some thing about session of the report viewer but I'm not sure
> about that.
> B.T.W
> I'm still with sp1on my sql server, Does any body know if it realted
> to my problem?
> Thanks!
Actually, it sounds like the session is timing out. You might be able
to tweak the session timeout variable in the web.config file. Also, I
would suggest using fewer report viewer controls to improve
performance and streamline the application. You should be able to
dynamically set the report associated with the report viewer control.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Martinez,
Well, I need those 4 report viewer 'coz I need to display 4 graphs at
the same time for comparison but that not so bad.
The problem is the error I'm getting (actully - its 4 errors. one for
each viewer).
In my web.config of the asp.net appliction I have <sessionState
timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
there is a session configuration in the sqlserver as well').
Any way, The page does not refresh after the report are loaded so
isn't there a way to tell the viewer not to try and refresh him self?
Thanks again, hope to get more ideas,
Roy.
On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail.c=om> wrote:
> On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
>
> > I found a few topics about that problem but I'm not sure it solves my
> > problem.
> > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > Each report view is running a diffrent report.
> > in the code behinde I'm adding each report a parameter from my page.
> > Now, my site is configure to send me errors to my mail.
> > I've noticed that every time that I leave the page with the 4 report
> > viewer open, after about 10-12 minutes (without toucing anything and
> > without any refresh or postback) I get an error mail with this error:
> > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > (rsExecutionNotFound)
> > The page itself stay OK with the 4 viewer and the user don't know that
> > there was a problem but I do.
> > Any thing know way is that?
> > I saw some thing about session of the report viewer but I'm not sure
> > about that.
> > B.T.W
> > I'm still with sp1on my sql server, Does any body know if it realted
> > to my problem?
> > Thanks!
> Actually, it sounds like the session is timing out. You might be able
> to tweak the session timeout variable in the web.config file. Also, I
> would suggest using fewer report viewer controls to improve
> performance and streamline the application. You should be able to
> dynamically set the report associated with the report viewer control.
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 8, 2:13 am, nicknack <roezo...@.gmail.com> wrote:
> Hi Martinez,
> Well, I need those 4 report viewer 'coz I need to display 4 graphs at
> the same time for comparison but that not so bad.
> The problem is the error I'm getting (actully - its 4 errors. one for
> each viewer).
> In my web.config of the asp.net appliction I have <sessionState
> timeout=3D60> so it souldn't drop my seesion after 10 minuts (Maybe
> there is a session configuration in the sqlserver as well').
> Any way, The page does not refresh after the report are loaded so
> isn't there a way to tell the viewer not to try and refresh him self?
> Thanks again, hope to get more ideas,
> Roy.
> On 8 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:43, EMartinez <emartinez...@.gmail=.com> wrote:
> > On Jan 7, 8:51 am, nicknack <roezo...@.gmail.com> wrote:
> > > I found a few topics about that problem but I'm not sure it solves my
> > > problem.
> > > I have an aspx web page (ASP.NET fw2.0) with 4 report viewer.
> > > Each report view is running a diffrent report.
> > > in the code behinde I'm adding each report a parameter from my page.
> > > Now, my site is configure to send me errors to my mail.
> > > I've noticed that every time that I leave the page with the 4 report
> > > viewer open, after about 10-12 minutes (without toucing anything and
> > > without any refresh or postback) I get an error mail with this error:
> > > Execution 'ucv5xtu2x2uvhfjmjkfmfy45' cannot be found
> > > (rsExecutionNotFound)
> > > The page itself stay OK with the 4 viewer and the user don't know that=
> > > there was a problem but I do.
> > > Any thing know way is that?
> > > I saw some thing about session of the report viewer but I'm not sure
> > > about that.
> > > B.T.W
> > > I'm still with sp1on my sql server, Does any body know if it realted
> > > to my problem?
> > > Thanks!
> > Actually, it sounds like the session is timing out. You might be able
> > to tweak the session timeout variable in the web.config file. Also, I
> > would suggest using fewer report viewer controls to improve
> > performance and streamline the application. You should be able to
> > dynamically set the report associated with the report viewer control.
> > Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
If you are using local mode, you might want to switch to server mode.
Hope this helps further.
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi,
I'm already useing server mode to load my report from the sqlserver to
my asp.net server where I'm running my application.
Its look like a session problem but I don't know way it need to
refresh the report after 10 minuts and look for the session again.
Thanks.
On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> If you are using local mode, you might want to switch to server mode.
> Hope this helps further.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> Hi,
> I'm already useing server mode to load my report from the sqlserver to
> my asp.net server where I'm running my application.
> Its look like a session problem but I don't know way it need to
> refresh the report after 10 minuts and look for the session again.
> Thanks.
> On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > If you are using local mode, you might want to switch to server mode.
> > Hope this helps further.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You might want to expand the session state in the web.config file a
little more. Also, you might try to see if there is a timeout set
somewhere for the virtual directory of your website -and/or- in IIS.
Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant|||I'll try to find another options.
Thank for your help Martinez!
Roy.
On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmail.=com> wrote:
> On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
>
> > Hi,
> > I'm already useing server mode to load my report from the sqlserver to
> > my asp.net server where I'm running my application.
> > Its look like a session problem but I don't know way it need to
> > refresh the report after 10 minuts and look for the session again.
> > Thanks.
> > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > If you are using local mode, you might want to switch to server mode.
> > > Hope this helps further.
> > > Regards,
> > > Enrique Martinez
> > > Sr. Software Consultant
> You might want to expand the session state in the web.config file a
> little more. Also, you might try to see if there is a timeout set
> somewhere for the virtual directory of your website -and/or- in IIS.
> Sorry that I could not be of greater assistance.
> Regards,
> Enrique Martinez
> Sr. Software Consultant|||On Jan 10, 12:58 am, nicknack <roezo...@.gmail.com> wrote:
> I'll try to find another options.
> Thank for your help Martinez!
> Roy.
> On 10 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 03:11, EMartinez <emartinez...@.gmai=l.com> wrote:
> > On Jan 9, 2:34 am, nicknack <roezo...@.gmail.com> wrote:
> > > Hi,
> > > I'm already useing server mode to load my report from the sqlserver to=
> > > my asp.net server where I'm running my application.
> > > Its look like a session problem but I don't know way it need to
> > > refresh the report after 10 minuts and look for the session again.
> > > Thanks.
> > > On 9 =D7=99=D7=A0=D7=95=D7=90=D7=A8, 04:59,
> > > > If you are using local mode, you might want to switch to server mode=.
> > > > Hope this helps further.
> > > > Regards,
> > > > Enrique Martinez
> > > > Sr. Software Consultant
> > You might want to expand the session state in the web.config file a
> > little more. Also, you might try to see if there is a timeout set
> > somewhere for the virtual directory of your website -and/or- in IIS.
> > Sorry that I could not be of greater assistance.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

report viewer newbie

hi,

i'm a newbie in using report viewer and having a tough time now building a web app in c# and asp.net.. hope someone can help me on this.

i'm using VS2005 and RS2005.

i've tried looking at the sample RssNewsReader but i have problem running it. error message : Could not find type 'RssNewsReader.ChannelInfo'.

i think this is because i don't have system.ComponentModel in the reference and i don't have this dll file in my system as well, therefore i could not add it in.

i tried looking at sample in odetocode website but the sample wasn't built using VS2005, so i encounter problems changing the syntax.

can someone direct me to a sample i can use?

i want to know how to set parameter and filter the result according to the parameter selected and display it on the report viewer (using web form).

thanks!

I have exactly the same question

I would be happy to see some example of using the report viewer

control used in 2005.

|||

eyalkz,

you can get samples from www.gotreportviewer.com and check out Visual Studio Report Control forum. More discussion on this topic there.

hth

Report Viewer language

Does Reporting services supports Turkish language

I am using reporting services in my asp.net project and I want to change "view report","export" buttons text to turkish words, is this possible, if possible how? thanks

I find something about IReportViewerMessages,

I crate class library project "SampViewMessages", I add "messsages.cs" class which implements IReportViewerMessages.

I create strong key GACkey.snk (c:\GACDemo\GACkey.snk)

and changed AssemblyInfo.cs like

[assembly: AssemblyTitle("")]

[assembly: AssemblyDescription("")]

[assembly: AssemblyConfiguration("")]

[assembly: AssemblyCompany("")]

[assembly: AssemblyProduct("")]

[assembly: AssemblyCopyright("")]

[assembly: AssemblyTrademark("")]

[assembly: AssemblyCulture("")]

[assembly: AssemblyVersion("1.0.0.0")]

[assembly: AssemblyDelaySign(false)]

[assembly: AssemblyKeyFile("c:\\GACDemo\\GACKey.snk")]

[assembly: AssemblyKeyName("")]

then build and added to gac with command "gacutil /i SampViewMessages.dll"

In my asp.net project web congif file I added

<appSettings>

<add key="ReportViewerMessages" value="SampViewMessages.messsages, Version=1.0.0.0, Culture=neutral, PublicKeyToken=1f30458ddbfa42d1"/>

</appSettings>

when ? run aspx page it gives error:

The given assembly name or codebase was invalid. (Exception from HRESULT: 0x80131047)

what is wrong?

Report Viewer Information

Does anyone know of a good tutorial to learn how to use the Report Viewer with ASP.NET pages? I will just be stored procedures, and I haven't used a reporting tool before. I tried to make up one just to try it out, but I kept getting table errors. It also referenced the file locally, which I don't think is right for what I need. I am converting Access Reports to the ASP.NET site that will replace the Access application, and I need a report that can be accessed from remote computers though the side. Please help if you have any ideas because I couldn't find much information about this.

try here:

http://www.gotreportviewer.com/

|||I tried that site before, and didn't have too much luck with it, but I was able to figure out some of the basics on my own. Does anyone know how to make it so that the report will be converted horizontally on the PDF file when exported with the report viewer control?

Report Viewer control ignores parameters

I have a Report Viewer control on an asp.net page. The report shows the
parameters. When I choose a value from the drop down and then click on "View
report", the screen gets refreshed and the parameters are reset. It's like
no parameters have been selected from the drop down and no data is shown. If
I run the same report from report manager, or from VS, everything works. Has
anybody had this issue?
Thanks,
GilgameshOn Aug 28, 4:27 pm, "Gilgamesh" <gilgamesh4e...@.aol.com> wrote:
> I have a Report Viewer control on an asp.net page. The report shows the
> parameters. When I choose a value from the drop down and then click on "View
> report", the screen gets refreshed and the parameters are reset. It's like
> no parameters have been selected from the drop down and no data is shown. If
> I run the same report from report manager, or from VS, everything works. Has
> anybody had this issue?
> Thanks,
> Gilgamesh
You might want to check your parameter mappings to the main
datasource. It sounds like there's a breakdown there somewhere. Also,
make sure that you are not receiving an error in the database
connection string, etc. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Report Viewer Control + shared hosting

Hi all,

I have a question regarding the report view control and shared hosting. What I need to do is generate a .pdf report dynamically in my ASP.NET web-app using the aforementioned control. What I'm wondering is if this will be do-able on most shared hosts. For example, I know that most (if not all) shared hosts will not allow you to use Crystal Reports because it needs to be installed onto the server rather than on your slice of the server. Is there any installation required to use the report viewer? Conversely, if someone knows of a cheap ($10 - $20/mo) host that allows crystal report use that would be extremely helpful, since I've already done it in crystal reports :(.

Thanks in advance!

Mike

Hello,

You need to have a licensed SQL Server, for using SSRS. You do not require to install any thing on the server.

Please see the links below and select the one with Reporting services,

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Thanks,

Deepesh Verma

|||

Thanks for your reply. However, I am still a bit confused, as I'm not sure which row in the tables I need. Is it report server under business intelligence? If so, it appears I can get that w/ SQL Express, which is what I'm currently using. Any more feedback you can give would be appreciated.

|||

Yes for personal development you can use SQL Express. But if you want for commercial use then you have to go for any other option then Express.

Thanks

report viewer control

Hi,
i'm a newbie in using report viewer and having a tough time now
building a web app in c# and asp.net.. hope someone can help me on
this.
i'm using VS2005 and RS2005.
can someone direct me to a sample i can use?
i want to know how to set parameter and filter the result according to
the parameter selected and display it on the report viewer (using web
form).
Thanks,
Eyaltry here
http://www.devx.com/dotnet/Article/30610/1954?pf=true
Regards,
Jimmy M Joy
--
Microsoft Application Developer
"EyalK" wrote:
> Hi,
> i'm a newbie in using report viewer and having a tough time now
> building a web app in c# and asp.net.. hope someone can help me on
> this.
> i'm using VS2005 and RS2005.
> can someone direct me to a sample i can use?
> i want to know how to set parameter and filter the result according to
> the parameter selected and display it on the report viewer (using web
> form).
> Thanks,
> Eyal
>|||Try this http://www.gotreportviewer.com/
"Jimmy M Joy" wrote:
> try here
> http://www.devx.com/dotnet/Article/30610/1954?pf=true
> Regards,
> Jimmy M Joy
> --
> Microsoft Application Developer
>
> "EyalK" wrote:
> > Hi,
> >
> > i'm a newbie in using report viewer and having a tough time now
> > building a web app in c# and asp.net.. hope someone can help me on
> > this.
> >
> > i'm using VS2005 and RS2005.
> >
> > can someone direct me to a sample i can use?
> >
> > i want to know how to set parameter and filter the result according to
> > the parameter selected and display it on the report viewer (using web
> > form).
> >
> > Thanks,
> > Eyal
> >
> >sql

Report Viewer authentication

Hello,

I am trying to create a simple ASP page to navigate in the reports stored in the report server. If I work in debug mode everything is fine. The page is working and If I call for a report I can see it perfectly. If I publish the report on my test machine (Windows XP Sp2 so IIS 5.1) I see that IE is connecting me with the ASP net user and not the correct one (myself) that is authorized to see the reports. Anybody knows how to solve it?

Thank you!

Andrea Pagliano

If you need the interactive user identity to be propagated to the Report Server, in your app web.config set <indentity impersonate="true"/>. This won't work if the Report Server is ona different machine though unless you enable Kerberos. There are other options as explained here.|||

Thank you very much! That did it!

Thanks again

Andrea Pagliano

Report viewer and Visual Studio 2005

Hi, I developed ASP.Net web site project with Report Viewer,and i published the project and put it another system in my LAN, after creating the virtual directory in IIS i tried to browse. I am getting the following error:

[WebException: The request failed with HTTP status 401: Access Denied.] Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods() +211

The report server of my machine can be accessed thru http://sys40/reportserver from that system. But the published website is showing the above mentioned error, so i created the a new project, same as the one created in my system, in the other system. While debugging the project i am able to access the report server and view the report but wen the website is published and then browsed the above mentioned error is displayed.

Even the identity impersonate = true condition was made in web config file..

How can this issue be solved...

Thanks in advance.. Somu

HI,radmoorthy ：

You can give it a try with these following steps:

1. Verify your NTFS permissions for the users on the folder C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer.

He should have ("Read & Execute", "List Folder Content" and "Read").

2.In IIS for Reports and ReportServer app set Authenication method to "Basic authentication" from "Integrated Windows authentication".

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI,radmoorthy ：

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Report Viewer and FireFox 1.0

I have a report and added the RS report viewer as a control. when I run the
Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
However When using Firefox, the RS report viewer control looks way
distorted!! Is anyone aware of this problem or am I doing anything wrong.
Most of ower clients use IE, few are using Firefox. i want the .net p[asge
to be cross browser especially when using the Report Viewr control.
Thanks
--
Message posted via http://www.sqlmonster.comAm also running V1.0 and the rendered report that usually shows as a
complete page in IE6 is in a small area about a half-inch high and very
"squashed" - definitely useless...
Firefox also asked me to login to RS twice before it would show the report -
no such login needed with IE.
Stick with IE6 for now...
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:a4b7b466d7fe4ecb9ece2d90a786f5d4@.SQLMonster.com...
> I have a report and added the RS report viewer as a control. when I run
the
> Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
> However When using Firefox, the RS report viewer control looks way
> distorted!! Is anyone aware of this problem or am I doing anything wrong.
> Most of ower clients use IE, few are using Firefox. i want the .net p[asge
> to be cross browser especially when using the Report Viewr control.
> Thanks
> --
> Message posted via http://www.sqlmonster.com|||Fully agree, except when you diploy at client site, you have no control
over the browser they use. And I know for a fact, some will use Firefox
1.0. I have read about a lot of flaws and attacks already in the Fire fox
space. Programming for IE is much more permissive, Fire Fox is so "Anal" so-
to-speak ( could not find a better word to discribe it :) ).
--
Message posted via http://www.sqlmonster.com|||We're in the same situation and are looking at fixes. I don't think any
of us will get the Report Manager app working outside of IE - MS coded
it and that is the way it is!
One semi workaround we've found that I've not seen any postings on is an
export type for more compatible html that by default is not visible. In
the file:
\..\Reporting Services\ReportServer\RSReportServer.config
Find the section on <Render> and:
Extension Name="HTML3.2"
Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32RenderingExtension,Microsoft.ReportingServices.HtmlRendering"
Visible="false"/>
Change Viable="false" to "true"
Since Firefox doesn't open the new browser window from the Export in RS
run the report in IE and then go to the Export drop down and select "web
page for most browsers" which should now be visable. You'll get a new
browser window with a html3.2 rendered report. Copy/paste the very long
url into Firefox and the report looks nearly as good. From that url you
can see how to built other static links to your reports that Firefox can
display. You do loose pagination provided by the IE renderer and if you
want more than static links to your reports you'll have to roll your own
interface to build the url with parameters, report names, etc.....but
it is possible.
David
James Woo via SQLMonster.com wrote:
> I have a report and added the RS report viewer as a control. when I run the
> Asp.net pasge I created in IE 6.0 I have no problem seeing the report,
> However When using Firefox, the RS report viewer control looks way
> distorted!! Is anyone aware of this problem or am I doing anything wrong.
> Most of ower clients use IE, few are using Firefox. i want the .net p[asge
> to be cross browser especially when using the Report Viewr control.
> Thanks
>|||I've posted on this topic already if you want feel inclined to search
for it, if not, the gist of it is that it doesn't even work on IE for
Macs. I've tested a few browsers and it's just a complete no go at the
moment.
Chris
DT Grayston wrote:
> We're in the same situation and are looking at fixes. I don't think
> any of us will get the Report Manager app working outside of IE - MS
> coded it and that is the way it is!
> One semi workaround we've found that I've not seen any postings on is
> an export type for more compatible html that by default is not
> visible. In the file:
> \..\Reporting Services\ReportServer\RSReportServer.config
> Find the section on <Render> and:
> Extension Name="HTML3.2"
> Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html32Renderi
> ngExtension,Microsoft.ReportingServices.HtmlRendering"
> Visible="false"/>
> Change Viable="false" to "true"
> Since Firefox doesn't open the new browser window from the Export in
> RS run the report in IE and then go to the Export drop down and
> select "web page for most browsers" which should now be visable.
> You'll get a new browser window with a html3.2 rendered report.
> Copy/paste the very long url into Firefox and the report looks nearly
> as good. From that url you can see how to built other static links
> to your reports that Firefox can display. You do loose pagination
> provided by the IE renderer and if you want more than static links to
> your reports you'll have to roll your own interface to build the url
> with parameters, report names, etc.....but it is possible.
> David
> James Woo via SQLMonster.com wrote:
> > I have a report and added the RS report viewer as a control. when I
> > run the Asp.net pasge I created in IE 6.0 I have no problem seeing
> > the report, However When using Firefox, the RS report viewer
> > control looks way distorted!! Is anyone aware of this problem or am
> > I doing anything wrong. Most of ower clients use IE, few are using
> > Firefox. i want the .net p[asge to be cross browser especially when
> > using the Report Viewr control. Thanks
> >

Report Viewer 2.0 Windows Authentication

Hello,
We have an public site with a page now using ASP.NET 2.0 and the 2.0 Report
Viewer control (we previously tried this with RS 2000 for many, many months).
It is connecting to a (NAT'd FQDN) SQL2005 Report Server using default
Windows authentication. There is a local user setup on the Report Server
that I want this public site to connect as (I can do this by typing
credentials). I do not want and can not have the pop-up windows
authentication. HOW DO I AUTHENTICATE WITHOUT TYPING IN CREDENTIALS?
We are a Gold Partner and would really appreciate a direct solution to this
issue. There has been countless similar requests that come up on all kinds
of searches, yet no direct solution. We don't need to know that you have to
implement "IReportServerCredentials". Please provide an exact example of how
this is accomplished. If you can provide it in VB.NET even better.
Thanks.I read a similar post where the person said that they couldn't reveal exactly
how to do this since they were about to sell it. Nice. Why is this such a
mystery item?
Any MS people that may listen, this should be easy! I'm tired of hearing
that we should give up on RS and use Data Dynamics ActiveReports .NET. Why
can't we easily handle authentication and put these other programs to rest?
Our local intranet deployments are wonderful. Why can't we easily take them
further?
Thanks!
"Chris_CamSoft" wrote:
> Hello,
> We have an public site with a page now using ASP.NET 2.0 and the 2.0 Report
> Viewer control (we previously tried this with RS 2000 for many, many months).
> It is connecting to a (NAT'd FQDN) SQL2005 Report Server using default
> Windows authentication. There is a local user setup on the Report Server
> that I want this public site to connect as (I can do this by typing
> credentials). I do not want and can not have the pop-up windows
> authentication. HOW DO I AUTHENTICATE WITHOUT TYPING IN CREDENTIALS?
> We are a Gold Partner and would really appreciate a direct solution to this
> issue. There has been countless similar requests that come up on all kinds
> of searches, yet no direct solution. We don't need to know that you have to
> implement "IReportServerCredentials". Please provide an exact example of how
> this is accomplished. If you can provide it in VB.NET even better.
> Thanks.
>|||are you refering to something such as the following:
Dim RS As New ReportingService2005
RS.Credentials = System.Net.CredentialCache.DefaultCredentials
if so I would think that alone would be enough at least to lead you in the
right direction.
I am currently making that RS object to do various things to the report
itself and its our report so we really dont have credentials I dont think so
I am not sure how to expand from there.
We had a learning curve this morning on the IIS that runs the reporting
service but I dont think that is what you are refering to. In that case we
had to set to anynomous I believe although not sure things have been moving
fast here.
"Chris_CamSoft" wrote:
> Hello,
> We have an public site with a page now using ASP.NET 2.0 and the 2.0 Report
> Viewer control (we previously tried this with RS 2000 for many, many months).
> It is connecting to a (NAT'd FQDN) SQL2005 Report Server using default
> Windows authentication. There is a local user setup on the Report Server
> that I want this public site to connect as (I can do this by typing
> credentials). I do not want and can not have the pop-up windows
> authentication. HOW DO I AUTHENTICATE WITHOUT TYPING IN CREDENTIALS?
> We are a Gold Partner and would really appreciate a direct solution to this
> issue. There has been countless similar requests that come up on all kinds
> of searches, yet no direct solution. We don't need to know that you have to
> implement "IReportServerCredentials". Please provide an exact example of how
> this is accomplished. If you can provide it in VB.NET even better.
> Thanks.
>

Report Viewer - tell it not to run until parameters are entered

I have this reportviewer control in an asp.net page -
I've added a parameter of startdate
How do I change the properties of the ReportViewer control so that it waits
for the date input, and doesn't try to run when the page is loaded?
I keep getting this error when running the page:
a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
have the expected type.On Jan 18, 12:05 pm, "Elmo Watson" <s...@.here.com> wrote:
> I have this reportviewer control in an asp.net page -
> I've added a parameter of startdate
> How do I change the properties of the ReportViewer control so that it waits
> for the date input, and doesn't try to run when the page is loaded?
> I keep getting this error when running the page:
> a.. The property 'DefaultValue' of report parameter 'StartDate' doesn't
> have the expected type.
The easiest way to control the automatic running of the report is to
modify the SSRS report itself to not have a default value (set Default
Values to Null) for the startdate parameter. This should follow
through to the report viewer control. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultantsql

Report Timeout

I have a report I execute from an Asp.Net front-end. The report is rendered
directly to PDF via a web services call to the Reporting Services web
service. For this particular report, at exactly 3 minutes, the report always
aborts processing and redirects to a "Page Cannot Be Displayed". The Report
Server log file at this time shows IsClientConnected...Orphan Request
detected or something like that. When I run the report via Report Manager,
everything works fine. I do specify a timeout value of 2400000 in my Asp.Net
where I'm consuming the web service. I've looked at almost every other
timeout but since it works fine in Report Manager, I am inclined to believe
the problem is in my Asp.Net code. Any ideas?Open your Reporing service's web service reference file and in the
constructor
add: "this.Timeout=......"
Works for web service access method.
"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
>I have a report I execute from an Asp.Net front-end. The report is
>rendered
> directly to PDF via a web services call to the Reporting Services web
> service. For this particular report, at exactly 3 minutes, the report
> always
> aborts processing and redirects to a "Page Cannot Be Displayed". The
> Report
> Server log file at this time shows IsClientConnected...Orphan Request
> detected or something like that. When I run the report via Report
> Manager,
> everything works fine. I do specify a timeout value of 2400000 in my
> Asp.Net
> where I'm consuming the web service. I've looked at almost every other
> timeout but since it works fine in Report Manager, I am inclined to
> believe
> the problem is in my Asp.Net code. Any ideas?|||I'm not sure where this file is that you are referring to. Also, in my
Asp.Net where I am consuming the web service, I am doing the following:
Dim rs As New WebService (where WebService is the name of my reference to
the Reporting Service ws)
rs.Timeout = 2400000
"Oleg Yevteyev" wrote:
> Open your Reporing service's web service reference file and in the
> constructor
> add: "this.Timeout=......"
> Works for web service access method.
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
> >I have a report I execute from an Asp.Net front-end. The report is
> >rendered
> > directly to PDF via a web services call to the Reporting Services web
> > service. For this particular report, at exactly 3 minutes, the report
> > always
> > aborts processing and redirects to a "Page Cannot Be Displayed". The
> > Report
> > Server log file at this time shows IsClientConnected...Orphan Request
> > detected or something like that. When I run the report via Report
> > Manager,
> > everything works fine. I do specify a timeout value of 2400000 in my
> > Asp.Net
> > where I'm consuming the web service. I've looked at almost every other
> > timeout but since it works fine in Report Manager, I am inclined to
> > believe
> > the problem is in my Asp.Net code. Any ideas?
>
>|||Ok, I think you're talking about the Reference.vb file but I have no idea
where this timeout setting is supposed to go.
Adam
"Oleg Yevteyev" wrote:
> Open your Reporing service's web service reference file and in the
> constructor
> add: "this.Timeout=......"
> Works for web service access method.
> "AdamB" <AdamB@.discussions.microsoft.com> wrote in message
> news:290174E9-D359-4376-9EC7-591FC3421D74@.microsoft.com...
> >I have a report I execute from an Asp.Net front-end. The report is
> >rendered
> > directly to PDF via a web services call to the Reporting Services web
> > service. For this particular report, at exactly 3 minutes, the report
> > always
> > aborts processing and redirects to a "Page Cannot Be Displayed". The
> > Report
> > Server log file at this time shows IsClientConnected...Orphan Request
> > detected or something like that. When I run the report via Report
> > Manager,
> > everything works fine. I do specify a timeout value of 2400000 in my
> > Asp.Net
> > where I'm consuming the web service. I've looked at almost every other
> > timeout but since it works fine in Report Manager, I am inclined to
> > believe
> > the problem is in my Asp.Net code. Any ideas?
>
>|||"AdamB" <AdamB@.discussions.microsoft.com> wrote in message
news:D19C1C10-7F24-4834-9EAC-7A20650CE348@.microsoft.com...
> I'm not sure where this file is that you are referring to. Also, in my
> Asp.Net where I am consuming the web service, I am doing the following:
> Dim rs As New WebService (where WebService is the name of my reference to
> the Reporting Service ws)
> rs.Timeout = 2400000
Ok - seems like it is correct - just be sure to set that Timeout property on
every instance of "ws" you are creating.
More simple way is to open the reference file you correctly identified in
another post and place "rs.Timeout = 2400000"
in the constructor. In that case you wouldn't have to set that property on
every instance of "ws" you're creating.
I hope, you know what the constructor is.
There are a couple more places to check.
1. You can set in Page_Load method of your page
Server.ScriptTimeout=2400
2. Do it globally in machine.config or web.config
<configuration>
<system.web>
<httpRuntime executionTimeout="2400"
................................/>
in addtion of what you have already done.

Report Renderiring in EXCEL ..

I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
Plateform. - ASP .NET in a VB .NET Project.
I have disabled the EXCEL from my default renedering formats by placing
Visible="false" in RSReportServer.config file for EXCEL.
Now the problem is that I want one report to export to excel. How can I
achieve this without changing the above line?
If anyone could tell me about an article or example implementation of the
same. I will realy appreciate.Are you using SSRS in a custom application. Disabling visiblity on the config
file is for the whole reports and not for individual reports. In that case if
you are in a custome app. then you can use URL access for generating excel or
you can use render method of the rs web serives.
Amarnath
"Tanveer Malik" wrote:
> I am using Reporting Services 2000 Service Pack 2, on a .NET 2003
> Plateform. - ASP .NET in a VB .NET Project.
> I have disabled the EXCEL from my default renedering formats by placing
> Visible="false" in RSReportServer.config file for EXCEL.
> Now the problem is that I want one report to export to excel. How can I
> achieve this without changing the above line?
> If anyone could tell me about an article or example implementation of the
> same. I will realy appreciate.
>
>