NeoBookDBPro Report Designer
Quote from PaulJonestindall on February 24, 2020, 3:58 pmDoes anyone know: Can you create/print a report using data from two separate databases? I'm using v1.6 which is almost 10 years old. Might this be a feature of NeoDBPro? Would it have a newer Report Designer version?
Does anyone know: Can you create/print a report using data from two separate databases? I'm using v1.6 which is almost 10 years old. Might this be a feature of NeoDBPro? Would it have a newer Report Designer version?
Quote from Gaev on February 24, 2020, 7:28 pm@pauljonestindall
Can you create/print a report using data from two separate databases?
That is a very general (all encompassing) question ... the short answer is NO ... but, depending on what kind of information you require from the different databases, you might be able to create a unified view ... and then bind the Report to this View ... however, this requires use of advanced (and complicated) SQL commands that you can invoke using neoDBProExecSQL.
To understand some of these SQL commands, take a look at these help pages ...
https://www.w3schools.com/sql/sql_view.asp
https://www.w3schools.com/sql/sql_join.asp
Can you create/print a report using data from two separate databases?
That is a very general (all encompassing) question ... the short answer is NO ... but, depending on what kind of information you require from the different databases, you might be able to create a unified view ... and then bind the Report to this View ... however, this requires use of advanced (and complicated) SQL commands that you can invoke using neoDBProExecSQL.
To understand some of these SQL commands, take a look at these help pages ...
https://www.w3schools.com/sql/sql_view.asp
https://www.w3schools.com/sql/sql_join.asp
Quote from PaulJonestindall on February 25, 2020, 6:11 pm@Gaev
Thanks for the links. I'll give them a look.
Thanks for the links. I'll give them a look.
Quote from dglojnar on February 25, 2020, 8:47 pm@pauljonestindall
Did we talk about 2 completely different databases, or 2 different TABLES inside on database ?
You can make a report using two different databases if you have some kind of relation or common points between these two databases.
If you don't, you have to make some "fake" relation using SQL or using filter/search option in DBPro.
You can also make a temp database with fields from databases you need and then make a report - back in time I was doing a lot with DBF files, somehow annoying and dirty, but works.
Making report using two different tables inside database is trivial job - (INNER) JOIN solve the problem,
Also, you can run some query in 2 steps and final result show in report...
Not an simple task for you bro...not at all:-)
Cheers
Did we talk about 2 completely different databases, or 2 different TABLES inside on database ?
You can make a report using two different databases if you have some kind of relation or common points between these two databases.
If you don't, you have to make some "fake" relation using SQL or using filter/search option in DBPro.
You can also make a temp database with fields from databases you need and then make a report - back in time I was doing a lot with DBF files, somehow annoying and dirty, but works.
Making report using two different tables inside database is trivial job - (INNER) JOIN solve the problem,
Also, you can run some query in 2 steps and final result show in report...
Not an simple task for you bro...not at all:-)
Cheers
Quote from dglojnar on February 25, 2020, 8:50 pmI forgot....
Be prepare for a some manual editing etc...there's no easy process to automatized that..you can, of course, but you need to create a automating process emulating manual editing...
I forgot....
Be prepare for a some manual editing etc...there's no easy process to automatized that..you can, of course, but you need to create a automating process emulating manual editing...
Quote from PaulJonestindall on February 26, 2020, 11:45 amThank you all for the suggestions. I do believe I'm simply going to have to literally join the two databases. By that I mean create a new table in my original database file and copy all the data from the other database file there. That's easy enough with a Loop action and then from there printing a report from two tables is, as someone put it, trivial.
Thanks again guys.
Thank you all for the suggestions. I do believe I'm simply going to have to literally join the two databases. By that I mean create a new table in my original database file and copy all the data from the other database file there. That's easy enough with a Loop action and then from there printing a report from two tables is, as someone put it, trivial.
Thanks again guys.