Report for all branches
-
Hi to all I want to know how to create the report for all Branches . I already created for the particualr branch when selected in dropdown box; but if i have ALL option in the DropDown Box then it should show me all the branch report for that i write the sp which takes branch_id, fromdate and todate parameter. and it shows me the rport but how to handle this ALL. Thanks.
-
Hi to all I want to know how to create the report for all Branches . I already created for the particualr branch when selected in dropdown box; but if i have ALL option in the DropDown Box then it should show me all the branch report for that i write the sp which takes branch_id, fromdate and todate parameter. and it shows me the rport but how to handle this ALL. Thanks.
Your Stored Procedure should look like the following: CREATE PROCEDURE sp_Branch_Report @branch_id nvarchar(20) = NULL, @fromdate datetime = NULL, @todate datetime = NULL when you call the above stored procedure: ALL->sp_Branch_Report BranchId->sp_Branch_Report 'BRANCH1' Date->sp_Branch_Report null,'01/05/2007','30/05/2007' another example->sp_Branch_Report 'BRANCH1','01/05/2007','30/05/2007' hope this could resolve your problem. ensure the date format before you pass it. Karthik