Topic: Reorder tables in Crystal Reports.NET Posted: 24 Mar 2012 at 1:40am
Hello,
I have a problem with Crystal reports.NET. Just in case I am using VS 2010.
At the time of creation of report I did not know that order of tables is important in Crystal.
My problem is that I have 2 tables. First table is Details table and second is Header. Some times First table is empty. In this case Second table is not display data, although it always has it. In order to fix this problem I have to delete First table and add it again to have Detail table as second in order. But by doing this I loose all design of this table.
My question is. Is there another way of doing reordering tables?
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 26 Mar 2012 at 3:47am
you can change the link...
be default it is inner join, but you can change to the correct outer join...
or you can try changing how the link is drawn...if you drew it from the details to the header, try drawing from the header to the details and see if that corrects the issue.
Sorry I did not mention that I did not link tables. They have separate data that nothing to do with each other. That is why there is no need to link tables. First table has always 1 row and details table could have from 0 to hundreds.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 26 Mar 2012 at 9:50am
then I would probably use a subreport...keep the tables separatewon't hurt as you are only reading the data once...since there is no connection between them.
CR doesn't really like that set up as it doesn't know when to read the next row of one of the tables.
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
