CodeCharge Studio
search Register Login  

Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> General/Other

 Navigator doesn't work in grid when source is a stored procedure

Print topic Send  topic

Author Message
rbaldwin

Posts: 156
Posted: 06/05/2008, 10:49 AM

I know that the navigator on a grid does NOT work properly when the data source for the grid is a stored procedure.

Has anyone figured out how to either make it work or has anyone got a suggestion for manually adding a set of navigation links.

vb.net if you can. I have 1000+ plus rows being returned from a stored proc.
View profile  Send private message
wkempees


Posts: 1679
Posted: 06/05/2008, 11:59 AM


Are you sure this is not the same 'problem' the navigator has when it does not know the number of returned rows like when using a GORUP BY?

When using 'group by' you "CCS Not count" message instead of recordcount in a grid.
Using 'group by' does not goes well with count(*) because the computer doesn't "know" what you really need... So use BeforeExecuteSelect to set the CountSQL query
SELECT COUNT(*) FROM table WHERE ......

Walter




_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)

if you liked this info PAYPAL me: http://donate.consultair.eu
View profile  Send private message
rbaldwin

Posts: 156
Posted: 06/05/2008, 1:05 PM

i provided a solution here
http://forums.codecharge.com/posts.php?post_id=97567
View profile  Send private message

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.