That was just an example. I just wanted to find out whether i can call stored procedure from SELECT statement or not.

Thanks

I faced a similar problem but when I deployed that report, it worked without throwing

any exceptions or errors.

http://support.microsoft.com/kb/909678

Because after changing Job_Number parameter to multivalue, you will have multiple values for Job_Number

that text box can not display.

try using SUM function with dataset name.

Jack

If I set available values for EDATE parameter then I am not getting Calender functionality

but instead of that I m getting drop down list.

Any suggestions?

Thanks Jack for your information.

I provided available values for EDATE parameter and it worked.

Thanks

Thank you for the information.

SELECT parameter setting:

Available Values:

YES

NO

Default Values:

Null

EDATE parameter setting

Default Values:

=SWITCH(Parameters!SELECT.Value="Yes",DATEADD("d",-1,now),

Parameters!SELECT.Value="No",

now)

you can use MONTH and YEAR function.

select @Exprdate=(SELECT distinct T0.ExpDate FROM OIBT T0 Where T0.ItemCode = @ItemNo and T0.BatchNum=@Batchno)

Instead of passing values to variable, try storing output of above select statement in a temporary...

select @Batchno=(SELECT distinct T1.[BatchNum] FROM IBT1 T1 WHERE T1.BaseNum=@delivno or T1.BaseNum=@docno)

select @Exprdate=(SELECT distinct T0.ExpDate FROM OIBT T0 Where T0.ItemCode...

I looked at execution plan and everything looks good but Nested Loop (Inner Join) costs 90%.

I want the output in following format:

---------------------------------------------------

Classification | Jan AVG | Feb AVG...

No, I dont want to use cross join because by using that i guess it will give me wrong average.

you can give permission to execute function to three user.

Use T-SQL for creating TCP endpoints and granting CONNECT permission.

After you have created endpoints and granted permission then use Mirroring GUI.