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

Dataset SQL doesn't execute

onthegomiller

Hello,
 
I'm having difficulty getting some dataset sql to execute (that I added to an existing report).
 
When I turn logging on I can see all of the sql statements (in the datasets that existed) execute except the new one that I added.
 
I've looked at it for so long I don't think I can see the forest thru the trees.
 
The dataset is named subDataSet1 in the attached report. It is a very simple sql statement that queries the timezone from a table based on a userid.
 
Any help would be greatly appreciated
 
Thank you in advance.
 
Kim Miller

Find more posts tagged with

Comments

pricher

Hi Kim,
 
In order for a dataset to be executed, it needs to be bound to an object in the report such as a table, a list, a grid, a chart, or a data item. The subDataSet1 query is not bound to anything, hence the BIRT engine will not run it. The workaround is simply to bind the dataset to a data-aware object and make that object hidden by using the Visbility property.
 
Hope this helps,
 
P.

onthegomiller

Hi Pierre,
 
So, essentially you're saying that if I add a field to the report and tie it to the dataset then all will be well?
 
Holy. That's a pretty simple solution! I guess I should have been able to find this is online documentation but I completely missed it (my fault).
 
I will try this out and hopefully it resolves the issue.
 
Thank you so much for your time. I'm more appreciative than I can say. 
 
Kim

onthegomiller

Pierre,
 
I have another question that maybe you can answer.
 
If I move that dataset to the top of the datasets (so it becomes the first dataset) shouldn't that attain the rows[0] value and all subsequent datasets fall into place after that (e.g., rows[1], rows[2], rows [3])?
 
I read that the dataset order is enforced by the order within the xml script.
 
When I move that dataset to the top of my report and modify the references to rows[0] my report doesn't run correctly.
 
Hopefully I'm making sense.
 
I ultimately want to use the timezone value in the former main sql so the new dataset to the top. It doesn't appear that subsequent datasets adjusted. I modified my old rows[0] reference to rows[1] but those datasets now don't run.
 
Is there something else I need to do in order to modify the dataset order so that I can incorporate the new dataset as rows[0]?
 
Let me know if this doesn't make sense.
 
Thank you.
 
Kim

pricher

I am not sure I understand fully... Datasets run in the order they appear in the Data Explorer. It's the part about rows[0] rows[1] etc that I don't understand.
 
P.