CodeCharge Studio
search Register Login  

Web Reporting

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

YesSoftware Forums -> CodeCharge Studio -> General/Other

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

Print topic Send  topic

Author Message

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. if you can. I have 1000+ plus rows being returned from a stored proc.
View profile  Send private message

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


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:
View profile  Send private message

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

i provided a solution here
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

MS Access to Web

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

Home   |    Search   |    Members   |    Register   |    Login

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