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; } } }

SubDataSet not displaying data

onthegomiller

Hello,
 
I'm having trouble displaying data from a sub-dataset that I created in a report that I inherited. The report doesn't error out or anything. It just doesn't display the data when I create a table, bind the table to the new dataset and display the data to the report. Nothing displays at all.
 
I'm sure it's something simple I've missed but I just can't figure it out.
 
I've attached the report. It's the HistSubDataSet that I added. There is a table at the bottom of the report with a header that reads "Transaction History". It is there that I'm trying to display the data from the new dataset. 
 
Any suggestions would be greatly appreciated.
 
Thank you!

Find more posts tagged with

Comments

JFreeman

Does the rest of the report display properly other than the table you added?
If you preview the data set you added does it return data?

onthegomiller

Yes, the rest of the report display properly (there are two additional datasets that display as they should). Preview doesn't work well in the environment I'm working in (these are reports that are imported into IBM Maximo so I've never been able to successfully preview within BIRT).
 
This was a new dataset that I added. The other two datasets already existed in the report. So, maybe I forgot some piece that I need to do? 
 
Any ideas?

JFreeman

I believe the issue is going to be that your data set does not have any data.
 
Looking at the Data Set you added, I believe the issue is going to be with the scripting you have in the Fetch of the data set. In the Open of the data set you open the data set as "PRHistDataSet" but then in fetch you are trying to access the data set using "PRlongDescDataSet".
 
Try modifying the Fetch to align with your Open.

onthegomiller

Made the change and still no data is displayed. That was a copy and paste error on my part...but it didn't resolve the problem unfortunately. Any other ideas?

JFreeman

Unfortunately, I've not been able to use a Maximo based installation extensively so there may be some factors here that I am not aware of. However, based on looking at the report design, the table appears to just be a basic table bound to the data set so I still believe the issue is going to have to do with the data set returning empty.
 
I see one more issue in the Fetch of the new data set. The if statement at the start is checking against the wrong data set (subDataSet instead of PRHistDataSet) which means the if statement will never be true. 
 
Otherwise, I would add some logging into the script populating the data set to try and debug it to very it is generating with data properly.
 
You can also replace one of the data elements in your tables detail row with a basic text box just to verify the table is generating properly. This will help confirm the table is generating properly and that the issue does appear to be related to the data in the data set.

onthegomiller

Thanks, JFreeman. I modified the additional copy and paste error but that didn't fix the problem either. I placed a textbox into the table to ensure that it was displaying and it is definitely displaying that ok, so it must be in the data w/in the dataset. But when I copy and paste the query into TOAD it returns data. 
 
Anyway, thanks for your time. If you can possibly think of something else that I may have forgotten, please let me know.
 
I have another report that is acting similarly. It returns the total number or rows to the report at the bottom (so the query is working) but the rows that display to the report are empty.
 
I'm sure this is a recurring theme, I just can't figure out what it is.
 
Thanks again...if you have any additional thoughts, please do share.

JFreeman

One more thing that I see in the Fetch of you new dataset is the names used for the rows you are pushing the data into do not completely align with the actual row names in the data set.
 
For example, you have "row["histSiteid"]" but the row name in the data set is "histsiteid" without any capitals.
 
It also appears some of the names you are using in the .getString() calls do not align with the names used in your query built in Open.
For Example, you are calling .getString("histprnum") whereas your query is "PRNum as histPRNum".
 
Could you go through and make sure both the rows and the getString calls are all aligned properly including matching case?