Execute Dataset

hello,

I have 10+ datasets in my report. I am storing all the results of these queries/datasets in an array using fetch method. I added Data components(binding to datasets) in my report for each dataset which are hidden in final output. I added these components for just to execute all these datasets.

1. is there any way, we can execute the datasets without binding to component. so that I no need to add components like (Data,table..etc)?

2. how can i show the results stored in array in my final output?

Thanks
Suresh

Find more posts tagged with

Comments

mwilliams

If you're using a BIRT dataSet to get your results, you have to have a report element tied to it, to make the dataSet run. It doesn't have to be a table, though. You can bind a text element to a dataSet and it will run. If you want to use your array to create your output how you'd like, you can use a text box (after the elements bound to the dataSets, so they run first and populate the array) to build your own HTML table. Hope this helps.

spulapalli

thank you.

Instead of using text control, can we use this array in table object to display? I mean, can i use the array
as a dataset for table component. I just want to display in report not as html.

Thanks
Suresh

mwilliams

Maybe I'm confused. Why are you using arrays rather than just using the dataSet? A table must be bound to a dataSet to iterate through it.

spulapalli

hello,

i have function/class created in Initialize method.
function list() {
var Text
var display=false
var Sort
var width
}

var ldarray= new list();
for (e=1000;e<=2000;e++)
{
ldarray[e]=new list();
}

as i said, I have a couple of datasets in report. each dataset returns some columns and which are populated into ldarray based on some business logic. after populating array, I wanted to display array values in report.

if you have any other workaround solution for this, please let me know.

mwilliams

The best solution for you will be to use your array to create a scripted dataSet. You can then use this dataSet in a table element to display the information how you'd like, without building your own table in a text box.

spulapalli

thank you William.

do you have any sample reports, how to create scripted datasets? or any help contents

mwilliams

If you go to Window->Show View->Other->Report and Chart Design->Report Examples, then go to the scripting examples, you'll see a sample scripted dataSet example. If you have issues with that, let me know and I can make you a more specific example, to your issue.

akhilp

thank you.

let me try first, if I can't then will get back to you.

mwilliams

Sounds good.