Balnk Rows if condition fails

[coolbabe2007]

Hi,

I am developing a new report. My report has a field, which is a calculated field. The filed name is TotalDays and this is calculated based on other fileds. I have done he caculation of this filed in Onrow() of DataRow by decalaring a filed as Total Days. I am fetching in the Fetch(). However, I have a condn in Fetch() method such hat the Total Days should be more than 670. Now my returns blank rows if this condn fails. Please let me know, what should I do.

Thanks in Advance.

 

[ASG0856]

I guess then, that you have 'filled rows' where the value >= 670 and blank where it isn't.
I would think that you have to exit the fetch, and bring the next row where your conditions fails. This should stop it writing a blank row
or
in the frame Sub OnRow method, if the condition fails, set size.height to 0 (zero)

 

[coolbabe2007]

Yes you are correct. Actually, I have already included an line exit when the condition fails but still its the same. I have pasted the fetch method below. Let me know, if I have added some more lines of code. Also, as you said, if I set the frame width to zero if the condition, then I think the othe rows may get affected. Because I have to omit only the particular row which is disaplayed as balnk if the condition fails and rest should be dispalyed.

Function Fetch( ) As AcDataRow
Set Fetch = Super::Fetch( )
' Insert your code here
Dim row as DataRow2

If Contractorswithin60days:aram_servicedays = True Then
Do
Set row = Super::Fetch( )
if row is nothing then
Exit Sub
End if
Loop Until row.TotalDays > 670
Else
if row is nothing then
Exit Sub
End if
End If

Set fetch = row

End Function


where param_servicedays is a user parameter, datatype being boolean. Only if it is true, I have to check whether the days is more than 670 and display rows which has more than 670. else I have dispaly all the rows irrespective of number of days.

 

[ASG0856]

Loop Until row.TotalDays > 670
Isn't this stopping the loop when at > 670, so that anything less than is the only rows 'displayed'?

Also, your not in a Sub Method, so you probably can't exit sub. You would have to be in Sub OnRow. Perhaps it should be Exit Fetch

 

[coolbabe2007]

Hi,

Thanks for your help. I have fixed this one.