Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Main Report with 3 subreport - runtime problem

Status
Not open for further replies.

rkgrp

Programmer
Oct 29, 2003
15
US
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.
 
Have any one experienced this problem?.
Crystal Guru's shed some light on it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top