Rank: Newbie
Groups: Registered
Joined: 9/24/2019(UTC) Posts: 2  Location: Chorley
|
I cannot find this on the forum so apologies if i have missed it.
I have 2 tables which i need to show in one column on a report. In this case it is invoices and credits, I cannot find anyway to do this. So for example one column for customer, another for document number (invoice or credit number) another for value.
looking at invoice header and line tables.
I am sure there is a relatively easy way of doing this.
I am new to seal reports (and SQL) so any help will be greatly appreciated.
Thanks
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Did you define a Join between the 2 tables in your MetaData ?
|
|
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 9/24/2019(UTC) Posts: 2 Location: Chorley
|
I have joined the header and lines togehter for invoices and the same for Credits, i could link the Invoice and credit tables together by linking the customer but my issue is that i want to try and show the value field for invoice adn the value field for credit in the same column on the report.
Like i say i am new to this so i am probably missing something incredibly obvious
thanks for the quick response by the way. :)
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209 Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
perhaps you should consider to create a view having the values of the 2 column in one column...
otherwise, you can change the SQL generated for your report:
Select the element in your model, then change the property 'Advanced/Custom SQL' then set the SQL you want like 'Table1.Col1 + Table2.Col2'.
If the Table1 and Table2 are in the query, it should work.
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
