ASP.NET

ASP.NET RSS

Regarding the CrystalReport with asp.net

Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!

Thread Solved

•

Join Date: Sep 2007

Posts: 10

Reputation: vimalfor5 is an unknown quantity at this point

Solved Threads: 1

vimalfor5

Offline

Newbie Poster

Regarding the CrystalReport with asp.net

Jan 10th, 2009

Hi all,

i want to create one crystalreport from following storeprocedure

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
CREATE PROCEDURE dbo.usp_proc1
(
 @ID as INT
)
 
as 
 
DECLARE @Var1 as VARCHAR(1000);
SET @Var1 = ' select ID,Name,Email from Demo where ID='+Convert(VARCHAR,@ID)
 
print @Var1;
exec(@Var1);
CREATE PROCEDURE dbo.usp_proc1
(
 @ID as int
)

as 

declare @Var1 as varchar(1000);
set @Var1 = ' select ID,Name,Email from Demo where ID='+Convert(varchar,@ID)

print @Var1;
exec(@Var1);

This is not the actual code but its a demo of original, i'm using this type of code because i want to join two or more databases with supplied database name like

@dbName+"Connection"

where @dbName is the supplied argument

the problem is when i choose this procedure as the database field for the crystal report the select fields (table columns of the query ) are not displaying

i also tried

 Help with Code Tags 
 SQL Syntax (Toggle Plain Text) 
CREATE PROCEDURE dbo.usp_proc1
(
 @ID as INT
)
 
as 
 
DECLARE @Var1 as VARCHAR(1000);
SET @Var1 = ' select ID,Name,Email from Demo where ID='+Convert(VARCHAR,@ID)
 
print @Var1;
exec(@Var1);
 
/* select '' as ID,'' as Name,'' as Email */
CREATE PROCEDURE dbo.usp_proc1
(
 @ID as int
)

as 

declare @Var1 as varchar(1000);
set @Var1 = ' select ID,Name,Email from Demo where ID='+Convert(varchar,@ID)

print @Var1;
exec(@Var1);

/* select '' as ID,'' as Name,'' as Email */

still it is not working

i dnt want to create a separate dataset or i dnt want to change the logic of the entire.. !!!
any other suggestions are always welcome
Thanks