Joined: 31 May 2009
Location: United Kingdom
Online Status: Offline
Posts: 21
Topic: Help with report containing emty databases/fields Posted: 15 Jun 2009 at 5:52am
Hi,
I'm creating a report from a service management tool which has a number of linked tables. The table names I am using in the report are: Incident, Journal and task.
When creating a report with no entries in the journal field the report results are blank for all fields (including those from Incident and Task).
When there is data in the Jornal database the report works just fine.
Is there some sort of formula or option setting I can change to prevent this from happening?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 15 Jun 2009 at 6:56am
Not sure exactly what youa re trying to accomplish. The type of join you set up in your tables as well as your select statement will impact this. If you can explain more exactly what youa re trying to accomplish and what your set up is we may be able to give you more direction.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Posted: 15 Jun 2009 at 7:16am
Sounds like all the tables are linked as inner joins, which means that the data the that the tables are joined on HAS to EXIST in all tables at the same time.
If you know that one of the tables maybe blank, but that the other tables still have information that you can report on, then change the links to OUTER JOINS. You might have to experiment which way the joi goes,but go to the database, right click on the link and select a link type that is an outer join.
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
IP Logged
