Last post Aug 28, 2010 01:01 AM by jula
Aug 26, 2010 06:54 PM|jula|LINK
in a crystal report , i used stored procedure name to display the fields.my problem is, in the procedure i selected the fields from two temperary tables.but in vs 2005 field explorer showing only the fields from the first temperory table.y the second temperry
table fields are not displaying?
i need two temporary table values .In sql tempo table query like as follows
Select * #TmpSummrep1.
Select * #TmpSummrep2
all fields from #TmpSummrep1 available in field explorer.
my procedure is running without any errors.
Aug 26, 2010 09:00 PM|sansan|LINK
When you pull up the report from two tables, you can see all columns otherwise, you have to create a sub report with a parameter to get the second variable.
I recommend using Table Variables instead of temp tables.
alter procedure Sto_Retrieve_Dataasbegindeclare @table1 as table(ID integer, name varchar(20));declare @table2 as table(ID integer, name1 varchar(20));insert into @table1 values(1,'test1');insert into @table1 values(2,'test1');insert into @table2 values(2,'test2');insert into @table2 values(2,'test2');select * from @table1;select * from @table2;end
Aug 28, 2010 01:01 AM|jula|LINK
thanks for ur advice.
i sql procedure i alled two table values like as follows
Select * from #Tmpummrep
Select * from #TmpTPDet
in crystal report i did a subreport and set the value of @m =0 and for main report i set the value @m=1
how to set these values through the code?my code is as folows.
for main report i need to pass val10.Value =1 for sub report it should be 0.
how it is possible?
@m is val10.
Dim val10 As New ParameterDiscreteValue()
val10.Value = 0