Hi,
In LiveRepots I need to execute huge data.
For executing whole data with out limit in "record limit" field is it posible?
I tried by placing "0" in recordlimit field but result is empty.
Ahy help would be appreciable.
Regards
Praeeep.
You don’t want to do that with a LiveReport. I suggest you run your SQL query directly on the database.
Hans
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Dienstag, 29. Oktober 2013 11:24To: eLink RecipientSubject: To Run LiveReport With out limit in recordlimit field
To Run LiveReport With out limit in recordlimit field
Posted bykpkumar@ncs.com.sg (Kothapalli, Pradeep) On 10-29-2013 06:19
[To post a comment, use the normal reply function]
Forum:
Content Server LiveReports Forum
Content Server:
Knowledge Center
RE To Run LiveReport With out limit in recordlimit field Posted byhstoop@opentext.com (Stoop, Hans)On 10-29-2013 07:35 You don’t want to do that with a LiveReport. I suggest you run your SQL query directly on the database. Hans From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: Dienstag, 29. Oktober 2013 11:24To: eLink RecipientSubject: To Run LiveReport With out limit in recordlimit field To Run LiveReport With out limit in recordlimit field Posted bykpkumar@ncs.com.sg (Kothapalli, Pradeep) On 10-29-2013 06:19 Hi,In LiveRepots I need to execute huge data.For executing whole data with out limit in "record limit" field is it posible?I tried by placing "0" in recordlimit field but result is empty.Ahy help would be appreciable.RegardsPraeeep.[To post a comment, use the normal reply function]Forum: Content Server LiveReports ForumContent Server: Knowledge Center
This electronic message contains information from MeadWestvaco Corporation or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.
Hi Hans,
Thank you for your reply,
Hear i am using livereport as source for webreport.
Regards,
Pradeep.
If you have LiveReport Extensions on your system (will be included automatically in CS 10.5) you can un-tick the option that says “Use Fetch Cursor Mode” and the record limit goes away. This mode is also faster in terms of executing the SQL. When you un-tick this box it will warn you that there is no longer a limit and it will suggest SQL that you could add to your query if you want to add your own limit.
Cheers
Greg
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: October-29-13 5:36 AMTo: eLink RecipientSubject: RE To Run LiveReport With out limit in recordlimit field
RE To Run LiveReport With out limit in recordlimit field
Posted byhstoop@opentext.com (Stoop, Hans) On 10-29-2013 07:35
Posted by kpkumar@ncs.com.sg (Kothapalli, Pradeep) On 10-29-2013 06:19
Topic:
I just saw that this is a source for a WebReport so this means you are licensed to use LiveReport Extensions. If you don’t have it installed you can get it from the same download area that has WebReports (or via a shortcut).
From: eLink Entry: Content Server LiveReports Forum [mailto:livereportsdiscussion@elinkkc.opentext.com]Sent: October-29-13 11:22 AMTo: eLink RecipientSubject: RE RE To Run LiveReport With out limit in recordlimit field
RE RE To Run LiveReport With out limit in recordlimit field
Posted bygpetti@opentext.com (Petti, Greg) On 10-29-2013 13:20
Posted by hstoop@opentext.com (Stoop, Hans) On 10-29-2013 07:35
Thank you very much Greg,
Pradeep
