rayxu
March 14th, 2001, 12:16 AM
I used "select a.f1, b.f2, c.f3, from test a, test b, test 3" in stored procedure to list f1, f2, f3 fields in crystal report. But I got problem. Every above field has (forced to have) the same number of records (there is a duplication for some of the fields). What I want to do is to show some fields from table A in Section A and some fields from table B in Section B in crystal report. They are separate data and have different number of records. The point is I have to use stored procedure. Is there any method besides the Select statement I used above that I can use to get what I want to get (get the fields listed in crystal report)? Please help me out. thanks!