Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: I have Stored prosuder Post Reply Post New Topic
Author Message
nrywax_gamayi
Newbie
Newbie
Avatar

Joined: 01 Aug 2011
Location: Indonesia
Online Status: Offline
Posts: 2
Quote nrywax_gamayi Replybullet Topic: I have Stored prosuder
    Posted: 09 Aug 2011 at 6:01pm
i have stored prosedur and in strored prosedur have parameter
but i want the parameter = table in sql
so will i change page the parameter change self.
please help me Cry
i want learn crystal report
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 10 Aug 2011 at 5:40am
I'm not sure that I understand what you're trying to do.  Do you want to pass the name of the table into the stored procedure?  A different table for every page?
 
-Dell
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Aug 2011 at 3:44am
Do you want to pass a table to the procedure, or just the name as hilfy asked?
 
if you want the procedure to be run every time you change the page, you are looking at a subreport as CR only 'fetches' the data once per report (subreport are called repeatedly and so the data is fetched each time)
 
if you are fetching large amounts of data for each subreport and you have a lot of pages to your report, your report is going to run really slow.
 
a better solution (i would think) is to create your stored proc so that you return all the data that you will need for the report all at once.  If you need 'different' data for a certain input....since you know the input, return the input and the data for it. Then have CR split up the data and create the pages, so that it 'looks' like it is going out to database repeatedly, but is actually only 'really' calling the stored proc 1 time.
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.