Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Returns expresion instead of data

Status
Not open for further replies.
jcglenn

jcglenn

Programmer
Aug 14, 2006
12
US
I am using this expression
iif(Sum(Fields!Net_Sales.value) = 0, 0, sum(Fields!Aquisition_Cost.value)/sum(Fields!Net_Sales.value))

It returns the expression instead of the data.

What am I doing wrong?

Thanks,
Craig
 
Sort by date Sort by votes
Found it. missing the =

Thanks anyway
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
463
PeterDimitrov
PeterDimitrov
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
361
Theresajn
Theresajn
Johnhny
  • Locked
  • Question
SSRS Grouping Imputes missing data
Replies
0
Views
390
Johnhny
Johnhny
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
346
Ashajohn2021
Ashajohn2021
arunaramana
  • Locked
  • Question
difference ways of creatin
Replies
1
Views
376
MarkSweetland
MarkSweetland

Part and Inventory Search

Sponsor

Back
Top