Crystal Report Problem
-
Hello Everyone, I want to display columns in crystal report dynamically. Suppose I have col1,col2 and col3 in crystal report I want to show col1,col2 and col3 sometimes and col1 and col2 othertimes depending on some criteria. How can I accomplish this task? Please give me suggestion.
Mehedi Hasan
-
Hello Everyone, I want to display columns in crystal report dynamically. Suppose I have col1,col2 and col3 in crystal report I want to show col1,col2 and col3 sometimes and col1 and col2 othertimes depending on some criteria. How can I accomplish this task? Please give me suggestion.
Mehedi Hasan
You have to create Formula for the Fields.....The formula will be based on your criteria on which you want to display results or not.... Suppose you want nothing to show in Column1 if the Field1(to be shown in Column1) value is 0 then make a Formula.In Formula Editor under the "Suppress" Tab write the following Code..
If myTable.Field1='0' then truenow if your query returns 0 in Field1 Column1 will be blank... But the thing to remember,though I am not very sure,is you probably cannot change the design of you report,I mean to say you cannot suppress Column1 with its Caption(if any) and other things....there will be a blank space...Tirtha Miles to go before I sleep