This is a migrated thread and some comments may be shown as answers.

table with column summing up from 2 different datasource

1 Answer 224 Views
Report Designer (standalone)
This is a migrated thread and some comments may be shown as answers.
Lily
Top achievements
Rank 1
Veteran
Lily asked on 14 Aug 2019, 03:27 PM

I'm having issues with trying to add column that will perform arithmetic using info from 2 different tables with different datasources...

And because I need to expand upon info in the field.  I don't think I can put in simple arithmetic using the textboxes.. but I can't select the field from the other table... so how can I do this?  I attached a pic explaining it...

 

Please help?

1 Answer, 1 is accepted

Sort by
0
Lily
Top achievements
Rank 1
Veteran
answered on 15 Aug 2019, 02:08 PM
I figured it out.  I ended up setting up a new parameter then attached the datasource for that field then in the 2nd table where I used the parameter in my equation
Tags
Report Designer (standalone)
Asked by
Lily
Top achievements
Rank 1
Veteran
Answers by
Lily
Top achievements
Rank 1
Veteran
Share this question
or