it working when add subreport on main report if add parameters sub report , link main sub report, sap crystal report stuck on loading "please wait while document processing".
these parameters on main report same parameters use @ subreport, take note parameters on subreport not in use in stored procedure query yet i'm trying pass parameters first, try readding subreport scratch,
@sorttype varchar(50), @startdate datetime, @enddate datetime, @deptgroup varchar(50), @datetype varchar(50) these steps did,
- i add same exact parameters main report subreport stored procedure
- verified database show parameters sub report
- adding subreport main report.
- changed subreport links
tried testing 1 parameter
use [foo] go /****** object: storedprocedure [dbo].[usp_reportshowmedia] script date: 06/07/2016 08:28:45 ******/ set ansi_nulls on go set quoted_identifier on go alter procedure[dbo].[usp_reportshowmedia] ( @sorttype varchar(50) ) begin select * users end
