Skip to Content
0
Former Member
Jan 22, 2009 at 08:53 PM

JOIN in Dev report not in deployed Web App

12 Views

My report is incomplete on the web app, but it is fine on the dev box.. web app is on: .Net version 2.0

Windows 2003 Server web edition, IIS v6

Web app was created on VS 2005

In CR 2008, the "Show SQL Query" displays " NOCTISQL-01

"Atlas_Staging"."dbo"."CSsp_get_standard_score_rpt_v2";1 5421, N'2082', 1, N'20080311A', N'Post-Test', N'Student', N'12th Grade', {ts '2008-01-01 14:54:25'}, 39, 0.9

EXTERNAL JOIN CSsp_get_standard_score_rpt_v2;1.name={?NOCTISQL-01: CSsp_get_standard_score_rpt_P;1.name}

NOCTISQL-01

"Atlas_Staging"."dbo"."CSsp_get_standard_score_rpt_P";1 5421, N'2082', 1, N'20080311A', N'Post-Test', N'Student', N'12th Grade', {ts '2008-01-01 14:54:25'}, 39, 0.9

EXTERNAL JOIN CSsp_get_standard_score_rpt_P;1.name={?NOCTISQL-01: CSsp_get_standard_score_rpt_v2;1.name}"

On the Dev boa with CR 2008, the report runs fine.

Once the report is deployed on the Web App, the section that uses the JOINed data is incomplete. here is the code from the web app:

ds = db.ExecuteDataSet(dbCommand);

ds.Tables[0].TableName = "CSsp_get_standard_score_rpt_P;1";

ds.Tables[1].TableName = "CSsp_get_standard_score_rpt_v2;1";

boReportDocument.SetDataSource(ds)

It looks like I need to do something in the web code to insure the same kind of JOIN???