logo

Warning: The forum is now for consultation only. Please use GitHub Discussions to post any questions or comments.


Welcome Guest ! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
Phoenix  
#1 Posted : Monday, October 7, 2019 11:20:40 AM(UTC)
Phoenix

Rank: Newbie

Groups: Registered
Joined: 9/24/2019(UTC)
Posts: 2
United Kingdom
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
epf  
#2 Posted : Monday, October 7, 2019 11:56:01 AM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
Did you define a Join between the 2 tables in your MetaData ?
Phoenix  
#3 Posted : Monday, October 7, 2019 12:28:50 PM(UTC)
Phoenix

Rank: Newbie

Groups: Registered
Joined: 9/24/2019(UTC)
Posts: 2
United Kingdom
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. :)
epf  
#4 Posted : Monday, October 7, 2019 2:04:51 PM(UTC)
epf

Rank: Administration

Groups: Administrators
Joined: 12/20/2013(UTC)
Posts: 1,209
Switzerland

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.
Users browsing this topic
Guest
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.