Method:Classic General Q&A

Re: Need Report Designer VB FOR...NEXT loop

robert.cowart — Wed, 08 Apr 2015 19:42:16 GMT

Here is the FOR...LOOP construct I am using successfully:

.....

FOR Week as integer = 1 to WeekCount '' what if its one week and WeekCount = 0?? Does the loop fire once at least?

newrate = cSng(WeekCounter.text) + 1 ' or to create a loop that calcs it once correctly, including W,1,B SOL freq
WeekCounter.text = newrate.tostring
ForDate = Microsoft.VisualBasic.DateAdd("d", ((Week-1) * 7) , ForStartDate )
IF FirstOfYear <= ForDate and ForDate <= StartDateParm then
if UpperOther1 <> "W" then ' will this with the W and w?
if ( UpperOther1 = "B" AND ( Microsoft.VisualBasic.DATEDIFF("d", ForStartDate, ForDate) MOD 14 = 0 ) ) OR _
( UpperOther1 = "1" AND ( Microsoft.VisualBasic.DATEDIFF("d", ForStartDate, ForDate) MOD 28 = 0 ) ) then
wkly = SngRate
else
wkly = 0.0
end if
end if
newrate = cSng(ClassYTDRevenue.text) + wkly ' or to create a loop that calcs it once correctly, including W,1,B SOL freq
ClassYTDRevenue.text = newrate.tostring
newrate = cSng(TotalYTDRevenue.text) + wkly ' or to create a loop that calcs it once correctly, including W,1,B SOL freq
TotalYTDRevenue.text = newrate.tostring
END IF
NEXT

.....

Re: Need Report Designer VB FOR...NEXT loop

Method_Audisho — Wed, 01 Apr 2015 16:46:36 GMT

Hi Rob,

We don’t have any documentation for what is supported through VB and C# in Report Designer scripts. You can find a VB reference guide on Microsoft’s website. There may be a few limitations, but you will need to discover these through trial and error. Have you tried creating the script yet? What was the result?

I know we support For Each statements, and am fairly sure that you can use a For…Next statement. If you are having difficulty with a script, maybe you can tell me what you’ve got so far and detail what it is that you are trying to accomplish. I’m happy to look into it.

-Audisho

Need Report Designer VB FOR...NEXT loop

robert.cowart — Wed, 01 Apr 2015 16:11:32 GMT

I need a FOR...NEXT loop in an OnBeforePrint event. Where is the language documentation for all supported VB logical constructs within events in the Report Designer?

Thanks!