Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Stored Procedure in Crystal reports Post Reply Post New Topic
Author Message
bgovindhan
Newbie
Newbie


Joined: 14 Dec 2011
Location: United States
Online Status: Offline
Posts: 14
Quote bgovindhan Replybullet Topic: Stored Procedure in Crystal reports
     Posted: 01 May 2012 at 6:14am
Hi,
 
I have a crystal report that is using sp_rpt_cyle as one of the stored procedure. But, I want to modify the report that uses the sp_rpt_cycle2 as the stored procedure. How do I do it without losing or changeing that fields that are pointing to sp_rpt_cyle stored procedure. The columns are same between both the stored procedure.
 
Thanks.
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 01 May 2012 at 6:37am
just to be safe, make a copy of the report and work on that.
 
I believe that if you go into the Database Expert you can 'point' the report to use the second stored proc.
 
If that works, then you can try to removing the first 'original' stored proc.  If CR gives a warning that fields are in use you can try deleting.  If your report comes up blank 1) that's why we made a back up 2) you can start substituting the 'new' fields for the old.  What I tend to do is to drag the 'new' object over to report. Select the new object, hold the control key, select the old object. With my mouse over the old object, right click and make the objects the same size. Next I align the new and old (usually horizontally). Last, right click on the old object and select the option about the paintbrush. Move over the new object and click...all the formatting for the old object will be transfered to the new object.
 
now remove the old object and move the new one into place.
 
HTH
 
ps, I don't use stored procs directly from my reports, but if I change the name of the dataset that I am pushing to the report, CR will usually just accept the changes without any fuss, as long as the names of the columns are the same.  Maybe it is just a function of pushing the data instead of pulling it like you are doing.


Edited by lockwelle - 01 May 2012 at 6:38am
IP IP Logged
bgovindhan
Newbie
Newbie


Joined: 14 Dec 2011
Location: United States
Online Status: Offline
Posts: 14
Quote bgovindhan Replybullet Posted: 01 May 2012 at 6:47am
Thanks. Let me try it
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 May 2012 at 7:53am
there is another less labor intensive way.
go to the Database menu
set database location
in the upper window (report) select the report store proc name
in the lower window (replace with) drill into the location until you find the stored proc you want to use
click on update
if you expand the properties in the upper window you will see the new store proc name in the details
now open database menu, database expert
right click on the selected tables name
select rename
alter the name to match the new stored proc name here, otherwise it is easy to forget you changed it.


Edited by DBlank - 01 May 2012 at 8:20am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 01 May 2012 at 8:17am
I knew that there had to be a simpler method!
 
Actually, this is what I do...
I think that I was hoping this is what I was describing, but I think I missed.
 
I went into the laborious way in case this didn't work.
 
Can never remember off the top of my head if it Expert or Location
 
Thanks
IP IP Logged
bgovindhan
Newbie
Newbie


Joined: 14 Dec 2011
Location: United States
Online Status: Offline
Posts: 14
Quote bgovindhan Replybullet Posted: 03 May 2012 at 1:24am
Thanks and it worked as expected.
IP IP Logged
roxanne77
Newbie
Newbie
Avatar

Joined: 04 May 2012
Location: United States
Online Status: Offline
Posts: 1
Quote roxanne77 Replybullet Posted: 04 May 2012 at 6:08pm
Pandora Beads and JewelryAmid one of the most popular with the Pandora Jewellery Sale Online design firms is Pandora beads. The corporate opened in 1982 in Copenhagen, Denmark and opened a factory in Thailand several many years afterwards. Opening their own personal factory meant that they could control the styles and quality of their wholesale jewellery, that's absolutely one of the causes that Pandora CA are amid the very best good quality of this sort of Cheap Pandora Charms on present-day marketplace. As Troll beads have been invented during the 1970's, also in Denmark, the charm beads are sometimes known as "Denmark beads". This well-liked genre of jewellery turned the main focus of Pandora in 1999, and in 2000 they presented their extremely popular Pandora bracelet. The Pandora bead bracelet is undoubtedly an elegantly intended bracelet base which is created for his or her beads as well as other equally sized allure beads to simply slide on and off, in order that the bracelet is endlessly customizable. It is possible to use as numerous or as number of beads as you like, intermix them with beads from other suppliers, and change them as typically when you like. These bracelets are designed for being a constant image of what can make you, you.

Pandora beads are created from 14k gold, 18k gold and/or sterling silver. They function cherished and semi-precious stones, stylish style, and leading top quality craftsmanship. The bracelet chains are extremely modern, and element a few sections that can be accustomed to separate the beads for greater group. The Pandora necklaces are created within the exact same way. Clips can be used to carry person Cheap Pandora Bracelets in place, however the beads will nevertheless rotate together with the motion of your respective wrist. An fascinating new take on charm beads could be the Pandora earrings line. The principle is incredibly simple- a basic or ornamental ear hook that spirals in the entrance. The charm may be slipped on from the ear hook again and slid to the bottom of the front hoop. The influence is stylish, easy, and infinitely customizable. Many charms can be utilized using the ear hooks even if they're acquired by way of a rival company or even a jewelry offer catalog. Denmark beads are not the one jewellery currently made by the Pandora organization. Their new line referred to as LovePods attributes basic jewellery layout in 18k gold and valuable and semi-precious gems. The Liquid Silver line is clean and elegant, and developed to be nearly as changeable as the allure beads. There is also a line of matching jewelry and blend and match jewellery.
Cheap Pandora Rings is actually a leading notch jewelry organization whether your style runs for the easy LovePods or the changeable Pandora beads.

_____________________________________________________________________________________________
Believe that all
IP IP Logged
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