Page 1 of 2

Table ImageCell with 1:n Relation not working

Posted: Mon Nov 14, 2022 8:22 am
by hydrant
Hello, we generate a report with the table components. There is a way to include images into the table: Cell Type -> Image and Data Columne -> relation to the datatable with the datacolumn (BLOB). This approach works as long there is only one picture (1:1 Relation). But as soon there is a 1:n Relation (Object has more then one picture) this approach is not working. We try it as well with an external DataBand, which MasterComponent is the table. This works with 1:n Relation, as well. But the problem here is, if the object from the table has no Relationship to an image, the result (preview) is totally empty. May be there is another approach. Thanks

Re: Table ImageCell with 1:n Relation not working

Posted: Mon Nov 14, 2022 10:21 pm
by Lech Kulikowski
Hello,

Please try to set the PrintIfDetailEmpty=true property for the DataBand.
If the issue is still present, please send us a sample report with test data for analysis.

Thank you.

Re: Table ImageCell with 1:n Relation not working

Posted: Fri Nov 18, 2022 1:48 pm
by hydrant
Hi, the suggestion works with "PrintIfDetailEmpyt=true". Thanks a lot. But now, we want another approach: The report should be for every record the following structur:
first: table with some information, second: databand with image, third: table with rest of record information. We try the approach first a MASTER-Table with some information and the second table depends on the MASTER Table.
The result is for example at two selected records:
MASTER Table First Record
MASTER Table Second Record
Databand with image doesn't appear (of example first record)
"child" Table First Record
"child" Table Second Record

But our wish would be the order MASTER Table First Record, Databand Image First Record, "child" Table First Record and following MASTER Table second Record, Databand Image Second Record, "child" Table second Record and so on...
Do you have another approach for this task?
Thanks

Re: Table ImageCell with 1:n Relation not working

Posted: Fri Nov 18, 2022 1:56 pm
by Lech Kulikowski
Hello,

Could you send us test data and the expected result, we will try to find a solution for you.

Thank you.

Re: Table ImageCell with 1:n Relation not working

Posted: Fri Nov 18, 2022 2:46 pm
by hydrant
Hello, i have no clue, in which Format the Test Data and the expected result should be, which i send you...

Re: Table ImageCell with 1:n Relation not working

Posted: Fri Nov 18, 2022 3:40 pm
by Lech Kulikowski
Hello,

Data in XML, JSON, excel and result as image or excel file.

Thank you.

Re: Table ImageCell with 1:n Relation not working

Posted: Sat Nov 19, 2022 1:03 pm
by hydrant
Hello, one problem is solved (this with multiple records ). Another exists yet: Problem with gap between different Data(table)bands. I attached image example

Re: Table ImageCell with 1:n Relation not working

Posted: Mon Nov 21, 2022 7:10 am
by Lech Kulikowski
Hello,

Please attache the image again.

Thank you.

Re: Table ImageCell with 1:n Relation not working

Posted: Mon Nov 21, 2022 10:08 am
by hydrant
Sorry, here the zip with image...

Re: Table ImageCell with 1:n Relation not working

Posted: Mon Nov 21, 2022 11:30 am
by Lech Kulikowski
Hello,

It is impossible to say why the gaps appear without a report template.

Thank you.