Using Visual Basic with Brio.Report

[kamm]

Does anyone know where I can see some examples of Visual Basic code which show how to set the limits in a report?

 

[cherrya]

its not vb but this is how to do it using an eis which requires the user to logon with a name and password followed by the required dates for the limits.


with (ActiveDocument.Sections["eisLogon"])
{
if (Shapes["txtName"].Text=='')
{
Alert('Please Enter Your Iris Logon Name')
}
if (Shapes["txtPassword"].Text=='')
{
Alert('Please Enter Your Iris Password')
}
if (Shapes["txtFrom"].Text=='')
{
Alert('Please Enter a From Date')
}
}
if (Shapes["txtTo"].Text=='')
{
Alert('Please Enter a To Date')
}
if (PressCheck !='Yes')
{
Alert('Please press the Logon Button')
}
else
{
Sections["QryLate>£10,000"].Limits[2].SelectedValues.RemoveAll()
Sections["QryLate>£10,000"].Limits[2].Operator=bqLimitOperatorBetween
ActiveDocument.Sections["QryLate>£10,000"].Limits[2].SelectedValues.Add(txtFrom.Text)
ActiveDocument.Sections["QryLate>£10,000"].Limits[2].SelectedValues.Add(txtTo.Text)
}

the Limits[2] refers to the date choice being the second choice on the limits section.