duplo1
Posts: 67
|
| Posted: 01/04/2008, 1:39 PM |
|
Has someone worked with SQL Server Stored Procedures and Codecharge before ????
I have a main SQL Server Database which collects information using store procedures from other sql server databases to generate reports. My clients wants to go online with those reports.
Is there a possibility to use those stored procedures in CCS ????
Please help.
|
 |
 |
mljonzs
Posts: 124
|
| Posted: 01/11/2008, 2:34 PM |
|
Yes, you can use SP's in CCS.
I don't have much time to go into detail but can say this. Rather than basing on a table, you may select an SP to use for record source, especially if the SP returns a record set that you wish to base your report/form on.
Good Luck.
_________________
What does not begin WITH God, will end in failure!
|
|
|
|
martinc
Posts: 5
|
| Posted: 02/10/2008, 7:04 PM |
|
Stored procedures will work fine for reports, but I see the main problem with stored procedure is they can not be used if you want to use the in built page navigation.
Though I think they can easily fix this if CCS put a specification on the stored procedure where it must return an extra record set that returned a field containing the total records,or have a way to set the total pages in code, so the paging control can use this value for the total pages.
|
|
|
|
|
