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...
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.
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"...
Hilfy's recommendation is how I have our security set up but there are some people who are part of a Group (say Retal) who need to be able to access the Accounting reports. So, rather than grant access to the whole Retail Group and because I don't want to the person from Retail to be able...
Have you tried going into the cmc\folders\objects, select the report, click rights, add\Removethen in the selectoperation drop down, select users, find theusers name, add him\her click "OK" and give them the necessary rights. I'm guessing "View on demand" unless the inherited rights will give...
No problem, sorry I didn't fully understand if you started with and SP or if you switched to using one to fix this problem. Good luck and happy reporting.
Exactly, That's why I started my post by saying "There are ways of doing this through Crystal...". It was unclear to me if the report was based on a stored procedure or if he created a stored procedure to deal with the parameter issue. So, I suggested a very easy way of dealing with this...
Davida, there are ways to do this through Crystal as well.
Create a copy of the report, delete the parameters and set the values you need for the report.
For instance, We have a sales report someone wants in their inbox every monday morning. I make a copy of the report with SchedVers at the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.