Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts

Friday, March 30, 2012

ReportViewer formatting

All,
I am having an issue with a fairly standard implementation of the
ReportViewer control in an Asp.net application.
I have several fairly strait forward reports, but am having problems with
one that contains several tightly aligned textboxes. I am using a grid
spacing of '0.0625in'.
When designed in Visual Studio, or when exported to PDF, the report renders
fine. However, when viewed in the ReportViewer, several of the text boxes
have been resized or moved.
I am wondering if there are some best-practices that I could utilize in
designing this report. Is there a grid spacing that renders better?
Any thoughts/suggestions would be appreciated!
Pierson2 differences that I have discovered:
1) ReportViewer does not consistently render textboxes that overlap(even
slightly) it compensates for this by realigning them. Exports do handle
overlaping textboxes.
2) If you use a bordered textbox as a 'checkbox', change the text size to
1pt. ReportViewer increases the textbox size to fit text, even if there is
no text supplied.
Hope this helps someone!
"Pierson C" wrote:
> All,
> I am having an issue with a fairly standard implementation of the
> ReportViewer control in an Asp.net application.
> I have several fairly strait forward reports, but am having problems with
> one that contains several tightly aligned textboxes. I am using a grid
> spacing of '0.0625in'.
> When designed in Visual Studio, or when exported to PDF, the report renders
> fine. However, when viewed in the ReportViewer, several of the text boxes
> have been resized or moved.
> I am wondering if there are some best-practices that I could utilize in
> designing this report. Is there a grid spacing that renders better?
> Any thoughts/suggestions would be appreciated!
> Pierson|||Make sure that none of the textboxes overlap. We don't support overlapping
items in some renderers and will move/resize items if needed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Pierson C" <PiersonC@.discussions.microsoft.com> wrote in message
news:ED575E95-145A-401A-BDBB-82659A24580F@.microsoft.com...
> All,
> I am having an issue with a fairly standard implementation of the
> ReportViewer control in an Asp.net application.
> I have several fairly strait forward reports, but am having problems with
> one that contains several tightly aligned textboxes. I am using a grid
> spacing of '0.0625in'.
> When designed in Visual Studio, or when exported to PDF, the report
> renders
> fine. However, when viewed in the ReportViewer, several of the text boxes
> have been resized or moved.
> I am wondering if there are some best-practices that I could utilize in
> designing this report. Is there a grid spacing that renders better?
> Any thoughts/suggestions would be appreciated!
> Pierson

Monday, March 26, 2012

ReportViewer 2.0 Control with Credentials Problem

I have developed a web app that uses forms authentication. I wrote it in
asp.net 2.0. My server is running windows 2003 server standard and IIS. I
have also installed on the same machine SQL Server 2005 with Reporting
Services.
From my webapplication, I have a button that the user can click and then I
have the Report Viewer control generate a report. However, I do not know how
to pass the proper credentials to the report server. I would like to pass
one username and password that has permissions to run that report. My code
is follows:
Private Sub saveRptAs(ByVal s_rptType As String)
Dim warnings As Microsoft.Reporting.WebForms.Warning()
Dim streamids As String()
Dim mimeType As String
Dim encoding As String
Dim extension As String
ReportViewer1.ServerReport.ReportServerUrl = New
Uri("http://myserver/reportserver")
ReportViewer1.ServerReport.ReportPath = "/reports/Individual Report"
Dim test As New NetworkCredential("localuser", "password", "domain")
ReportViewer1.ServerReport.ReportServerCredentials = test
Dim rprameter As ReportParameter = New ReportParameter("user_no",
Profile.DTGVariables.SelectedYMNo)
Me.ReportViewer1.ServerReport.SetParameters(New ReportParameter()
{rprameter})
Dim bytes As Byte() = ReportViewer1.ServerReport.Render(s_rptType,
Nothing, mimeType, encoding, extension, streamids, warnings)
Response.Buffer = True
Response.Clear()
Response.ContentType = mimeType
Response.AddHeader("content-disposition", "attachment;
filename=sample." + extension)
Response.BinaryWrite(bytes)
Response.Flush()
Response.End()
End Sub
When I click on the button I get the following message:
Unable to cast object of type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'.
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.InvalidCastException: Unable to cast object of
type 'System.Net.NetworkCredential' to type
'Microsoft.Reporting.WebForms.IReportServerCredentials'.
Can someone help me with the credentials issue? Do I need to change
Reporting Services to use Forms Authentication?
Your help and insight is greatly appreciated.
Thanks
Nate DoggYou have to create a class that inherits from IReportServerCredentials
interface.
read this post:
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=157916&SiteID=1
"Nate Dogg" wrote:
> I have developed a web app that uses forms authentication. I wrote it in
> asp.net 2.0. My server is running windows 2003 server standard and IIS. I
> have also installed on the same machine SQL Server 2005 with Reporting
> Services.
> From my webapplication, I have a button that the user can click and then I
> have the Report Viewer control generate a report. However, I do not know how
> to pass the proper credentials to the report server. I would like to pass
> one username and password that has permissions to run that report. My code
> is follows:
> Private Sub saveRptAs(ByVal s_rptType As String)
> Dim warnings As Microsoft.Reporting.WebForms.Warning()
> Dim streamids As String()
> Dim mimeType As String
> Dim encoding As String
> Dim extension As String
> ReportViewer1.ServerReport.ReportServerUrl = New
> Uri("http://myserver/reportserver")
> ReportViewer1.ServerReport.ReportPath = "/reports/Individual Report"
>
> Dim test As New NetworkCredential("localuser", "password", "domain")
> ReportViewer1.ServerReport.ReportServerCredentials = test
> Dim rprameter As ReportParameter = New ReportParameter("user_no",
> Profile.DTGVariables.SelectedYMNo)
> Me.ReportViewer1.ServerReport.SetParameters(New ReportParameter()
> {rprameter})
> Dim bytes As Byte() = ReportViewer1.ServerReport.Render(s_rptType,
> Nothing, mimeType, encoding, extension, streamids, warnings)
> Response.Buffer = True
> Response.Clear()
> Response.ContentType = mimeType
> Response.AddHeader("content-disposition", "attachment;
> filename=sample." + extension)
> Response.BinaryWrite(bytes)
> Response.Flush()
> Response.End()
> End Sub
> When I click on the button I get the following message:
> Unable to cast object of type 'System.Net.NetworkCredential' to type
> 'Microsoft.Reporting.WebForms.IReportServerCredentials'.
> 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.InvalidCastException: Unable to cast object of
> type 'System.Net.NetworkCredential' to type
> 'Microsoft.Reporting.WebForms.IReportServerCredentials'.
>
> Can someone help me with the credentials issue? Do I need to change
> Reporting Services to use Forms Authentication?
> Your help and insight is greatly appreciated.
> Thanks
> Nate Dogg
>

Tuesday, March 20, 2012

Reports over internet with Standard Edition Reporting Services

Hello,
I'm trying to view my reports over the internet.
I can browse to https://www.mysite.com/reports and it prompts me to log in
(integrated windows authentication) and I can view my list of reports.
When I click on a report I recieve a basic "The page cannot be displayed"
error.
I even tried just "basic" authentication within IIS but still get the same
error.
The server hosts both components (SQL Server & IIS) on a Windows 2003 SP1.
No special authentication, not a web farm, do I still need to get Enterprise
edition?
Help...
Thanks in advance,
GregCheck your IE address when you open your report, it must point to
http://yourserver/reports. It point to your internal RS, that's why you can
not open report from internet. It shows your list is because IIS is working.
still no clue?
check your config file. RSWebApplication.config under ReportManager
change
<ReportServerUrl>http://yourserver/reportserver</ReportServerUrl>
to
<ReportServerUrl>http://yourserver domain/reportserver</ReportServerUrl>
and then visit
http://your server domain/reports|||Thank you Wei Ming, this solved it for me.
"Wei Ming" wrote:
> Check your IE address when you open your report, it must point to
> http://yourserver/reports. It point to your internal RS, that's why you can
> not open report from internet. It shows your list is because IIS is working.
> still no clue?
> check your config file. RSWebApplication.config under ReportManager
> change
> <ReportServerUrl>http://yourserver/reportserver</ReportServerUrl>
> to
> <ReportServerUrl>http://yourserver domain/reportserver</ReportServerUrl>
> and then visit
> http://your server domain/reports
>|||Also, is there a way during setup that would resolve this?
"Wei Ming" wrote:
> Check your IE address when you open your report, it must point to
> http://yourserver/reports. It point to your internal RS, that's why you can
> not open report from internet. It shows your list is because IIS is working.
> still no clue?
> check your config file. RSWebApplication.config under ReportManager
> change
> <ReportServerUrl>http://yourserver/reportserver</ReportServerUrl>
> to
> <ReportServerUrl>http://yourserver domain/reportserver</ReportServerUrl>
> and then visit
> http://your server domain/reports
>|||I can not give u an answer for this, here is what I am thinking:
during setup, it will gather information from your computer, and save that
piece info into config file, if you can find that information ( for example,
hosts or registry ) and modify it. Your RS can be auto configured after
installation.
What's the peticular reason you like to config this during setup?|||For future deployments, instead of having a client go into a config file, I'd
rather have all of these settings done for them.
I'm curious, how did you find this answer?
"Wei Ming" wrote:
> I can not give u an answer for this, here is what I am thinking:
> during setup, it will gather information from your computer, and save that
> piece info into config file, if you can find that information ( for example,
> hosts or registry ) and modify it. Your RS can be auto configured after
> installation.
> What's the peticular reason you like to config this during setup?

Monday, March 12, 2012

Reports deployed to Standard edition RS and SQL Server

Hello,
We have successfully developed the reports on our testing machine with SQL Server 2000 Enterprise + Reporting Services 2000 Enterprise. Is there any problem if we deploy the reports to the production machine that runs SQL Server 2000 Standard and Reporting Services 2000 Standard?

Thanks in advance!

Here is some info on licensing:

http://msmvps.com/blogs/anguslogan/archive/2004/10/03/14788.aspx

The report RDL files should be the same in both environments so you should not have any problems.

cheers,

Andrew

Saturday, February 25, 2012

Reporting tools ?

Hi,
Is there a Reporting tools in SQL Server Standard Edition ? or it's actually
refering to the Analysis Services ?
tks & rdgs
Message posted via droptable.com
http://www.droptable.com/Uwe/Forums...-msde/200512/1
Reporting Services is a separate product which can be used if you have
a valid SQL Server 2k > licence, it not stuck to the analysis servces
but can keep benefit of this, due to the fact that you can use MDX
queries to access your database. The "tool set" to create Reporting
Services is brought to the dveloper by Visual Studio 2003 >.
HTH, Jens
|||Yes, SQL Server 2005 Reporting Services is included in Standard Edition
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"maxzsim via droptable.com" <u14644@.uwe> wrote in message
news:58e8077f9b87b@.uwe...
> Hi,
> Is there a Reporting tools in SQL Server Standard Edition ? or it's
> actually
> refering to the Analysis Services ?
> tks & rdgs
> --
> Message posted via droptable.com
> http://www.droptable.com/Uwe/Forums...-msde/200512/1