nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to add query result to Libre Office

chetan_1981

Hi,
 
Question : 1
I have Service Report done with query. I have 15 types of Services and 5 Offices. I have the report in Cross Tab. The issue I am facing is that when particular Service Type is not there i.e. No Data then this service type is not showing in Query Result and same is displaying in birt report. But, I have to display all the Service Types irrespective of the service data is there or not. 
 
Is it possible in Cross Tab to display all Columns whether they are having no data.
 
Question : 2
 
Also, find attached Report Template. Is there any way to put Query result in this template using birt. I am having 
 
Please advice for both questions. Thanks in advance.

Find more posts tagged with

Comments

icirillo

Hi Chetan,
 
For first question, is there any chance you can provide an example I can run on my side and reproduce the problem locally? Also what version of iHub/Birt designer are you using?
 
For second question, I would recreate the same template in a Birt report.

chetan_1981

Hi Ivano, 
 
Thanks for immediate reply. Find attached Service_Report.rptdesign
 
I am using birt eclipse 3.6.2 
 
Chetan

icirillo

I cannot run the provided report. I would need a report I can run on my side in order to reproduce the problem.

micajblock

<blockquote class="ipsBlockquote" data-author="chetan_1981" data-cid="144656" data-time="1469001777">
<div>
Is it possible in Cross Tab to display all Columns whether they are having no data.
</div>
</blockquote>
In the query do an outer join to the service type, that way all Service Types will always be in the result set.

chetan_1981

Hi,
 
Thanks for advice. I solved the issue by using joint data sets.
 
Regards,
Chetan

micajblock

That works but doing it on the database in most cases will be faster.