More than one Business Object in the report

Сonversation on different topics
Post Reply
davivieira
Posts: 3
Joined: Tue Jul 25, 2023 7:40 pm

More than one Business Object in the report

Post by davivieira »

I have an organization problem. I need to fetch data for 'Contracts,' 'Equipment,' and 'Billings' from C# code.

The issue is that the data is being retrieved one business object at a time, and it's not in the format I require. What I need is to fetch one contract at a time, along with its associated equipment and billing information. Currently, the data is coming either with just the contract, equipment, or billing details separately. Moreover, when all the data is retrieved correctly, it's not organized properly. All contracts come first, followed by all equipment, and then all billings.

I believe the error lies in the data organization. Could you please help me?" https://prnt.sc/U06c_ePZm-Le
Image
Last edited by davivieira on Wed Jul 26, 2023 12:12 pm, edited 3 times in total.
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: More than one Business Object in the report

Post by Lech Kulikowski »

Hello,

Please provide more detailed information about the issue.

Thank you.
davivieira
Posts: 3
Joined: Tue Jul 25, 2023 7:40 pm

Re: More than one Business Object in the report

Post by davivieira »

Sure! I gess what my image is not upload in the text but my problem is in the use of business object in the report when i try used more than one data. I'm edited the text for put the image for be more specific and help to be clearer and in this three business object i'm have to put all inside of the one GroupHeaderBand
__________________________________________________
| Header Principal |
|__________________________________________________|
| GroupHeaderBand; condition
databand1; Business Object: Dados |
| Dados |
| - Dados.1: Valor1 | Dados.2: Valor2 | Dados.3: Valor3 |
| | |
|
databand2; Business Object: Equipamento |
| Equipamento
| - Equipamento.1: Valor1 | Equipamento.2: Valor2 | Equipamento.3: Valor3 |
| | | |
|databand3; Business Object: Faturamento |
| Faturamento
| - Faturamento.1: Valor1 | Faturamento.2: Valor2 | Faturamento.3: Valor3 | |
| |
|__________________________________________________|

if the image is broken here a example in ASCII
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: More than one Business Object in the report

Post by Lech Kulikowski »

Hello,

Could you send a sample project with test data that reproduces the issue for analysis?

Thank you.
davivieira
Posts: 3
Joined: Tue Jul 25, 2023 7:40 pm

Re: More than one Business Object in the report

Post by davivieira »

Hi,
So... I edit the first text and put the image (https://prnt.sc/U06c_ePZm-Le) but i'm will send the report on this links:
This is the report correct with one contract https://prnt.sc/aoKBnDEJMN6s and when i bring more contract come in this format.
But when i'm put more than one contract this happen https://prnt.sc/TEBzs5GlAHJc ALL the first "Contrato" come first, after the "Equipamento" and for the last "Faturamento"
Lech Kulikowski
Posts: 6271
Joined: Tue Mar 20, 2018 5:34 am

Re: More than one Business Object in the report

Post by Lech Kulikowski »

Hello,

Unfortunately, it is difficult to say something without a sample. Sorry.

Thank you.
Post Reply