Table ImageCell with 1:n Relation not working

Stimulsoft Reports.WEB discussion
hydrant
Posts: 7
Joined: Mon Nov 14, 2022 8:08 am

Table ImageCell with 1:n Relation not working

Post 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
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Table ImageCell with 1:n Relation not working

Post 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.
hydrant
Posts: 7
Joined: Mon Nov 14, 2022 8:08 am

Re: Table ImageCell with 1:n Relation not working

Post 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
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Table ImageCell with 1:n Relation not working

Post 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.
hydrant
Posts: 7
Joined: Mon Nov 14, 2022 8:08 am

Re: Table ImageCell with 1:n Relation not working

Post by hydrant »

Hello, i have no clue, in which Format the Test Data and the expected result should be, which i send you...
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Table ImageCell with 1:n Relation not working

Post by Lech Kulikowski »

Hello,

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

Thank you.
hydrant
Posts: 7
Joined: Mon Nov 14, 2022 8:08 am

Re: Table ImageCell with 1:n Relation not working

Post 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
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Table ImageCell with 1:n Relation not working

Post by Lech Kulikowski »

Hello,

Please attache the image again.

Thank you.
hydrant
Posts: 7
Joined: Mon Nov 14, 2022 8:08 am

Re: Table ImageCell with 1:n Relation not working

Post by hydrant »

Sorry, here the zip with image...
Attachments
testimage.zip
(968.77 KiB) Downloaded 67 times
Lech Kulikowski
Posts: 6254
Joined: Tue Mar 20, 2018 5:34 am

Re: Table ImageCell with 1:n Relation not working

Post by Lech Kulikowski »

Hello,

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

Thank you.
Post Reply