3,015
I am almost finished creating this report but can't figure out how to write an expression for the part circled in red.
Here is what my report should look like (critical information provided)
*This post is locked for comments
I've created this report in Report Builder 2.0. I should have specified that.
I need to know how to create the expression in report builder 2.0.
This looks like it would be easier in an Excel Pivot Table. Do you have SmartList Builder (which includes Excel Builder and the data connections you need)?
Hi Painterissac,
For your scenario,
if date range as parameter, use 2 temp table for 2 date ranges. attach the 2 temp tables in your report to display the Item Sum as you displayed above.
In case of smartlist report use 2 views to display the above case.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
