I have seen this issue posted a few times in the forum, but have not
any replies or solutions...
In Report Viewer, the report is listed as having 10 pages both in the
Report Viewer navigation bar and in my footer (="Page " &
Globals!PageNumber & " of " & Globals!TotalPages).
When the report is printed; however, it prints as 19 pages with the
footer stating "Page xx of 19"
Both the interactive size and page size are set at 11in, 8.5in.
It seems especially problematic when the report contains a matrix.
Any way of getting these numbers to synch?
Thanks!Were you able to figure this out?
I have the same problem. We export the reports to pdf. None of the
three (HTML, Print Preview, pdf) has the same number of pages. Does the
Interactive size do anything?
JJodon wrote:
> I have seen this issue posted a few times in the forum, but have not
> any replies or solutions...
> In Report Viewer, the report is listed as having 10 pages both in the
> Report Viewer navigation bar and in my footer (="Page " &
> Globals!PageNumber & " of " & Globals!TotalPages).
> When the report is printed; however, it prints as 19 pages with the
> footer stating "Page xx of 19"
> Both the interactive size and page size are set at 11in, 8.5in.
> It seems especially problematic when the report contains a matrix.
> Any way of getting these numbers to synch?
> Thanks!
Showing posts with label viewer. Show all posts
Showing posts with label viewer. Show all posts
Wednesday, March 21, 2012
Monday, March 12, 2012
Reporting Service question
I have seen the article "Integrating Reporting Services into Your Application"
It seems that we can use report by report viewer with report server or embed
locally
If the report embed local without the use of report server. We do not need
to have sql server 2005 right, if i just have 2000, we can still use
reporting service 2005 right?The new controls which allow local reports come with Visual Studio 2005. You
have the ability to create a report in VS 2005 and use them in local mode
with no server, no license.
If you use them in server mode you need RS 2005.
You can develop a report in RS 2005 and change the extension and use it in
local mode, you cannot do this with RS 2000.
So, basically, there is nothing you can do with RS 2000 with the new
controls. Either you have no Reporting Services and just use the
capabilities in Visual Studio to develop the reports and use local mode, or
you need RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
>I have seen the article "Integrating Reporting Services into Your
>Application"
> It seems that we can use report by report viewer with report server or
> embed
> locally
> If the report embed local without the use of report server. We do not
> need
> to have sql server 2005 right, if i just have 2000, we can still use
> reporting service 2005 right?|||1.)
If i use reporting service in local mode, then i don't need to have sql
server 2005 right?
2.)
what differences between vs.net express and vs.net professional in the
functionality of reporting service?
3.)
If i use vs.net professional edition, i don't need to install anything for
develop reporting service local mode?
"Bruce L-C [MVP]" wrote:
> The new controls which allow local reports come with Visual Studio 2005. You
> have the ability to create a report in VS 2005 and use them in local mode
> with no server, no license.
> If you use them in server mode you need RS 2005.
> You can develop a report in RS 2005 and change the extension and use it in
> local mode, you cannot do this with RS 2000.
> So, basically, there is nothing you can do with RS 2000 with the new
> controls. Either you have no Reporting Services and just use the
> capabilities in Visual Studio to develop the reports and use local mode, or
> you need RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
> >I have seen the article "Integrating Reporting Services into Your
> >Application"
> > It seems that we can use report by report viewer with report server or
> > embed
> > locally
> > If the report embed local without the use of report server. We do not
> > need
> > to have sql server 2005 right, if i just have 2000, we can still use
> > reporting service 2005 right?
>
>|||See in-line.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:6974B497-BC44-4882-8722-1930D3CEE2CE@.microsoft.com...
> 1.)
> If i use reporting service in local mode, then i don't need to have sql
> server 2005 right?
Correct.>
> 2.)
> what differences between vs.net express and vs.net professional in the
> functionality of reporting service?
I don't know about this. Does vs.net come with the report controls? Sorry,
not familiar with vs.net express. I use vs.net professional.
> 3.)
> If i use vs.net professional edition, i don't need to install anything for
> develop reporting service local mode?
VS.Net professional comes with the new report controls. One for winforms and
one for webforms. You have everything you need to develop reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>
>
>
>
> "Bruce L-C [MVP]" wrote:
>> The new controls which allow local reports come with Visual Studio 2005.
>> You
>> have the ability to create a report in VS 2005 and use them in local mode
>> with no server, no license.
>> If you use them in server mode you need RS 2005.
>> You can develop a report in RS 2005 and change the extension and use it
>> in
>> local mode, you cannot do this with RS 2000.
>> So, basically, there is nothing you can do with RS 2000 with the new
>> controls. Either you have no Reporting Services and just use the
>> capabilities in Visual Studio to develop the reports and use local mode,
>> or
>> you need RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joe" <Joe@.discussions.microsoft.com> wrote in message
>> news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
>> >I have seen the article "Integrating Reporting Services into Your
>> >Application"
>> > It seems that we can use report by report viewer with report server or
>> > embed
>> > locally
>> > If the report embed local without the use of report server. We do not
>> > need
>> > to have sql server 2005 right, if i just have 2000, we can still use
>> > reporting service 2005 right?
>>
It seems that we can use report by report viewer with report server or embed
locally
If the report embed local without the use of report server. We do not need
to have sql server 2005 right, if i just have 2000, we can still use
reporting service 2005 right?The new controls which allow local reports come with Visual Studio 2005. You
have the ability to create a report in VS 2005 and use them in local mode
with no server, no license.
If you use them in server mode you need RS 2005.
You can develop a report in RS 2005 and change the extension and use it in
local mode, you cannot do this with RS 2000.
So, basically, there is nothing you can do with RS 2000 with the new
controls. Either you have no Reporting Services and just use the
capabilities in Visual Studio to develop the reports and use local mode, or
you need RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
>I have seen the article "Integrating Reporting Services into Your
>Application"
> It seems that we can use report by report viewer with report server or
> embed
> locally
> If the report embed local without the use of report server. We do not
> need
> to have sql server 2005 right, if i just have 2000, we can still use
> reporting service 2005 right?|||1.)
If i use reporting service in local mode, then i don't need to have sql
server 2005 right?
2.)
what differences between vs.net express and vs.net professional in the
functionality of reporting service?
3.)
If i use vs.net professional edition, i don't need to install anything for
develop reporting service local mode?
"Bruce L-C [MVP]" wrote:
> The new controls which allow local reports come with Visual Studio 2005. You
> have the ability to create a report in VS 2005 and use them in local mode
> with no server, no license.
> If you use them in server mode you need RS 2005.
> You can develop a report in RS 2005 and change the extension and use it in
> local mode, you cannot do this with RS 2000.
> So, basically, there is nothing you can do with RS 2000 with the new
> controls. Either you have no Reporting Services and just use the
> capabilities in Visual Studio to develop the reports and use local mode, or
> you need RS 2005.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
> >I have seen the article "Integrating Reporting Services into Your
> >Application"
> > It seems that we can use report by report viewer with report server or
> > embed
> > locally
> > If the report embed local without the use of report server. We do not
> > need
> > to have sql server 2005 right, if i just have 2000, we can still use
> > reporting service 2005 right?
>
>|||See in-line.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:6974B497-BC44-4882-8722-1930D3CEE2CE@.microsoft.com...
> 1.)
> If i use reporting service in local mode, then i don't need to have sql
> server 2005 right?
Correct.>
> 2.)
> what differences between vs.net express and vs.net professional in the
> functionality of reporting service?
I don't know about this. Does vs.net come with the report controls? Sorry,
not familiar with vs.net express. I use vs.net professional.
> 3.)
> If i use vs.net professional edition, i don't need to install anything for
> develop reporting service local mode?
VS.Net professional comes with the new report controls. One for winforms and
one for webforms. You have everything you need to develop reports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
>
>
>
>
> "Bruce L-C [MVP]" wrote:
>> The new controls which allow local reports come with Visual Studio 2005.
>> You
>> have the ability to create a report in VS 2005 and use them in local mode
>> with no server, no license.
>> If you use them in server mode you need RS 2005.
>> You can develop a report in RS 2005 and change the extension and use it
>> in
>> local mode, you cannot do this with RS 2000.
>> So, basically, there is nothing you can do with RS 2000 with the new
>> controls. Either you have no Reporting Services and just use the
>> capabilities in Visual Studio to develop the reports and use local mode,
>> or
>> you need RS 2005.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Joe" <Joe@.discussions.microsoft.com> wrote in message
>> news:5E6E889E-4DD2-4B1F-B498-AFE58680F594@.microsoft.com...
>> >I have seen the article "Integrating Reporting Services into Your
>> >Application"
>> > It seems that we can use report by report viewer with report server or
>> > embed
>> > locally
>> > If the report embed local without the use of report server. We do not
>> > need
>> > to have sql server 2005 right, if i just have 2000, we can still use
>> > reporting service 2005 right?
>>
Wednesday, March 7, 2012
Reporting Service - print button shown on IE not shown on Firefox
Hi, I have my web application on which I use the ReportViewer to call a Server Report. I fill the report viewer and I see the report correctly on the IE 7, however on the Firefox the Print button does not appear, only the refresh. On the .Net the printButton is set to visible, just on Firefox does not appear...any one had this issue?Thanks a lot for helping!
Our friends at microsoft have decided to make the print function an ActiveX control, supported only by IE
Saturday, February 25, 2012
Reporting Server 2000 Authentication Issue
Hi,
I have installed the eval version of Reporting Services 2000 on my pc. And i've used the report viewer control to view the report on a ASP.NET Page. When i view that .ASPX page, i get a windows authentication window before it opens the actual report.
Is there any way to disable this windows authentication dialouge box?
Regards,
PS: in the viewer i gave the path of the report as http://localhost/Rerport/ABC.rdl
I also tried with the ip address in place of localhost.
The ReportViewer control that ships with Visual Studio 2005 does not support Reporting Services 2000.
-Lukasz
Tuesday, February 21, 2012
reporting licensing
We recently purchased Stockamp's Clinic Ontrac system. The system has a built in crystal reports viewer module with capability to add our own reports... The backend of the product is SQL Server. To create a report you have to potentially create a stored procedure - if parameter is needed - and a crystal report. Stockamp is requesting that we have written approval of these reports as well as any ad-hoc reports and queries that we run before we run them in the production environment.
I'm used to large vendors (those that understand a database is only as good as the data you get out of it) and I've never seen a license agreement like this before. Is this common?What they are trying to do is to ensure that by creating a report you're not going to impact the production environment in such a way that they may be blamed for poor performance while your report is being generated. Also, since they introduced a "report writer," this means that there are not many "canned" reports in the system that they sold you, and they are trying to piggy-bag on your reports and incorporate them in the next release as "canned" reports.|||If possible, you should consider replicating your data on a dedicated report server. This will avoid potential performance issues.|||Unfortunately the data changes constantly, and I suspect if they won't let me add reports, they won't let me replicate. It took me over 2 months to convince them we needed a seperate test server as making a modification to their system (using their own forms and an approved process) required a 4 hour import that completely paralized the system.
The database tables have grown from 2000 rows 9 months ago to over 21 million, so reporting out of the system will soon become too cpu intensive anyway.
I'd love to work with the vendor and introduce them to datawarehouseing, but they're product is so fragile and Stockamp & Associates employees are so unwilling to listen, that I given up on a friendly working relationship.
So the moral is to avoid software with a canned report viewer, regardless of its backend system.
I'm used to large vendors (those that understand a database is only as good as the data you get out of it) and I've never seen a license agreement like this before. Is this common?What they are trying to do is to ensure that by creating a report you're not going to impact the production environment in such a way that they may be blamed for poor performance while your report is being generated. Also, since they introduced a "report writer," this means that there are not many "canned" reports in the system that they sold you, and they are trying to piggy-bag on your reports and incorporate them in the next release as "canned" reports.|||If possible, you should consider replicating your data on a dedicated report server. This will avoid potential performance issues.|||Unfortunately the data changes constantly, and I suspect if they won't let me add reports, they won't let me replicate. It took me over 2 months to convince them we needed a seperate test server as making a modification to their system (using their own forms and an approved process) required a 4 hour import that completely paralized the system.
The database tables have grown from 2000 rows 9 months ago to over 21 million, so reporting out of the system will soon become too cpu intensive anyway.
I'd love to work with the vendor and introduce them to datawarehouseing, but they're product is so fragile and Stockamp & Associates employees are so unwilling to listen, that I given up on a friendly working relationship.
So the moral is to avoid software with a canned report viewer, regardless of its backend system.
Subscribe to:
Posts (Atom)