|
Re: Total 500 records for two rows [message #1389586 is a reply to message #1389386] |
Sat, 28 June 2014 02:25 |
|
What version of BIRT are you using? Are you not using 4.3+ where you have a POJO data source? If using a scripted datasource, it just sounds like something is broken when incrementing your loop. Can you post your code in the open and fetch methods if using a scripted dataSet?
Michael
Developer Evangelist, Silanis
|
|
|
|
Re: Total 500 records for two rows [message #1391280 is a reply to message #1391202] |
Mon, 30 June 2014 17:45 |
|
The first thing I see is that varcount=0 will need to be moved to your open method. By having it in the fetch method, it's called for every single row, meaning that your count starts over each time you fetch a row. This would be why you're getting the first row many times. You probably also have other issues with how you increment varcount in each if statement and possibly others with your while loops. Inside a single fetch statement, you'll just be overwriting the row value each time the while loop passes, but maybe that's what you're trying to do. Anyways, let me know what happens after you move the varcount=0 line to your open method.
Michael
Developer Evangelist, Silanis
|
|
|
Re: Total 500 records for two rows [message #1391297 is a reply to message #1391280] |
Mon, 30 June 2014 18:22 |
ankita muley Messages: 5 Registered: June 2014 |
Junior Member |
|
|
I moved the varcount to open method. and Now the one record in the result set. Regarding the increment of varcount, I am trying to output all the XXXlist, and hence I am increment varcount till all the XXXlist are traversed. But as you are saying it's actually overriding the row value hence one record only.How can I make it work without overwriting. Also Is it possible to group output of these list.
[Updated on: Mon, 30 June 2014 18:33] Report message to a moderator
|
|
|
Re: Total 500 records for two rows [message #1391320 is a reply to message #1391297] |
Mon, 30 June 2014 19:19 |
|
You're only wanting two rows, right? I'm not sure what you're trying to do with your tileList, cracList, and rackList loops, so it's hard for me to say. The fetch method only outputs a single row, so if you're attempting to produce more than one row within your while loops, it won't happen.
I guess what you're doing with the maxcount will work since you're duplicating the counts and then incrementing varcount each time, so that probably won't hurt anything. You probably don't need to subtract one from the summation though.
If you can show me what you're getting or at least some dummy data of what you're getting and what you're expecting, I can probably figure out more.
Michael
Developer Evangelist, Silanis
|
|
|
|
|
Powered by
FUDForum. Page generated in 0.04116 seconds