Showing posts with label call. Show all posts
Showing posts with label call. Show all posts

Tuesday, March 27, 2012

Access Denied

I have a web application in one server and reporting service in another
server. This web application is to list out report items. When I call web
application in any client machine, error is always shown - 'The request
failed with HTTP status 401: Access Denied'. But if I install the reporting
service and web application in same server, there is no problem. Can anyone
help me ?Open the RSWebApplication.config file with a text editor. The first few
lines of the file will be similar to the following:
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
</UI>
Replace the text between <ReportServerUrl> and </ReportServerUrl> with the
complete address that should be used to access the Reports website like,
<Configuration>
<UI>
<ReportServerUrl>http://www.xyzname.com/ReportServer</ReportServerUrl>
</UI>
or with IP address
<Configuration>
<UI>
<ReportServerUrl>http://192.162.x.y/ReportServer</ReportServerUrl>
</UI>
Hope this helps,
Barbaros Saglamtimur
MCDBA, MCAD
"May Liu" <MayLiu@.discussions.microsoft.com> wrote in message
news:CF1F5CDB-596B-4015-8FE4-8D9B7D85D803@.microsoft.com...
>I have a web application in one server and reporting service in another
> server. This web application is to list out report items. When I call
> web
> application in any client machine, error is always shown - 'The request
> failed with HTTP status 401: Access Denied'. But if I install the
> reporting
> service and web application in same server, there is no problem. Can
> anyone
> help me ?

Sunday, March 11, 2012

Accelerating first call of Reports

Hi,
is there a possibility to accelerate the first call of a report?
It could take up to 1 minute on my Server. After I called a report the first
time, its going faster (~5 seconds).
Thanks and regards,
StefanThis is due to IIS, not Report Server specifically.
Go to IIS Manager, under Applocation Pools node, right click
"DefaultAppPool" in which the Reporting Server work process is running,
select properties. On "Performace" tag, you will see, by default, the app
pool will shut down if > being idle for 20 min. You can extend this time to
8x60min 480min, so that the app pool will not shut down for a regular
working day. However, the first report reader of the day, will hit the
delay. You may schedule a dummy report at beginning of a work day for this.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Stefan" <stefan@.nospam.nospam> wrote in message
news:eIt4iTroHHA.1476@.TK2MSFTNGP03.phx.gbl...
> Hi,
> is there a possibility to accelerate the first call of a report?
> It could take up to 1 minute on my Server. After I called a report the
> first time, its going faster (~5 seconds).
> Thanks and regards,
> Stefan
>|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi Bruce, hi Wei Lu,
thanks for your support.
Can you please give me an example, how to call a dummy report from a
batch-File.
Thanks and regards,
Stefan
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> schrieb im Newsbeitrag
news:eZ%23UFCsoHHA.4516@.TK2MSFTNGP05.phx.gbl...
> This is due to IIS, not Report Server specifically.
> Go to IIS Manager, under Applocation Pools node, right click
> "DefaultAppPool" in which the Reporting Server work process is running,
> select properties. On "Performace" tag, you will see, by default, the app
> pool will shut down if > being idle for 20 min. You can extend this time
> to 8x60min 480min, so that the app pool will not shut down for a regular
> working day. However, the first report reader of the day, will hit the
> delay. You may schedule a dummy report at beginning of a work day for
> this.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Stefan" <stefan@.nospam.nospam> wrote in message
> news:eIt4iTroHHA.1476@.TK2MSFTNGP03.phx.gbl...
>> Hi,
>> is there a possibility to accelerate the first call of a report?
>> It could take up to 1 minute on my Server. After I called a report the
>> first time, its going faster (~5 seconds).
>> Thanks and regards,
>> Stefan
>|||Hello Stefan,
I did not have a sample yet. I would like to suggest you create a
application to use the web services to call the reports.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
I run the following script in planned tasks and now everything runs fine.
Thanks,
Stefan
Option Explicit
Dim objIEA
Set objIEA = CreateObject("InternetExplorer.Application")
objIEA.Navigate
"http://localhost/reportserver?%2fReports2fMyDummyReport&rs:Command=Render"
objIEA.visible = true
While objIEA.Busy
Wend
objIEA.Quit
Set objIEA = Nothing
"Stefan" <stefan@.nospam.nospam> schrieb im Newsbeitrag
news:O%23d1KDopHHA.4632@.TK2MSFTNGP04.phx.gbl...
> Hi Bruce, hi Wei Lu,
> thanks for your support.
> Can you please give me an example, how to call a dummy report from a
> batch-File.
> Thanks and regards,
> Stefan
>
>

Thursday, February 9, 2012

About Crystal Report 9

hi everybody,
I am using VB6 and CrystalReport9. so how can i call a report
from my VB form? please tell me as soon as possible with example.
bye
bappyCheck developer documentation of Crystal. They have given pretty good examples. Look for CrystalDevHelp file.

Thanks|||hi,

Thanks for your replay. but i want Crystal Report Control OCX that have in Crystal 8.5. This control is easy to use for me. so please tell me have any option to use that OCX? or i have to use crystal report viewer control please let me clear about that.

bye

thanks again

bappy|||What if you use Crystal Report Viewer Control? I am not sure whether it's a OCX or OLE ? but what if you use this control (viewer) ? Does it involve lots of code change because version 10 uses Crystal Viewer control Extensively. So you should be prepared for that migration also in future.

Thanks|||I have come across this just now :

Retired Developer APIs

Crystal Reports ActiveX Control (crystl32.ocx)
The Crystal Reports ActiveX control is no longer supported and no longer available as of Crystal Reports version 9.

Thanks|||hi dilemma,
thanks for your replay. now i am trying to use viewer control.

bye

bappy|||Best of Luck , let me know if you find any problem.

Thanks|||Hi dilemma,

Thanks for your replay. Actually now I am using Oracle9i and Crystal 9. but here is a problem. I can build a report by using Crystal 9 in VB Project but when I am trying to show report form then an error generate the message is Login failed. I know that I have to pass user name, password, TNS name at runtime but I dont know about syntax. So can you tell me about that syntax or send me an example?

Please help me as soon as possible

Thanks for supporting me.

Bappy|||You need to code something like this.

How to connect to an OLEDB data source
This example demonstrates how to connect to an OLEDB (ADO) data source, change the data source, and change the database by using the ConnectionProperty Object, as well as how to change the table name by using the Location property of the DatabaseTable Object,. CrystalReport1 is created using an ODBC data source connected to the pubs database on Microsoft SQL Server. The report is based off the authors table.

' Create a new instance of the report.
Dim Report As New CrystalReport1

Private Sub Form_Load()
' Declare a ConnectionProperty object.
Dim CPProperty As CRAXDRT.ConnectionProperty
' Declare a DatabaseTable object.
Dim DBTable As CRAXDRT.DatabaseTable

' Get the first table in the report.
Set DBTable = Report.Database.Tables(1)

' Get the "Data Source" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("Data Source")

' Set the new data source (server name).
' Note: You do not need to set this property if
' you are using the same data source.
CPProperty.Value = "Server2"

' Get the "User ID" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("User ID")

' Set the user name.
' Note: You do not need to set this property if
' you are using the same user name.
CPProperty.Value = "UserName"

' Get the "Password" property from the
' ConnectionProperties collection.
Set CPProperty = DBTable.ConnectionProperties("Password")

' Set the password.
' Note: You must always set the password if one is
' required.
CPProperty.Value = "Password"

' Get the "Initial Catalog" (database name) property from the
' ConnectionProperties collection.
' Note: You do not need to set this property if
' you are using the same database.
Set CPProperty = DBTable.ConnectionProperties("Initial Catalog")

' Set the new database name.
CPProperty.Value = "master"

' Set the new table name.
DBTable.Location = "authors2"

Screen.MousePointer = vbHourglass
' Set the report source of the viewer and view the report.
CRViewer91.ReportSource = Report
CRViewer91.ViewReport
Screen.MousePointer = vbDefault
End Sub

Thanks