I have a Store Procedure that produce 5 static column with 3 dynamic column. The 3 dynamic are actually 3 variable(@col1, @col2, @col3) that is being supply by an .aspx page. The .aspx has 3 dropdownlist, each one of these ddl has a selected value of APLU,OOCL,EVGL.
So the user can make APLU or OOCL or EVGL the first variable(column), then the remaining two will be the second or third base on their selection. I have a hard type dataset that gets fill by a store procedure which supply crystal report with the result.
Is there a way for crystal report to know which was first, second, and third variable and create a page header column for each on of these value(APLU, OOCL, EVGL) in the order they were selected?
aspn00bie
Member
111 Points
75 Posts
Dynamic Columns
Mar 24, 2012 09:45 PM|LINK
Hi Everyone,
I have a Store Procedure that produce 5 static column with 3 dynamic column. The 3 dynamic are actually 3 variable(@col1, @col2, @col3) that is being supply by an .aspx page. The .aspx has 3 dropdownlist, each one of these ddl has a selected value of APLU,OOCL,EVGL. So the user can make APLU or OOCL or EVGL the first variable(column), then the remaining two will be the second or third base on their selection. I have a hard type dataset that gets fill by a store procedure which supply crystal report with the result. Is there a way for crystal report to know which was first, second, and third variable and create a page header column for each on of these value(APLU, OOCL, EVGL) in the order they were selected?