Webeport not fetching all data

[sapanram]

Hello Everyone,

I have created a web report which first selects few parents folders data ids.
For these folder a sub query then goes and fetches the count of documents created in the last month.
my repository has a hug number of documents

Problem: when i export the report then it only fetches count for 3-4 folders only, instead of 20+ as expected.

I feel there is some of kind of time out which comes into picture while the source live report is running.

when i remove the sub query to fetch count i see the correct data. This is why i feel time-out impacting the execution.

any directions are welcomed.

TIA
swapnil

 

[ggriffit]

You should be able to do all of this in a single SQL statement, if you look in the CONNECT logs you can see the actual SQL that is sent to the database, so I'd start with that to ensure you get what you expect.

Greg Griffiths
Livelink Certified Developer & ECM Global Star Champion 2005 & 2006

http://www.greggriffiths.org/livelink/