Our web server was running windows 2000 iis5 for several years including crystal 8.5. We just migrated to windows 2003 iis6 and all applications work great. EXCEPT exporting to PDF with (asp) using crystal reports Session("oRpt").Export.
I installed all SP & hotfixes for exporting and still no luck. Called tech support and they don't support version 8.5 so they would not help me.
Can somebody please help me! I have just 2 applications left that use crystal reports 8.5 and they are well heavily.
This is the error:
Microsoft VBScript runtime error '800a01fb'
An exception occurred: 'Export'Hi Dough,
Just wondering if you ever found a fix to the crystal report export. I am having the exact same issue with Windows Server 2003 / ASP 3.0 / IIS 6.0.
Thanks,
Troye Stonich|||I may have a solution for you to try.
I found it may be necessary to set the Display Progress Dialog to False. Most likely due to security restrictions on the IIS 6 Win2003 server.
Right before the Session Export line, Enter the following line,
Session("oRpt").DisplayProgressDialog = False
This helped me, doing a simple PDF Export (no viewer). Crystal does not present this dispaly in sample ASP they provide, (9.0 and below). For me it was pretty much a trial and error to resolve this issue.
If the above does not work, try the following 4 lines:
Dim strContentType
strContentType = "application/pdf"
Session("oRpt").DisplayProgressDialog = False
Response.ContentType = strContentType
Hope this helps.
Steve|||You guys are GREAT !
Thank you so mutch, i was getting crazy because of this problem :-)
Showing posts with label applications. Show all posts
Showing posts with label applications. Show all posts
Thursday, March 22, 2012
Tuesday, March 20, 2012
Crystal Reports 8 User session expired error
Hi,
As we are migrating from NT server to Win 2003 server. web applications are moved over from nt as well. I am facing problem with one the web apps which uses crystal reports 8. "User Session expired" error msg is popping out when we try to export the report into any supported format such html, excel, word etc.. The report comes up no issues..however unable to use export option.
I went through the business objects .pdf for user session expired err msg...but nothing helped. i am still stuck with this problem.
can anybody help me here pls.
FYI...It's a ASP/VB web appl using crystal reports 8.0 on Win 2003 machine.
thanks
DRM.Hello,
Further to my earlier msg, after commenting out the default error msg "User Session expired" i got this error msg
"The Report was not Exported. The selected report format may be disabled on the server" actually this is common msg coming up for all export formats...available in crystal 8.0 version.
Therefore, any ideas how to check/verify and Enable/Disable this on server?
ur help on this will be greatly appreciated.
thanks a ton in adv.
Cheers,
muki
As we are migrating from NT server to Win 2003 server. web applications are moved over from nt as well. I am facing problem with one the web apps which uses crystal reports 8. "User Session expired" error msg is popping out when we try to export the report into any supported format such html, excel, word etc.. The report comes up no issues..however unable to use export option.
I went through the business objects .pdf for user session expired err msg...but nothing helped. i am still stuck with this problem.
can anybody help me here pls.
FYI...It's a ASP/VB web appl using crystal reports 8.0 on Win 2003 machine.
thanks
DRM.Hello,
Further to my earlier msg, after commenting out the default error msg "User Session expired" i got this error msg
"The Report was not Exported. The selected report format may be disabled on the server" actually this is common msg coming up for all export formats...available in crystal 8.0 version.
Therefore, any ideas how to check/verify and Enable/Disable this on server?
ur help on this will be greatly appreciated.
thanks a ton in adv.
Cheers,
muki
Sunday, March 11, 2012
Crystal Report from ASP
Hi,
I am using Crystal Report 8.0 with VB6.0 for my application softwares. I am now developing some e-commerce applications using ASP 3.0. But I have no idea on how to connect crystalreports in ASP pages. Please guide me in this. Whether crystal report software must reside on the server?
Thanks in Advance.Yes, Crystal Reports (RAS) should be installed in the server. You can publish the report in the web in two ways. Search Crystal Decisions site, you can get sample code for both.
I am using Crystal Report 8.0 with VB6.0 for my application softwares. I am now developing some e-commerce applications using ASP 3.0. But I have no idea on how to connect crystalreports in ASP pages. Please guide me in this. Whether crystal report software must reside on the server?
Thanks in Advance.Yes, Crystal Reports (RAS) should be installed in the server. You can publish the report in the web in two ways. Search Crystal Decisions site, you can get sample code for both.
Labels:
application,
applications,
asp,
crystal,
database,
developing,
e-commerce,
microsoft,
mysql,
oracle,
report,
server,
softwares,
sql,
vb6
Crystal Report Factors
hi guys!
i just want to ask my problem about my exporting file under vb code applications...
when i click the export button it doesnt work... nothing happen...
i wonder if you can give an idea how to fix this problems...
ASAP!
thank you very much!
benjzMake sure you have the correct dlls installed on the machine you want to Export from. In Crystal Reports 8.5, there's a file called runtime.hlp that tells you what files are required and whee to put them.|||do i need to install those dll in every client that are using the application? i thought its automatically deploy by setup app...
is it ok if you can give me the list of this dll's?
thankz a lot!
benjz|||Depending on what app you're using to create your setup file, you may have to specify that you want Export capabilities included.
See my post here (http://www.dev-archive.com/forum/showthread.php?t=318504) for a list of the Export dlls required (for CR 8.5).
i just want to ask my problem about my exporting file under vb code applications...
when i click the export button it doesnt work... nothing happen...
i wonder if you can give an idea how to fix this problems...
ASAP!
thank you very much!
benjzMake sure you have the correct dlls installed on the machine you want to Export from. In Crystal Reports 8.5, there's a file called runtime.hlp that tells you what files are required and whee to put them.|||do i need to install those dll in every client that are using the application? i thought its automatically deploy by setup app...
is it ok if you can give me the list of this dll's?
thankz a lot!
benjz|||Depending on what app you're using to create your setup file, you may have to specify that you want Export capabilities included.
See my post here (http://www.dev-archive.com/forum/showthread.php?t=318504) for a list of the Export dlls required (for CR 8.5).
Thursday, March 8, 2012
Crystal Report Designer In Application
Hi,
I am using crystal reports from last 5 years for smalll applications.
Can anyone tell me that how to make the crystal report designer be the integrated part of your module so that user of our application can make report for himself by using the our database object , and need not to depend on us for making reports, design change etc. and hence able to customize report.
I am using crystal report version 5.0 which version i need.
Can i use it with VC++
Which ocx. i have to incorporate.
Thanks
Nitin MahajanAFAIK
You can make it with Crystal Reports versions X & XI using RDC or API
(no OCX... version 8.5 was the last version that used OCX)
Also, You have to consider (pay for) some special license
I am using crystal reports from last 5 years for smalll applications.
Can anyone tell me that how to make the crystal report designer be the integrated part of your module so that user of our application can make report for himself by using the our database object , and need not to depend on us for making reports, design change etc. and hence able to customize report.
I am using crystal report version 5.0 which version i need.
Can i use it with VC++
Which ocx. i have to incorporate.
Thanks
Nitin MahajanAFAIK
You can make it with Crystal Reports versions X & XI using RDC or API
(no OCX... version 8.5 was the last version that used OCX)
Also, You have to consider (pay for) some special license
Tuesday, February 14, 2012
Cross Domain report authentication
Hi all,
I have a reporting server(with reports) on "domain1". and the users who
login into web applications which is on a different domain say
"domain2" to access the reports.
I used to have a url access to the reporting server. but when the user
tries to generate a report it ask for authentication (the login dialog
window ). As the user is not on the same domain as the reports server I
created a user on the reports server machine and passed on the user
name and password, so that users can login with that id/password. It
worked fine but with the login dialog window popping up.
Now they want to get rid of the pop up login dialog window.
I looked at some books and tried to use a web service instead of a url
access to run reports. but it throws me some soap exception.
Exception below:
--
System.Web.Services.Protocols.SoapException: The requested
functionality is currently not supported -->
Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException:
The requested functionality is currently not supported at
Microsoft.ReportingServices.Library.Soap.ParameterValue.ThisArrayToNameValueCollection(ParameterValue[]
parameters) at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) -- End of inner exception stack trace -- at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds)
---
I have tried changing the settings on the IIS for the reportserver but
of no use.
I was thinking if I had to implement Custom Secuirty Extenstions.
Do I have to do that'
I am trying to figure out how easy would that be to do.
Can anyone guide me step by step procedure to get wat I am trying to
achieve. I just dont need the login dialog window to come up and need
to pre authenticate the user whenever he logs into the web application
some way.
Any code snippets/helpful links or insight on how to workaround this
problem will be greatly appreciated.
Thanks a lot in advance.
Klayan.Can anyone Help me here please...I need this very badly.
Thanks,
Kalyan.|||I am also trying to use the method LogonUser to authenticate the user
but it gives me an
Error: "The request failed with HTTP status 403: Forbidden." message. I
checked the permission on all the folders, they have read/write, and
also IIS authentication set to "enabled anonymous access".
I am not able to figure out how else to preauthenticate the reporting
server..
Please Help.
Thank you|||Kalyan wrote:
> Hi all,
> I have a reporting server(with reports) on "domain1". and the users who
> login into web applications which is on a different domain say
> "domain2" to access the reports.
> I used to have a url access to the reporting server. but when the user
> tries to generate a report it ask for authentication (the login dialog
> window ). As the user is not on the same domain as the reports server I
> created a user on the reports server machine and passed on the user
> name and password, so that users can login with that id/password. It
> worked fine but with the login dialog window popping up.
> Now they want to get rid of the pop up login dialog window.
> I looked at some books and tried to use a web service instead of a url
> access to run reports. but it throws me some soap exception.
> Exception below:
> --
> System.Web.Services.Protocols.SoapException: The requested
> functionality is currently not supported -->
> Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException:
> The requested functionality is currently not supported at
> Microsoft.ReportingServices.Library.Soap.ParameterValue.ThisArrayToNameValueCollection(ParameterValue[]
> parameters) at
> Microsoft.ReportingServices.WebServer.ReportingService.Render(String
> Report, String Format, String HistoryID, String DeviceInfo,
> ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
> String ShowHideToggle, Byte[]& Result, String& Encoding, String&
> MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds) -- End of inner exception stack trace -- at
> Microsoft.ReportingServices.WebServer.ReportingService.Render(String
> Report, String Format, String HistoryID, String DeviceInfo,
> ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
> String ShowHideToggle, Byte[]& Result, String& Encoding, String&
> MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds)
> ---
> I have tried changing the settings on the IIS for the reportserver but
> of no use.
> I was thinking if I had to implement Custom Secuirty Extenstions.
> Do I have to do that'
> I am trying to figure out how easy would that be to do.
> Can anyone guide me step by step procedure to get wat I am trying to
> achieve. I just dont need the login dialog window to come up and need
> to pre authenticate the user whenever he logs into the web application
> some way.
> Any code snippets/helpful links or insight on how to workaround this
> problem will be greatly appreciated.
> Thanks a lot in advance.
> Klayan.
>
You may implement custom authentication if you want to get rid of
windows one at all.
I tryed few ways:
1) using windows account as a type of transport to identify real person
mapped onto it. (then you need some kind of lookup mechanism to
impersonate windows user on server side)
2) using IP dinamically mapped to some kind of authority.
this may sound unsecure, but works excellent in certain environments
(for small intranets with unique IPs and proxy forbidden).
I used second approach with Domino server particularly,where notes user
IP being used to identify person on RS side.No bloody popups,-no nothing :)|||Hey Pisla,
Thanks a lot for the insight.
Can you tell me how to do the step 2 you have mentioned. I am really
clueless of wat you are talking.
Like your step 1, I tried to pass the windows credentials in the
LogonUser method ...hardcoded them ...but still it doesnt authenticate
the cookie on the rs server.
I very badly need to get this popup thing go.HELP.
Thanks a lot,
Kalyan.|||Kalyan wrote:
> Hey Pisla,
> Thanks a lot for the insight.
> Can you tell me how to do the step 2 you have mentioned. I am really
> clueless of wat you are talking.
> Like your step 1, I tried to pass the windows credentials in the
> LogonUser method ...hardcoded them ...but still it doesnt authenticate
> the cookie on the rs server.
> I very badly need to get this popup thing go.HELP.
> Thanks a lot,
> Kalyan.
>
Kalyan, we're about to sell this solution so i'm afraid i may not just
give it to you for free.
You may play thou with custom authentication example to implement the
same stuff.|||Hi Pisla,
Can you tell me when you will be ready with the solution.
May be I can buy it from you guys. I have given up on the problem.
Its driving me crazy..
Please let me know if I can buy the solution and also the price.
Thanks a lot for the Help.
Kalyan.|||Kalyan,
I presume you are using SQL 2000 RS. By default the SQLRS supports only
windows authentication so you woudn't be able to display the reports outside
your domain using ReportViewer control which internally uses URL invocation
mechanism.
To get rid of this, you need to use Reporting Services Web Service which is
provided as part of SQL2000 RS installation. Just create a proxy and request
the type of format you want by creating a Network Crenditials class of your
choice of user. The render method call will return you the byte array, which
you can write to response object or whatever you need to do with that. The
flip side of it is you need to code for all the pagination, formatting using
webservice calls. So more programming.
Thanks,
Live_Love_Laugh
"Kalyan" wrote:
> Hi Pisla,
> Can you tell me when you will be ready with the solution.
> May be I can buy it from you guys. I have given up on the problem.
> Its driving me crazy..
> Please let me know if I can buy the solution and also the price.
> Thanks a lot for the Help.
> Kalyan.
>
I have a reporting server(with reports) on "domain1". and the users who
login into web applications which is on a different domain say
"domain2" to access the reports.
I used to have a url access to the reporting server. but when the user
tries to generate a report it ask for authentication (the login dialog
window ). As the user is not on the same domain as the reports server I
created a user on the reports server machine and passed on the user
name and password, so that users can login with that id/password. It
worked fine but with the login dialog window popping up.
Now they want to get rid of the pop up login dialog window.
I looked at some books and tried to use a web service instead of a url
access to run reports. but it throws me some soap exception.
Exception below:
--
System.Web.Services.Protocols.SoapException: The requested
functionality is currently not supported -->
Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException:
The requested functionality is currently not supported at
Microsoft.ReportingServices.Library.Soap.ParameterValue.ThisArrayToNameValueCollection(ParameterValue[]
parameters) at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds) -- End of inner exception stack trace -- at
Microsoft.ReportingServices.WebServer.ReportingService.Render(String
Report, String Format, String HistoryID, String DeviceInfo,
ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
String ShowHideToggle, Byte[]& Result, String& Encoding, String&
MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
String[]& StreamIds)
---
I have tried changing the settings on the IIS for the reportserver but
of no use.
I was thinking if I had to implement Custom Secuirty Extenstions.
Do I have to do that'
I am trying to figure out how easy would that be to do.
Can anyone guide me step by step procedure to get wat I am trying to
achieve. I just dont need the login dialog window to come up and need
to pre authenticate the user whenever he logs into the web application
some way.
Any code snippets/helpful links or insight on how to workaround this
problem will be greatly appreciated.
Thanks a lot in advance.
Klayan.Can anyone Help me here please...I need this very badly.
Thanks,
Kalyan.|||I am also trying to use the method LogonUser to authenticate the user
but it gives me an
Error: "The request failed with HTTP status 403: Forbidden." message. I
checked the permission on all the folders, they have read/write, and
also IIS authentication set to "enabled anonymous access".
I am not able to figure out how else to preauthenticate the reporting
server..
Please Help.
Thank you|||Kalyan wrote:
> Hi all,
> I have a reporting server(with reports) on "domain1". and the users who
> login into web applications which is on a different domain say
> "domain2" to access the reports.
> I used to have a url access to the reporting server. but when the user
> tries to generate a report it ask for authentication (the login dialog
> window ). As the user is not on the same domain as the reports server I
> created a user on the reports server machine and passed on the user
> name and password, so that users can login with that id/password. It
> worked fine but with the login dialog window popping up.
> Now they want to get rid of the pop up login dialog window.
> I looked at some books and tried to use a web service instead of a url
> access to run reports. but it throws me some soap exception.
> Exception below:
> --
> System.Web.Services.Protocols.SoapException: The requested
> functionality is currently not supported -->
> Microsoft.ReportingServices.Diagnostics.Utilities.NotYetSupportedException:
> The requested functionality is currently not supported at
> Microsoft.ReportingServices.Library.Soap.ParameterValue.ThisArrayToNameValueCollection(ParameterValue[]
> parameters) at
> Microsoft.ReportingServices.WebServer.ReportingService.Render(String
> Report, String Format, String HistoryID, String DeviceInfo,
> ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
> String ShowHideToggle, Byte[]& Result, String& Encoding, String&
> MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds) -- End of inner exception stack trace -- at
> Microsoft.ReportingServices.WebServer.ReportingService.Render(String
> Report, String Format, String HistoryID, String DeviceInfo,
> ParameterValue[] Parameters, DataSourceCredentials[] Credentials,
> String ShowHideToggle, Byte[]& Result, String& Encoding, String&
> MimeType, ParameterValue[]& ParametersUsed, Warning[]& Warnings,
> String[]& StreamIds)
> ---
> I have tried changing the settings on the IIS for the reportserver but
> of no use.
> I was thinking if I had to implement Custom Secuirty Extenstions.
> Do I have to do that'
> I am trying to figure out how easy would that be to do.
> Can anyone guide me step by step procedure to get wat I am trying to
> achieve. I just dont need the login dialog window to come up and need
> to pre authenticate the user whenever he logs into the web application
> some way.
> Any code snippets/helpful links or insight on how to workaround this
> problem will be greatly appreciated.
> Thanks a lot in advance.
> Klayan.
>
You may implement custom authentication if you want to get rid of
windows one at all.
I tryed few ways:
1) using windows account as a type of transport to identify real person
mapped onto it. (then you need some kind of lookup mechanism to
impersonate windows user on server side)
2) using IP dinamically mapped to some kind of authority.
this may sound unsecure, but works excellent in certain environments
(for small intranets with unique IPs and proxy forbidden).
I used second approach with Domino server particularly,where notes user
IP being used to identify person on RS side.No bloody popups,-no nothing :)|||Hey Pisla,
Thanks a lot for the insight.
Can you tell me how to do the step 2 you have mentioned. I am really
clueless of wat you are talking.
Like your step 1, I tried to pass the windows credentials in the
LogonUser method ...hardcoded them ...but still it doesnt authenticate
the cookie on the rs server.
I very badly need to get this popup thing go.HELP.
Thanks a lot,
Kalyan.|||Kalyan wrote:
> Hey Pisla,
> Thanks a lot for the insight.
> Can you tell me how to do the step 2 you have mentioned. I am really
> clueless of wat you are talking.
> Like your step 1, I tried to pass the windows credentials in the
> LogonUser method ...hardcoded them ...but still it doesnt authenticate
> the cookie on the rs server.
> I very badly need to get this popup thing go.HELP.
> Thanks a lot,
> Kalyan.
>
Kalyan, we're about to sell this solution so i'm afraid i may not just
give it to you for free.
You may play thou with custom authentication example to implement the
same stuff.|||Hi Pisla,
Can you tell me when you will be ready with the solution.
May be I can buy it from you guys. I have given up on the problem.
Its driving me crazy..
Please let me know if I can buy the solution and also the price.
Thanks a lot for the Help.
Kalyan.|||Kalyan,
I presume you are using SQL 2000 RS. By default the SQLRS supports only
windows authentication so you woudn't be able to display the reports outside
your domain using ReportViewer control which internally uses URL invocation
mechanism.
To get rid of this, you need to use Reporting Services Web Service which is
provided as part of SQL2000 RS installation. Just create a proxy and request
the type of format you want by creating a Network Crenditials class of your
choice of user. The render method call will return you the byte array, which
you can write to response object or whatever you need to do with that. The
flip side of it is you need to code for all the pagination, formatting using
webservice calls. So more programming.
Thanks,
Live_Love_Laugh
"Kalyan" wrote:
> Hi Pisla,
> Can you tell me when you will be ready with the solution.
> May be I can buy it from you guys. I have given up on the problem.
> Its driving me crazy..
> Please let me know if I can buy the solution and also the price.
> Thanks a lot for the Help.
> Kalyan.
>
Subscribe to:
Posts (Atom)