Recent content by RobbieB

Interesting solution Lbass, thanks for posting it. I've had the same problem in the past and hadn't thought of this. Thanks.

Also, do you have it in the header or the footer? If you have your summaries in the footer move hem all to the header and try formatting that section.

Your syntax is correct (I usually use If remainder (groupnumber,2) <> 0 then cryellow else nocolor) but does not always work when there is more than one group. If there is a group at a "higher level" than this group you will not always get the desired effect.

Try changing this section to numbervar mytot:=mytot+{Command.APPROVED}%(if Sum ({@po}, {Command.RCVR} = 0 then 1 else Sum ({@po}, {Command.RCVR})) I'm guessing this is the field causing your error.

once you have selected the "dynamic" radio button creating a dynamic parameter in XI you then need to specify which field to use in the value field of the edit parameter screen.

That's why I had this part in the code. "if Sum({Orders.Order Amount}) = 0 then 0" to account for the sub report not having data. You could also create a default value for the second example I gave but I didn't include it.

Hey ForMe2, you can do this a couple of ways. You SHOULD be able to say in the formula in the sub report - WhilePrintingRecords; Shared CurrencyVar myTotal; if Sum({Orders.Order Amount}) = 0 then myTotal:=0 else myTotal:=Sum({Orders.Order Amount}) OR you can do it by putting this formula...

Even using an ODBC connection with tables from two different data bases I have had this problem.

Are the two tables from the same datasource? The only time I've had this happen was when joining to tables from different datsources.

This is great SynapseVampire but what does the number 430 represent. that is the only part of the funtion I don't get. Thanks, Rob

If you are trying to suppress the {cpmain.plaintiff} in the report when the parameter is selected you should be puttting this formula in the the formatting of this field. You should right click the {cpmain.plaintiff}, select format field, select the common field and click the X-2 button to...

When reports are published to your intranet there is an option to put in a user name and password for the data source so the end-user does not have to. There is the possibility that the old report writer used his user name and password when publishing the reports and now that his user name and...

If I understand your question the answer is yes. You can insert a text box and right click it, select format text, and under the border tab click "background" and designate a background color.

close, try If isnull({?Long Plaintiff}) then {cpmain.plaintiff} else {?Long Plaintiff}

Did you make sure your virus protection software is allowing access through port 25? If you are using McAffee right click the icon in the sys tray, go to virus scan console, double click access protection and make sure the first item in the list "Prevent Mass Mailing Worms From Sending E-Mail"...