Showing posts with label building. Show all posts
Showing posts with label building. Show all posts

Wednesday, March 28, 2012

ReportViewer 2005 InValidOperationException

Hi,

I am using VS 2005 and ReportViewer 2005 web control in ASP.NET 2.0 web application. I am building custom page to host reports in web application. The website is running under known NT account that has rights to the remote Reporting Server.

On the page I am using ReportService2005 web service to retrieve the list of available reports on the server and then trying to use ReportViewer control to display the selected report. I can connect to the remote Reporting Server through Web Service fine and able to retrieve all the data. I can also retrieve the report using the web service. However, when I set the URL and Report path in the ReportViewer control I get following error:

Exception: InValidOperationException

Message: Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

StackTrace: at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
at Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues)
at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

Initially I thought it could be security issue, but I am able to retireve all the data and report using web service. I believe the error is in the way ReportViewer control is trying to access the report. I am using NT authentication for reporting server and ReportViewerCredentials class is a custom class that used Default Net credentials. Below is the sample code I am using:

rvMain.ProcessingMode = ProcessingMode.Remote;

rvMain.ServerReport.ReportServerCredentials = new ReportViewerCredentials();

rvMain.ServerReport.ReportServerUrl = new Uri("http://testserver/reportserver?");

rvMain.ServerReport.ReportPath = "/Test/TestReport";

I have been striggling with this for a week now. I checked all the blogs and nothing matching this. All this works fine if the reporting server is local to the web application. I would appreciate any help on this.

Ashesh S.

hi,maybe this code example can give you help.

1) implements IReportServerCredentials Interface

public class ReportServerCrendential:IReportServerCredentials
{
// access information for remote reportserver
private string _UserID;
private string _PassWord;
private string _DomainName;

public ReportServerCrendential(string UserID,string Password,string Domain)
{
_UserID = UserID;
_PassWord = Password;
_DomainName = Domain;
}
public bool GetFormsCredentials(out System.Net.Cookie cookie, out string username, out string password, out string authority)
{
cookie = null;
username = password = authority = null;
return false;
}
public WindowsIdentity ImpersonationUser
{
get
{
return null;
}
}
// use this credential
public System.Net.ICredentials NetworkCredentials
{
get
{
return new System.Net.NetworkCredential(_UserID, _PassWord, _DomainName);
}
}

}

2) use this instead of rvMain.ServerReport.ReportServerCredentials = new ReportViewerCredentials();

ReportServerCrendential myCredential = new ReportServerCrendential(UserName, password , "");
rvMain.ServerReport.ReportServerCredentials = myCredential;

.....

rvMain.ServerReport.Refresh();

|||

I tried implementing the IReportServerCredentials as shown above to use username, password and domain. Still I get the same error.

Any help will be greatly appreciated, thanks!

|||

Hi Ashesh,

We are experiencing a similar problem. Did you ever resolve this issue?

Thanks,

Rob

|||

Rob,

No, still working on it. The Report Servers are in web farm using Enterprise Edition and the web application that connects to the report server is using the ReportViewer distrubutable from Microsoft site. I am wondering if the enterprise version has something to do with it. To confirm I am going to host the site on Report server and see if it works.

Trying all possible things. If you find anything let me know. I was hoping some Microsoft guys would answer this thread.

|||

Finally I figured out the issue. Since we are using a web farm environment, we go through Virtual IP to connect to the Reporting Server. The Reporting Service web service is able resolve the VIP, but Report Viewer control is not able to handle it. If I use the report server name in the url, the report displays fine in Report Viewer.

There has to be a way to make ReportViewer contorl work in web farm environment. I believe there are some config changes that you need to do to make it work with Virtual IP. Does anybody know what settings I need to do in config file?

ReportViewer 2005 InValidOperationException

Hi,

I am using VS 2005 and ReportViewer 2005 web control in ASP.NET 2.0 web application. I am building custom page to host reports in web application. The website is running under known NT account that has rights to the remote Reporting Server.

On the page I am using ReportService2005 web service to retrieve the list of available reports on the server and then trying to use ReportViewer control to display the selected report. I can connect to the remote Reporting Server through Web Service fine and able to retrieve all the data. I can also retrieve the report using the web service. However, when I set the URL and Report path in the ReportViewer control I get following error:

Exception: InValidOperationException

Message: Client found response content type of '', but expected 'text/xml'. The request failed with an empty response.

StackTrace: at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.Execution.RSExecutionConnection.LoadReport(String Report, String HistoryID)
at Microsoft.Reporting.WebForms.ServerReport.GetExecutionInfo()
at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
at Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport(Boolean useCurrentValues)
at Microsoft.Reporting.WebForms.ReportViewer.OnPreRender(EventArgs e)

Initially I thought it could be security issue, but I am able to retireve all the data and report using web service. I believe the error is in the way ReportViewer control is trying to access the report. I am using NT authentication for reporting server and ReportViewerCredentials class is a custom class that used Default Net credentials. Below is the sample code I am using:

rvMain.ProcessingMode = ProcessingMode.Remote;

rvMain.ServerReport.ReportServerCredentials = new ReportViewerCredentials();

rvMain.ServerReport.ReportServerUrl = new Uri("http://testserver/reportserver?");

rvMain.ServerReport.ReportPath = "/Test/TestReport";

I have been striggling with this for a week now. I checked all the blogs and nothing matching this. All this works fine if the reporting server is local to the web application. I would appreciate any help on this.

Ashesh S.

hi,maybe this code example can give you help.

1) implements IReportServerCredentials Interface

public class ReportServerCrendential:IReportServerCredentials
{
// access information for remote reportserver
private string _UserID;
private string _PassWord;
private string _DomainName;

public ReportServerCrendential(string UserID,string Password,string Domain)
{
_UserID = UserID;
_PassWord = Password;
_DomainName = Domain;
}
public bool GetFormsCredentials(out System.Net.Cookie cookie, out string username, out string password, out string authority)
{
cookie = null;
username = password = authority = null;
return false;
}
public WindowsIdentity ImpersonationUser
{
get
{
return null;
}
}
// use this credential
public System.Net.ICredentials NetworkCredentials
{
get
{
return new System.Net.NetworkCredential(_UserID, _PassWord, _DomainName);
}
}

}

2) use this instead of rvMain.ServerReport.ReportServerCredentials = new ReportViewerCredentials();

ReportServerCrendential myCredential = new ReportServerCrendential(UserName, password , "");
rvMain.ServerReport.ReportServerCredentials = myCredential;

.....

rvMain.ServerReport.Refresh();

|||

I tried implementing the IReportServerCredentials as shown above to use username, password and domain. Still I get the same error.

Any help will be greatly appreciated, thanks!

|||

Hi Ashesh,

We are experiencing a similar problem. Did you ever resolve this issue?

Thanks,

Rob

|||

Rob,

No, still working on it. The Report Servers are in web farm using Enterprise Edition and the web application that connects to the report server is using the ReportViewer distrubutable from Microsoft site. I am wondering if the enterprise version has something to do with it. To confirm I am going to host the site on Report server and see if it works.

Trying all possible things. If you find anything let me know. I was hoping some Microsoft guys would answer this thread.

|||

Finally I figured out the issue. Since we are using a web farm environment, we go through Virtual IP to connect to the Reporting Server. The Reporting Service web service is able resolve the VIP, but Report Viewer control is not able to handle it. If I use the report server name in the url, the report displays fine in Report Viewer.

There has to be a way to make ReportViewer contorl work in web farm environment. I believe there are some config changes that you need to do to make it work with Virtual IP. Does anybody know what settings I need to do in config file?

Wednesday, March 21, 2012

Reports without Dataset ?

Hi,

I want to create SQL reports without using typedDataset.

Here is my scenario..

I am building a 3-tier arch website. On my web layer I want to display few reports and as a datasource I want to use my business objects which lays in buisness layer classes as methods. These methods returns DataTable.

I want to use this methods as datasource for my reports without getting dataset in picture. My problem is that while desinging report, it is taking Dataset as default datasource and its building it in App code. I don't want this, instead, I want to point my reports to Object Data Source and ODS to my business objects.

Is it possible to get rid of DataSet completly while designing reports? If yes than How to do it?

Thanks in advance

Regards,

ND

Hi,

From your description, it seems that you want to use the dataset as the datasource of your report project, right?

Based on my understanding, you can create a webservice which returns the dataset, and then regard the dataset as the datasource of your report. And then, in that webservice, you can call the methods which comes from your business layer to get the data you need.

For detail:

1. Create a webservice project, and create a webmethod, and then add the reference of your business class, and invoke the methods to get the data, create an dataset which is used to contain the data from your business layer. After that, you should deploy the webservice in your IIS.
2. Create a reporting service project, and then crate a new datasource in the SharedDataSource, set the Type to XML, assign the connection String property with the webservice address you created just now.
3. Create a new report, assign the Query String as:
<Query xmlns="http://Eric.org/">
<SoapAction>http://Eric.org/GetDataSource</SoapAction>
</Query>

For more usage about QueryString, seehttp://msdn2.microsoft.com/en-us/library/ms345251.aspx

Thanks.

|||

Thanks for the details..

Actually I don't want to use Dataset for my reports, How to achieve this?

While designing reports, It always creates Dataset and then display all the fields from the connected source. Instead of that, I want something what you mentioned in your reply but, WITHOUT using XML.

My scenario is the same, Its 3-tiers application, Fetching data by using WebService methods.

Regards,

ND

Tuesday, March 20, 2012

reports running in VB.Net much slower than Visual Studio

I've been building reporting services reports for the last 6 months,
and we just got our reporting services server last week. I've started
deploying my reports to the reporting server, and I'm disappointed in
the speed of the reports in a VB.Net windows application. I'm running
the reports in remote processing mode (not local).
The reports generate much slower than they do in Visual Studio. The
reports generate REALLY slow, if the reports are viewed in print
layout mode. I'd like to be able to use the print layout view, so the
report will display the footers, page breaks, and page numbering
correctly.
The reports run great in Visual Studio. Does anyone have any
suggestions to make the reports in a VB.Net windows application run
like they do in Visual Studio? Can anyone explain why the performance
is so different between the two? Why does rendering the report in
print layout mode so much slower in VB vs. Visual Studio? Or should
it be the same?
I'm using reporting services 2005. Our reporting services server is
running on a separate server than our SQL database.The rendering engine is the same in VS 2005 development environment as that
on the server (this was not true in 2000 which is why sometimes you would
see some small differences). However, VS 2005 caches data. That can account
for some of the issues. Another issue is network transmission time. But, the
main time difference is when you preview in VS you are previewing html which
is many times faster than PDF or other types of formats.
RS shines at providing data quickly to the user. By deciding you want to
present a book (or an electronic paper report) you are not taking advantage
of the strengths of RS. The best way to design reports is to present 10-20
pages to the user (or less). Make extensive use of drill through (links that
pull up additional detail reports).
They are re-writing the rendering engine for 2008 and expect PDF (and other
formats) that are slow today to be quite a bit faster.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> I've been building reporting services reports for the last 6 months,
> and we just got our reporting services server last week. I've started
> deploying my reports to the reporting server, and I'm disappointed in
> the speed of the reports in a VB.Net windows application. I'm running
> the reports in remote processing mode (not local).
> The reports generate much slower than they do in Visual Studio. The
> reports generate REALLY slow, if the reports are viewed in print
> layout mode. I'd like to be able to use the print layout view, so the
> report will display the footers, page breaks, and page numbering
> correctly.
> The reports run great in Visual Studio. Does anyone have any
> suggestions to make the reports in a VB.Net windows application run
> like they do in Visual Studio? Can anyone explain why the performance
> is so different between the two? Why does rendering the report in
> print layout mode so much slower in VB vs. Visual Studio? Or should
> it be the same?
> I'm using reporting services 2005. Our reporting services server is
> running on a separate server than our SQL database.
>|||On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> The rendering engine is the same in VS 2005 development environment as that
> on the server (this was not true in 2000 which is why sometimes you would
> see some small differences). However, VS 2005 caches data. That can account
> for some of the issues. Another issue is network transmission time. But, the
> main time difference is when you preview in VS you are previewing html which
> is many times faster than PDF or other types of formats.
> RS shines at providing data quickly to the user. By deciding you want to
> present a book (or an electronic paper report) you are not taking advantage
> of the strengths of RS. The best way to design reports is to present 10-20
> pages to the user (or less). Make extensive use of drill through (links that
> pull up additional detail reports).
> They are re-writing the rendering engine for 2008 and expect PDF (and other
> formats) that are slow today to be quite a bit faster.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>
> > I've been building reporting services reports for the last 6 months,
> > and we just got our reporting services server last week. I've started
> > deploying my reports to the reporting server, and I'm disappointed in
> > the speed of the reports in a VB.Net windows application. I'm running
> > the reports in remote processing mode (not local).
> > The reports generate much slower than they do in Visual Studio. The
> > reports generate REALLY slow, if the reports are viewed in print
> > layout mode. I'd like to be able to use the print layout view, so the
> > report will display the footers, page breaks, and page numbering
> > correctly.
> > The reports run great in Visual Studio. Does anyone have any
> > suggestions to make the reports in a VB.Net windows application run
> > like they do in Visual Studio? Can anyone explain why the performance
> > is so different between the two? Why does rendering the report in
> > print layout mode so much slower in VB vs. Visual Studio? Or should
> > it be the same?
> > I'm using reporting services 2005. Our reporting services server is
> > running on a separate server than our SQL database.- Hide quoted text -
> - Show quoted text -
Thanks for your response. For the last 6 months I've been converting
excel reports to reporting services. Some of the reports are over 50
pages. I've been really pleased with creating these reports in
reporting services. The reports look much better than the original
Excel reports, and from start to finish it only take a few minutes to
generate a pdf, which we send to our clients.
Putting the reports online or in a windows application with user
interactivity would have been icing on the cake. I can change some of
my reports to have a drill down, but several of the reports need to
show all the detail together. It's too bad reporting services only
supports an HTML version for the web. HTML doesn't display the
footers, page breaks, and page numbering like the pdf files. It also
does a post back when paging through the report, which is really slow
for a report like mine.
Interactive reports would have been awesome for my reports, but
they're just too big. You said 2008 engine will be much faster. This
will be great for a windows application. Do you know if 2008 will
have a different format than HTML for the web? I haven't found much
information on reporting services for 2008.|||You can render however you want (html, pdf, excel). If you do PDF that will
show in the browser. In particular PDF will be much much faster (I've been
promised, I haven't seen). So your reports can be displayed in your VB app
with PDF and you will/should see substantial performance improvements with
2008.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
> On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> The rendering engine is the same in VS 2005 development environment as
>> that
>> on the server (this was not true in 2000 which is why sometimes you would
>> see some small differences). However, VS 2005 caches data. That can
>> account
>> for some of the issues. Another issue is network transmission time. But,
>> the
>> main time difference is when you preview in VS you are previewing html
>> which
>> is many times faster than PDF or other types of formats.
>> RS shines at providing data quickly to the user. By deciding you want to
>> present a book (or an electronic paper report) you are not taking
>> advantage
>> of the strengths of RS. The best way to design reports is to present
>> 10-20
>> pages to the user (or less). Make extensive use of drill through (links
>> that
>> pull up additional detail reports).
>> They are re-writing the rendering engine for 2008 and expect PDF (and
>> other
>> formats) that are slow today to be quite a bit faster.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <billyburd...@.gmail.com> wrote in message
>> news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>>
>> > I've been building reporting services reports for the last 6 months,
>> > and we just got our reporting services server last week. I've started
>> > deploying my reports to the reporting server, and I'm disappointed in
>> > the speed of the reports in a VB.Net windows application. I'm running
>> > the reports in remote processing mode (not local).
>> > The reports generate much slower than they do in Visual Studio. The
>> > reports generate REALLY slow, if the reports are viewed in print
>> > layout mode. I'd like to be able to use the print layout view, so the
>> > report will display the footers, page breaks, and page numbering
>> > correctly.
>> > The reports run great in Visual Studio. Does anyone have any
>> > suggestions to make the reports in a VB.Net windows application run
>> > like they do in Visual Studio? Can anyone explain why the performance
>> > is so different between the two? Why does rendering the report in
>> > print layout mode so much slower in VB vs. Visual Studio? Or should
>> > it be the same?
>> > I'm using reporting services 2005. Our reporting services server is
>> > running on a separate server than our SQL database.- Hide quoted text -
>> - Show quoted text -
> Thanks for your response. For the last 6 months I've been converting
> excel reports to reporting services. Some of the reports are over 50
> pages. I've been really pleased with creating these reports in
> reporting services. The reports look much better than the original
> Excel reports, and from start to finish it only take a few minutes to
> generate a pdf, which we send to our clients.
> Putting the reports online or in a windows application with user
> interactivity would have been icing on the cake. I can change some of
> my reports to have a drill down, but several of the reports need to
> show all the detail together. It's too bad reporting services only
> supports an HTML version for the web. HTML doesn't display the
> footers, page breaks, and page numbering like the pdf files. It also
> does a post back when paging through the report, which is really slow
> for a report like mine.
> Interactive reports would have been awesome for my reports, but
> they're just too big. You said 2008 engine will be much faster. This
> will be great for a windows application. Do you know if 2008 will
> have a different format than HTML for the web? I haven't found much
> information on reporting services for 2008.
>|||On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> You can render however you want (html, pdf, excel). If you do PDF that will
> show in the browser. In particular PDF will be much much faster (I've been
> promised, I haven't seen). So your reports can be displayed in your VB app
> with PDF and you will/should see substantial performance improvements with
> 2008.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
>
> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> The rendering engine is the same in VS 2005 development environment as
> >> that
> >> on the server (this was not true in 2000 which is why sometimes you would
> >> see some small differences). However, VS 2005 caches data. That can
> >> account
> >> for some of the issues. Another issue is network transmission time. But,
> >> the
> >> main time difference is when you preview in VS you are previewing html
> >> which
> >> is many times faster than PDF or other types of formats.
> >> RS shines at providing data quickly to the user. By deciding you want to
> >> present a book (or an electronic paper report) you are not taking
> >> advantage
> >> of the strengths of RS. The best way to design reports is to present
> >> 10-20
> >> pages to the user (or less). Make extensive use of drill through (links
> >> that
> >> pull up additional detail reports).
> >> They are re-writing the rendering engine for 2008 and expect PDF (and
> >> other
> >> formats) that are slow today to be quite a bit faster.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> <billyburd...@.gmail.com> wrote in message
> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> >> > I've been building reporting services reports for the last 6 months,
> >> > and we just got our reporting services server last week. I've started
> >> > deploying my reports to the reporting server, and I'm disappointed in
> >> > the speed of the reports in a VB.Net windows application. I'm running
> >> > the reports in remote processing mode (not local).
> >> > The reports generate much slower than they do in Visual Studio. The
> >> > reports generate REALLY slow, if the reports are viewed in print
> >> > layout mode. I'd like to be able to use the print layout view, so the
> >> > report will display the footers, page breaks, and page numbering
> >> > correctly.
> >> > The reports run great in Visual Studio. Does anyone have any
> >> > suggestions to make the reports in a VB.Net windows application run
> >> > like they do in Visual Studio? Can anyone explain why the performance
> >> > is so different between the two? Why does rendering the report in
> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
> >> > it be the same?
> >> > I'm using reporting services 2005. Our reporting services server is
> >> > running on a separate server than our SQL database.- Hide quoted text -
> >> - Show quoted text -
> > Thanks for your response. For the last 6 months I've been converting
> > excel reports to reporting services. Some of the reports are over 50
> > pages. I've been really pleased with creating these reports in
> > reporting services. The reports look much better than the original
> > Excel reports, and from start to finish it only take a few minutes to
> > generate a pdf, which we send to our clients.
> > Putting the reports online or in a windows application with user
> > interactivity would have been icing on the cake. I can change some of
> > my reports to have a drill down, but several of the reports need to
> > show all the detail together. It's too bad reporting services only
> > supports an HTML version for the web. HTML doesn't display the
> > footers, page breaks, and page numbering like the pdf files. It also
> > does a post back when paging through the report, which is really slow
> > for a report like mine.
> > Interactive reports would have been awesome for my reports, but
> > they're just too big. You said 2008 engine will be much faster. This
> > will be great for a windows application. Do you know if 2008 will
> > have a different format than HTML for the web? I haven't found much
> > information on reporting services for 2008.- Hide quoted text -
> - Show quoted text -
I know you can export in those different formats, but can you display
the reports in a different format other than HTML on the web? HTML
doesn't display correctly and you have to post back to the server to
move through the pages of the document.
Billy|||Sure. When you request the rendering you can specify the format. Plenty of
people go right to PDF (HTML is much faster currently).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<billyburditt@.gmail.com> wrote in message
news:1186175875.359497.281210@.g4g2000hsf.googlegroups.com...
> On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> wrote:
>> You can render however you want (html, pdf, excel). If you do PDF that
>> will
>> show in the browser. In particular PDF will be much much faster (I've
>> been
>> promised, I haven't seen). So your reports can be displayed in your VB
>> app
>> with PDF and you will/should see substantial performance improvements
>> with
>> 2008.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <billyburd...@.gmail.com> wrote in message
>> news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
>>
>> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
>> > wrote:
>> >> The rendering engine is the same in VS 2005 development environment as
>> >> that
>> >> on the server (this was not true in 2000 which is why sometimes you
>> >> would
>> >> see some small differences). However, VS 2005 caches data. That can
>> >> account
>> >> for some of the issues. Another issue is network transmission time.
>> >> But,
>> >> the
>> >> main time difference is when you preview in VS you are previewing html
>> >> which
>> >> is many times faster than PDF or other types of formats.
>> >> RS shines at providing data quickly to the user. By deciding you want
>> >> to
>> >> present a book (or an electronic paper report) you are not taking
>> >> advantage
>> >> of the strengths of RS. The best way to design reports is to present
>> >> 10-20
>> >> pages to the user (or less). Make extensive use of drill through
>> >> (links
>> >> that
>> >> pull up additional detail reports).
>> >> They are re-writing the rendering engine for 2008 and expect PDF (and
>> >> other
>> >> formats) that are slow today to be quite a bit faster.
>> >> --
>> >> Bruce Loehle-Conger
>> >> MVP SQL Server Reporting Services
>> >> <billyburd...@.gmail.com> wrote in message
>> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
>> >> > I've been building reporting services reports for the last 6 months,
>> >> > and we just got our reporting services server last week. I've
>> >> > started
>> >> > deploying my reports to the reporting server, and I'm disappointed
>> >> > in
>> >> > the speed of the reports in a VB.Net windows application. I'm
>> >> > running
>> >> > the reports in remote processing mode (not local).
>> >> > The reports generate much slower than they do in Visual Studio. The
>> >> > reports generate REALLY slow, if the reports are viewed in print
>> >> > layout mode. I'd like to be able to use the print layout view, so
>> >> > the
>> >> > report will display the footers, page breaks, and page numbering
>> >> > correctly.
>> >> > The reports run great in Visual Studio. Does anyone have any
>> >> > suggestions to make the reports in a VB.Net windows application run
>> >> > like they do in Visual Studio? Can anyone explain why the
>> >> > performance
>> >> > is so different between the two? Why does rendering the report in
>> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
>> >> > it be the same?
>> >> > I'm using reporting services 2005. Our reporting services server is
>> >> > running on a separate server than our SQL database.- Hide quoted
>> >> > text -
>> >> - Show quoted text -
>> > Thanks for your response. For the last 6 months I've been converting
>> > excel reports to reporting services. Some of the reports are over 50
>> > pages. I've been really pleased with creating these reports in
>> > reporting services. The reports look much better than the original
>> > Excel reports, and from start to finish it only take a few minutes to
>> > generate a pdf, which we send to our clients.
>> > Putting the reports online or in a windows application with user
>> > interactivity would have been icing on the cake. I can change some of
>> > my reports to have a drill down, but several of the reports need to
>> > show all the detail together. It's too bad reporting services only
>> > supports an HTML version for the web. HTML doesn't display the
>> > footers, page breaks, and page numbering like the pdf files. It also
>> > does a post back when paging through the report, which is really slow
>> > for a report like mine.
>> > Interactive reports would have been awesome for my reports, but
>> > they're just too big. You said 2008 engine will be much faster. This
>> > will be great for a windows application. Do you know if 2008 will
>> > have a different format than HTML for the web? I haven't found much
>> > information on reporting services for 2008.- Hide quoted text -
>> - Show quoted text -
> I know you can export in those different formats, but can you display
> the reports in a different format other than HTML on the web? HTML
> doesn't display correctly and you have to post back to the server to
> move through the pages of the document.
> Billy
>|||On Aug 3, 10:03 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
wrote:
> Sure. When you request the rendering you can specify the format. Plenty of
> people go right to PDF (HTML is much faster currently).
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <billyburd...@.gmail.com> wrote in message
> news:1186175875.359497.281210@.g4g2000hsf.googlegroups.com...
>
> > On Aug 1, 11:26 am, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> > wrote:
> >> You can render however you want (html, pdf, excel). If you do PDF that
> >> will
> >> show in the browser. In particular PDF will be much much faster (I've
> >> been
> >> promised, I haven't seen). So your reports can be displayed in your VB
> >> app
> >> with PDF and you will/should see substantial performance improvements
> >> with
> >> 2008.
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >> <billyburd...@.gmail.com> wrote in message
> >>news:1185982595.638219.275480@.19g2000hsx.googlegroups.com...
> >> > On Jul 26, 4:42 pm, "Bruce L-C [MVP]" <bruce_lcNOS...@.hotmail.com>
> >> > wrote:
> >> >> The rendering engine is the same in VS 2005 development environment as
> >> >> that
> >> >> on the server (this was not true in 2000 which is why sometimes you
> >> >> would
> >> >> see some small differences). However, VS 2005 caches data. That can
> >> >> account
> >> >> for some of the issues. Another issue is network transmission time.
> >> >> But,
> >> >> the
> >> >> main time difference is when you preview in VS you are previewing html
> >> >> which
> >> >> is many times faster than PDF or other types of formats.
> >> >> RS shines at providing data quickly to the user. By deciding you want
> >> >> to
> >> >> present a book (or an electronic paper report) you are not taking
> >> >> advantage
> >> >> of the strengths of RS. The best way to design reports is to present
> >> >> 10-20
> >> >> pages to the user (or less). Make extensive use of drill through
> >> >> (links
> >> >> that
> >> >> pull up additional detail reports).
> >> >> They are re-writing the rendering engine for 2008 and expect PDF (and
> >> >> other
> >> >> formats) that are slow today to be quite a bit faster.
> >> >> --
> >> >> Bruce Loehle-Conger
> >> >> MVP SQL Server Reporting Services
> >> >> <billyburd...@.gmail.com> wrote in message
> >> >>news:1185484622.910356.290840@.b79g2000hse.googlegroups.com...
> >> >> > I've been building reporting services reports for the last 6 months,
> >> >> > and we just got our reporting services server last week. I've
> >> >> > started
> >> >> > deploying my reports to the reporting server, and I'm disappointed
> >> >> > in
> >> >> > the speed of the reports in a VB.Net windows application. I'm
> >> >> > running
> >> >> > the reports in remote processing mode (not local).
> >> >> > The reports generate much slower than they do in Visual Studio. The
> >> >> > reports generate REALLY slow, if the reports are viewed in print
> >> >> > layout mode. I'd like to be able to use the print layout view, so
> >> >> > the
> >> >> > report will display the footers, page breaks, and page numbering
> >> >> > correctly.
> >> >> > The reports run great in Visual Studio. Does anyone have any
> >> >> > suggestions to make the reports in a VB.Net windows application run
> >> >> > like they do in Visual Studio? Can anyone explain why the
> >> >> > performance
> >> >> > is so different between the two? Why does rendering the report in
> >> >> > print layout mode so much slower in VB vs. Visual Studio? Or should
> >> >> > it be the same?
> >> >> > I'm using reporting services 2005. Our reporting services server is
> >> >> > running on a separate server than our SQL database.- Hide quoted
> >> >> > text -
> >> >> - Show quoted text -
> >> > Thanks for your response. For the last 6 months I've been converting
> >> > excel reports to reporting services. Some of the reports are over 50
> >> > pages. I've been really pleased with creating these reports in
> >> > reporting services. The reports look much better than the original
> >> > Excel reports, and from start to finish it only take a few minutes to
> >> > generate a pdf, which we send to our clients.
> >> > Putting the reports online or in a windows application with user
> >> > interactivity would have been icing on the cake. I can change some of
> >> > my reports to have a drill down, but several of the reports need to
> >> > show all the detail together. It's too bad reporting services only
> >> > supports an HTML version for the web. HTML doesn't display the
> >> > footers, page breaks, and page numbering like the pdf files. It also
> >> > does a post back when paging through the report, which is really slow
> >> > for a report like mine.
> >> > Interactive reports would have been awesome for my reports, but
> >> > they're just too big. You said 2008 engine will be much faster. This
> >> > will be great for a windows application. Do you know if 2008 will
> >> > have a different format than HTML for the web? I haven't found much
> >> > information on reporting services for 2008.- Hide quoted text -
> >> - Show quoted text -
> > I know you can export in those different formats, but can you display
> > the reports in a different format other than HTML on the web? HTML
> > doesn't display correctly and you have to post back to the server to
> > move through the pages of the document.
> > Billy- Hide quoted text -
> - Show quoted text -
I'll do some research on how to do this. Thanks for all your
responses.
Billy

Reports on medium trust host?

Hi, I am building a reporting tool for students and now I got ReportViewer to work greate, local on my PC. But when I load the app. to the server it dont work, and I understand that it is becuse my host only run "Medium trust".

Is there a way to make it work dispite the medium trust issue?

Or is there some other tool that work wiht my medium trust host?

Or am I doing something else wrong and the medium trust is no problem?

I talked to the support and they never heard of any customer having problems wiht reports... I use one of the biggest hosts in Sweden (loopia).

I use vwd 2005 express, vb, accessdatabase, MS ReportViewer. And what I want is to present how many hours each person spent on a few given tasks each week and sum it up and maybe get some % and in the end hopefully a chart, the chart is not nessecerly.

My error:

Parser Error Message:Could not load file or assembly 'Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.

please help

sinserly

chris


Hi,

From the error message you provided, it seems that the cause of the problem is that the system can't load the assembly which needed for your application.

So what I suggest is to check if the assembly "Microsoft.ReportViewer.WebForms.dll" has existed on the server and if it can be found in your /bin subfolder.

Thanks.

|||

Ok thanks, that is ok now. But now I get a worse one, is there a way around it?

Server Error in '/' Application.

Required permissions cannot be acquired.

Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details:System.Security.Policy.PolicyException: Required permissions cannot be acquired.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.


Stack Trace:

[PolicyException: Required permissions cannot be acquired.]
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Boolean checkExecutionPermission) +2709488
System.Security.SecurityManager.ResolvePolicy(Evidence evidence, PermissionSet reqdPset, PermissionSet optPset, PermissionSet denyPset, PermissionSet& denied, Int32& securitySpecialFlags, Boolean checkExecutionPermission) +57

[FileLoadException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0
System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211
System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141
System.Reflection.Assembly.Load(String assemblyString) +25
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32

[ConfigurationErrorsException: Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596
System.Web.Configuration.CompilationSection.LoadAllAssembliesFromAppDomainBinDirectory() +3596761
System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +46
System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177
System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180
System.Web.Compilation.CodeDirectoryCompiler.GetCodeDirectoryAssembly(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories, Boolean isDirectoryAllowed) +350
System.Web.Compilation.BuildManager.CompileCodeDirectory(VirtualPath virtualDir, CodeDirectoryType dirType, String assemblyName, StringSet excludedSubdirectories) +125
System.Web.Compilation.BuildManager.CompileCodeDirectories() +525
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +448

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57
System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612
System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521

[HttpException (0x80004005): Could not load file or assembly 'Microsoft.ReportViewer.Common, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Failed to grant minimum permission requests. (Exception from HRESULT: 0x80131417)]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275



Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Monday, March 12, 2012

Reports building from SQL SERVER 2000 and .NET 1.1

Dear all

I would like to produce a report on the data i have in my database probably in a pdf or excel or word document. What i have is SQL Server 2000 with .NET 1.1 platform.

Is there anything out there i could use?

I have done some work on reporting services but thats with SQL server 2005, but now i have to go a bit back.

Any advice?

cheers

Or is there any other solution to the problem or producing reports in excel/word/pdf formats except for using Reporting services or crystal reports?

|||

You need SQL Server 2000 Enterprise edition or Developer edition it helps to have server operating systems, remember not to answer Windows questions unless you are forced or relevant questions, this is one of the hardest things to install, Windows ask stupid questions and stop your installation. The two links below covers all you need, the download is in the first link. Hope this helps.

http://www.microsoft.com/sql/prodinfo/previousversions/default.mspx

http://www.15seconds.com/Issue/041013.htm

Wednesday, March 7, 2012

ReportingServic process memory consumption

Hi in my task manager i notice that ReportingServic process has been building
up in memory consumption. Is this supposed to happen?Running reports in SQL 2k and in the future Yukon require that the entire
data set be instantiated in memory... In my opinion this is a shortcoming of
the product, since you can (and maybe will) get out of memory errors, and
IIS will reset the task.
The data must be in memory so that grouping and sorting in the report can
occur... In future versions I expect that MS will add some functionality to
allow the "plan" to become smarter to use a firehose cursor under conditions
which require no grouping or sorting outside of the database query.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:AA003D3E-0B3F-4F59-9B9E-0F1C9645B115@.microsoft.com...
> Hi in my task manager i notice that ReportingServic process has been
> building
> up in memory consumption. Is this supposed to happen?|||So the dataset stays in memory? Is there a way to release it after a certain
amount of time?
"Wayne Snyder" wrote:
> Running reports in SQL 2k and in the future Yukon require that the entire
> data set be instantiated in memory... In my opinion this is a shortcoming of
> the product, since you can (and maybe will) get out of memory errors, and
> IIS will reset the task.
> The data must be in memory so that grouping and sorting in the report can
> occur... In future versions I expect that MS will add some functionality to
> allow the "plan" to become smarter to use a firehose cursor under conditions
> which require no grouping or sorting outside of the database query.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> news:AA003D3E-0B3F-4F59-9B9E-0F1C9645B115@.microsoft.com...
> > Hi in my task manager i notice that ReportingServic process has been
> > building
> > up in memory consumption. Is this supposed to happen?
>
>