TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
bishoe nb
NA
623
80.5k
How use Stored Procedures Returning Multiple Result in crs
Aug 20 2018 12:51 AM
i use sp Returning Multiple Result
but how can use this sp in crs
data set Get Fitst Query From SP but another query don't show
this proc but not full
@IDUser
int
,
@ID_Member
int
as
begin
SELECT ID_Member, Member_Name, Birth_Date, MaleORFamle, Religion, [Address], Phone_Home, Mobile, Email, Identity_Number, Date_OF_issue, Exp_Date, Del_Flag, Profile_pic, Image_Regisrt, IDUser,
DateUserAddMember
FROM Member_Info
where ID_Member = @ID_Member and IDUser = @IDUser and Del_Flag =0
end
------Untiy_Party
SELECT Untiy_Party.IDUnity_party, Untiy_Party.Memberof_partisanunit, Member_Info.ID_Member, Member_Info.Del_Flag, Member_Info.IDUser
FROM Untiy_Party INNER JOIN
Member_Info ON Untiy_Party.IDUnity_party = Member_Info.IDUnity_party
WHERE (Member_Info.ID_Member = @ID_Member) AND (Member_Info.IDUser = @IDUser and Member_Info.Del_Flag = 0)
------Citys
begin
SELECT Citys.IDCity, Citys.City_Name, Member_Info.ID_Member, Member_Info.IDCity AS Expr1, Member_Info.IDUser, Member_Info.Del_Flag
FROM Citys INNER JOIN
Member_Info ON Citys.IDCity = Member_Info.IDCity
where Member_Info.ID_Member = @ID_Member and Member_Info.IDUser = @IDUser and Member_Info.Del_Flag = 0
end
procedure contains 260 line = all queries
how can use sp in crystal report
Reply
Answers (
5
)
Could not find file 'openFileDialog1
Adding an Image to Web Site