Hi All,
Using Crystal Report 8.5 & MS-SQL Server
Per requirement, I have created a report, which has 3 sub report. Main report and 3 subreports has stored procedure as datasource. First two subreports are Identical. To get different name I saved subrpts with two different name and Inserted into main report. Here is the layout I have it in the report.
---------------------------------------------------
RH(Report Header)
[subrpt_cnt_job_rh]
---------------------------------------------------
PH[Page Header]
---------------------------------------------------
GH[Group Header]
----------------------------------------------------
Detail
----------------------------------------------------
GF[Group Footer]
[subrpt_cnt_job_gf]
----------------------------------------------------
RF(Report Footer)
[ subrpt_list_summary ]
----------------------------------------------------
PF(Page Footer)
----------------------------------------------------
If I run this from crystal report tool, I have no problem.
But during runtime on production I am getting pop-up prompt asking user name/password for each subreport. So I entered user name password three times. Then it displaying the result. This report is being used from small web portal tool. I checked Virtual directory and it is fine.
Have any one experienced this problem?. I don't know what I am missing here. Guru, share your thoughts.
Thanks in advance.
Using Crystal Report 8.5 & MS-SQL Server
Per requirement, I have created a report, which has 3 sub report. Main report and 3 subreports has stored procedure as datasource. First two subreports are Identical. To get different name I saved subrpts with two different name and Inserted into main report. Here is the layout I have it in the report.
---------------------------------------------------
RH(Report Header)
[subrpt_cnt_job_rh]
---------------------------------------------------
PH[Page Header]
---------------------------------------------------
GH[Group Header]
----------------------------------------------------
Detail
----------------------------------------------------
GF[Group Footer]
[subrpt_cnt_job_gf]
----------------------------------------------------
RF(Report Footer)
[ subrpt_list_summary ]
----------------------------------------------------
PF(Page Footer)
----------------------------------------------------
If I run this from crystal report tool, I have no problem.
But during runtime on production I am getting pop-up prompt asking user name/password for each subreport. So I entered user name password three times. Then it displaying the result. This report is being used from small web portal tool. I checked Virtual directory and it is fine.
Have any one experienced this problem?. I don't know what I am missing here. Guru, share your thoughts.
Thanks in advance.