iam doing a report named sales
this report read from the item ledger entry table
i want to right a code trlatrd to grouping
because my aim in this report is " if i want the item category code or product group code the report gibe me the total Qty & amount"
step 1 : new report and fill the related fields
step2: open the request page and select grouping
step 3: cal global : grouping as option
groupingvalue as option
valueentryrec as record
the code : If grouping := category then
groupingvalue:= valueentryrec."item category code"
else
groupingvalue:=valueentryrec."product group code"
when i save, an eror ocured
Answers
if options of any field then your code should look like
If grouping = category then
groupingvalue:= valueentryrec.<FIELD>::"item category code"
else
groupingvalue:=valueentryrec.<FIELD>::"product group code";
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
IF grouping::Item
Must be:
IF grouping = gruoping::Item
IF grouping = grouping::Item THEN
IF grouping = gruoping::Item
OR
IF grouping = 1(An INteger Value based n the option sequence)
Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/
- You do not have a boolean statement for the IF - it's just a value. You need to compare it to something. P.S. Please compare to the actual Option value and not an Integer constant
- There is a missing THEN
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!