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 works fine on VS.NET 2003, get error when uploaded

Hello,

I created a report and use stored procedure to retrieve data. The report works perfect on VS.NET 2003 IDE. But when I upload the .rdl file to the report server, it doesn't work. The error msg I got is:

Reporting Services Error

---

An error has occurred during report processing. (rsProcessingAborted)Get Online HelpQuery execution failed for data set 'dsTransTime'. (rsErrorExecutingCommand)Get Online HelpProcedure 'usp_RPT_Procedure_Name' expects parameter '@.Parameter1', which was not supplied.

---

Anyone know the problem?
Thanks,Finally, I make it works. But I still don't know how I made it.
I cannot find a similiar errors from google. So everything I did is based on guess. Becasuse the error msg shows the report cannot take the parameter, I removed the parameter and re-created it again. Also, I use refresh button on the Data view to refresh the dataset.

Sometime I feel waired about Reporting services.

Report with Multiple Data sources: Can I do this?

Okay, so I have this ADO.NET dataset defined in my project. I created
an RDLC report and from the menu Report->Data Sources... I chose two
different tables that exist in my ADO dataset. So far so good. At this
point I can drag specific columns into various text boxes I have in my
report (I'm not using tables) and I end up with entries like
"=First(Fields!ContactName.Value)". That's all well and good, but what
I was hoping to do, in addition to that, is something where I can
specify a particular record from one of the tables. Basically what I
have is a table that has two different links to another table. Now
each of those links may be to the same record, or to two different
records. I have a "Job" table and a "Company" table. The Job table has
a link to a "Dealer" and an "Installer" (both of which are records--or
the same record--in the Company table). I was hoping to be able to
display the installer name in one text box and the dealer name in
another. I have two issues: I don't know how to refer to a specific
table when referring to a particular field (both the Job and Company
tables have a "ContactName" column), nor does there appear to be a way
to pick a particular record. I can't seem to be able to do something
like "=Fields!Job.ContactName.Value" when I want to refer to the
ContactName in the Job table as opposed to the Company table. Further,
I can't figure out how to do something like (kinda pseudo code here)
"=Fields!Company.ContactName WHERE Company.ID == First(Fields!
Job.InstallerID.Value)"
So it comes down to this: Can I do anything like what I have described
above? If I can't, my next thought it to create a stored procedure
that gets every value I need and stores it in a custom named field so
I have JobContactName, InstallerContactName, etc to refer to, but then
my next question is can I define a stored procedure that will let me
grab the data I'm looking for from my in-memory ADO.NET Dataset?So I discovered that using subreports would solve my immediate
problem, but I'm still curious if there is a way to do some of what I
describe above, which is: access each different datasource via Fields,
and access specific rows in that source. Right now we can access First/
Last and what ever is chosen as the default when you don't specify
First or Last, but why can't we access a specific record based on the
value of a field in that record? I just want to know if any/all of the
above is possible or not, and if not, what are the patterns people
follow to get around these limitations?
Thanks!

Report vs software

Hello,
I'm new in this issue of reporting.
Can some one tell me if is it necessary the installation of Visual Studio
.NET in the PC of a end user so he can exctract dinamic reports?
Besta Regars
ThanksA web navigator would be enough !
"Zurga" <Zurga@.discussions.microsoft.com> a écrit dans le message de news:
F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>|||You need to install Visual Studio to perform report design but an end user
would normally only need a web browser (internet explorer) to view, print
and export report data.
Good luck!
Dan
"Zurga" <Zurga@.discussions.microsoft.com> wrote in message
news:F36D4C94-FD59-4B25-B29A-9637B89DB1AA@.microsoft.com...
> Hello,
> I'm new in this issue of reporting.
> Can some one tell me if is it necessary the installation of Visual Studio
> .NET in the PC of a end user so he can exctract dinamic reports?
> Besta Regars
> Thanks
>

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 send print job with a large memory

i am using reporting service 2005 and report viewer from vs.net 2005.

when i send a print job from report view to HP Laserjet 1320, there print job is actually abt 20MB for 20 pages.

it happends that the printer will hav problem printing the print job or just hang there..

is there any way to resolve it?

There was an issue with 2005 that the print control did not get updated correctly if you had the 2000 print control. Is it possible that you have the 2000 print control on the client? If so, you can clear the control from the client by going to Tools->Internet Options->Settings->View Objects in IE, then delete the RSPrintControl. The next time you go to use the print control a new one should be downloaded.

Report Viewer Redistribution

I am creating a .NET WinForm app and would like to include the files required for the ReportViewer component (SP1). Can someone tell me where I can find these files? Also, can I simply drop these files in the folder where the rest of my app is going to reside, or does an installation have to take place?

Thanks - Amos.

http://prologika.com/CS/blogs/blog/archive/2007/03/27/report-viewer-sp1-redistributables.aspx|||

Teo,

Is the ReportViewer.Exe file the only alternative I have if I want to install the Viewer as part of my application? I would rather not force my uses to install my application and then install ReportViewer.Exe as a separate install step.

Amos.

|||You can drop the ReportViewer assemblies in your application bin folder.|||

Teo,

That was the point of my original question. What are all the required assemblies, and where are they? When I ran the ReportViewer.exe, it installed the assemblies but I couldn't tell what they were or where they went.

Amos.

|||

I appologize for missing your point. Go to GAC (C:\Windows\assembly). The assemblies whose names start with Microsoft.ReportViewer.* are the ReportViewer assemblies. There are six of them but depends on the your application technology you won't need all of them, e.g. you won't need the WebDesign and WebForms assemblies with Windows Forms applications.

To extract the assemblies from GAC you can use the GACViewer utility.

|||

Teo,

Thank you very much!

Amos.

Report Viewer Redistribution

I am creating a .NET WinForm app and would like to include the files required for the ReportViewer component (SP1). Can someone tell me where I can find these files? Also, can I simply drop these files in the folder where the rest of my app is going to reside, or does an installation have to take place?

Thanks - Amos.

http://prologika.com/CS/blogs/blog/archive/2007/03/27/report-viewer-sp1-redistributables.aspx|||

Teo,

Is the ReportViewer.Exe file the only alternative I have if I want to install the Viewer as part of my application? I would rather not force my uses to install my application and then install ReportViewer.Exe as a separate install step.

Amos.

|||You can drop the ReportViewer assemblies in your application bin folder.|||

Teo,

That was the point of my original question. What are all the required assemblies, and where are they? When I ran the ReportViewer.exe, it installed the assemblies but I couldn't tell what they were or where they went.

Amos.

|||

I appologize for missing your point. Go to GAC (C:\Windows\assembly). The assemblies whose names start with Microsoft.ReportViewer.* are the ReportViewer assemblies. There are six of them but depends on the your application technology you won't need all of them, e.g. you won't need the WebDesign and WebForms assemblies with Windows Forms applications.

To extract the assemblies from GAC you can use the GACViewer utility.

|||

Teo,

Thank you very much!

Amos.

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 for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
This is installed in the folder YoursQLInstallfolder\Reporting
Services\Samples\Applications\ReportViewer.
But for windows applications why not use the web browser control? Add it to
your Windows project toolbox by doing Tools,Add/Remove Toolbox Items select
COM Components tab, then put a checkbox against Microsoft Web Browser
(filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox. Now
add it to your Windows form; the default name for the control when added is
AxWebBrowser1.
Now you can do:
axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
for example:
axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
Reports/Territory Sales Drilldown")
HTH
Charles Kangai, MCT, MCDBA
"Ed Willis" wrote:
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>
>
>|||That's great I was able to bring the report up. I cannot get the export to
excel to work. If I click Open after clicking on the export nothing happens.
Is there security problems with exporting?
Thanks.
"Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
news:790C7718-0D03-40B1-9BC0-CC4DD08BDD51@.microsoft.com...
> Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
> This is installed in the folder YoursQLInstallfolder\Reporting
> Services\Samples\Applications\ReportViewer.
> But for windows applications why not use the web browser control? Add it
> to
> your Windows project toolbox by doing Tools,Add/Remove Toolbox Items
> select
> COM Components tab, then put a checkbox against Microsoft Web Browser
> (filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox.
> Now
> add it to your Windows form; the default name for the control when added
> is
> AxWebBrowser1.
> Now you can do:
> axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
> for example:
> axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
> Reports/Territory Sales Drilldown")
> HTH
> Charles Kangai, MCT, MCDBA
> "Ed Willis" wrote:
>> Is there a report viewer for a window application? I need to plug a
>> report
>> into a Vb.Net windows app.
>> Thanks.
>>
>>|||You need to call the web service's Render method. This creates an array of
bytes that you can write to a file. The Render method accepts a format
parameter.
This is what you need to do:
1) add the Reporting Services web reference to your project. The web
reference is http://Yourserver/ReportServer/ReportService.asmx
when you add it, you have to give it a name, such as RServer.
2) At the top of your form window code add:
Imports YourProjectName.RServer
Imports System.IO
3) declare and create an instance of the Reporting Service. I like to do it
at form level, within the Form1 class:
dim rs as New ReportingService
4) Assuming you are using code behind button to export to excel:
private sub Button1_Click(...)
dim historyid as string = nothing
dim deviceinfo as string = nothing
dim paramvalues() as ParameterValue = nothing
dim credentials() as DataSourceCredentials = nothing
dim showhide as string = nothing
dim encoding as string = nothing
dim mimetype as string = nothing
dim warnings() as Warning = nothing
dim paramsused() as ParameterValue
dim streamids() as string = nothing
dim myRenderedReport as byte() = _
rs.Render("/Sample Reports/Territory Sales DrillDown", "EXCEL", historyid,
deviceinfo, paramvalues, credentials, showhide, encoding, mimetype,
paramsused, warnings, streamids)
dim fs as FileStream = File.OpenWrite("c:\MyFile.xls")
fs.Write(myRenderedReport, 0, myRenderedReport.Length())
fs.Close()
End Sub
you can do:
dim myRenderedReport as byte[] = TheWebService.Render(FullReportPath, "EXCEL")
dim myFileStream as filestream
"Ed Willis" wrote:
> That's great I was able to bring the report up. I cannot get the export to
> excel to work. If I click Open after clicking on the export nothing happens.
> Is there security problems with exporting?
> Thanks.
> "Charles Kangai" <CharlesKangai@.discussions.microsoft.com> wrote in message
> news:790C7718-0D03-40B1-9BC0-CC4DD08BDD51@.microsoft.com...
> > Yes, there is a ReportViewer.dll which is great for ASP.NET applications.
> > This is installed in the folder YoursQLInstallfolder\Reporting
> > Services\Samples\Applications\ReportViewer.
> >
> > But for windows applications why not use the web browser control? Add it
> > to
> > your Windows project toolbox by doing Tools,Add/Remove Toolbox Items
> > select
> > COM Components tab, then put a checkbox against Microsoft Web Browser
> > (filename c:\windows\system32\shdocvw.dll). This adds it to your toolbox.
> > Now
> > add it to your Windows form; the default name for the control when added
> > is
> > AxWebBrowser1.
> >
> > Now you can do:
> > axWebBrowser1.Navigate("http://MyServer/ReportServer?" & reportPath)
> >
> > for example:
> > axWebBrowser1.Navigate("http://MyServer/ReportServer?/Sample
> > Reports/Territory Sales Drilldown")
> >
> > HTH
> >
> > Charles Kangai, MCT, MCDBA
> >
> > "Ed Willis" wrote:
> >
> >> Is there a report viewer for a window application? I need to plug a
> >> report
> >> into a Vb.Net windows app.
> >>
> >> Thanks.
> >>
> >>
> >>
> >>
> >>
>
>|||A ReportViewer control will be available in Visual Studio 2005 (aka
Whidbey). Whidbey Beta 1 does not have the ReportViewer control, but Beta 2,
scheduled for early 2005, will contain the control. There will be a WinForms
version and a WebForms version. The ReportViewer control will have built-in
ability to process and render reports, which means a Report Server is
unnecessary. If a Report Server is available then the controls will be able
to connect to the Report Server to view reports that are stored and
processed on the Report Server. Licensing has not been finalized, but we are
looking into making this control freely redistributable.
--
Rajeev Karunakaran [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:etizP1j1EHA.1524@.TK2MSFTNGP09.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.
Have you Googled this topic? There are many reporting controls available.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Have you Googled this topic? There are many reporting controls available.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Report Viewer for a Windows application

Is there a report viewer for a window application? I need to plug a report
into a Vb.Net windows app.
Thanks.Have you Googled this topic? There are many reporting controls available.
--
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
--
"Ed Willis" <ed_willis@.acsi.orgnospam> wrote in message
news:uPBYERj1EHA.3840@.tk2msftngp13.phx.gbl...
> Is there a report viewer for a window application? I need to plug a report
> into a Vb.Net windows app.
> Thanks.
>

Report Viewer Control to display reports

I have reports designed and deployed at the report server running Sql 2005
SSRS. I want to display those report in a vb.net Windows application using a
report viewer control and I have searched the internet for the past 2 weeks
and I still can not find anything or samples on how to do this. I wonder if
it is doable. Thanks.Paul,
You should find the report viewer reference at
http://msdn2.microsoft.com/en-us/library/microsoft.reporting.winforms(vs.80).aspx .
However, if you want just to show a predefined report for the end users,
Visual Studio offers the basic settings for the control, such as Report
server and report name. It is not a big magic :)
I got this sample, hope it will help for you.
http://www.devx.com/dotnet/Article/30424
Regards,
Janos
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>|||Some great samples at http://www.gotreportviewer.com
--
Andy Potter
blog : http://sqlreportingservices.spaces.live.com
info@.(NOSPAM)lakeclaireenterprises.com
"Paul" <paul_mak@.shaw.ca> wrote in message
news:O2CwgFviHHA.5052@.TK2MSFTNGP05.phx.gbl...
>I have reports designed and deployed at the report server running Sql 2005
>SSRS. I want to display those report in a vb.net Windows application using
>a report viewer control and I have searched the internet for the past 2
>weeks and I still can not find anything or samples on how to do this. I
>wonder if it is doable. Thanks.
>

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