Solved

Reorder of Parameter fields not staying

Posted on 2004-09-06
5
481 Views
Last Modified: 2008-03-06
Goal: to reorder the parameter fields in my report

My actions:

1) Open report in design view
2) Open Field Explorer
3) Expand Parameter fields
4) Move some fields around using the up and down arrows at the top of the Field Explorer window
5) click Close to close the Field Explorer
6) Save Report

Result:

I open back up the report and go to field explorer only to find that the fields go back to where they were and my rearranging never stays

Why?
0
Comment
Question by:dba123
  • 2
  • 2
5 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 11992810
What version of Crystal?

I have CR7.  When I reorder the parameters the order stays.

What is your purpose in rearranging the order?

mlmcc
0
 
LVL 26

Accepted Solution

by:
Kurt Reinhardt earned 500 total points
ID: 11992888
In order to change the order of the procedure parameters, you may need to change their order in the procedure (and then do a verify database to reflect changes made to the procedure).

Here are some KB articles from Business Objects on the subject:

http://support.businessobjects.com/library/kbase/articles/c2012508.asp

http://support.businessobjects.com/library/kbase/articles/c2009410.asp

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 11993077
So true, rhinok.  I was looking at parameters being added in Crystal but if they are stored procedure parameters then you must change the order in the stored procedure.

mlmcc
0
 
LVL 1

Author Comment

by:dba123
ID: 12002492
there are only 2 parameters in the stored procedure signified with @ and they are @startdate and @neddate.

So all the other parameters in Crystal are without the @...so then there is no way to do this
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 12002578
Unfortunately, dba123, there are so many factors here that its tough to tell what would work.  You have asp passing multiple parameters to Crystal.  Two of the parameters are from the stored proc, the rest are Crystal Reports Parameters.  Theoretically, you could just reorder the parameters in Crystal and save the report, but this is clearly not working.  I wish I had a better solution for you :-(
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Next Full Week 4 75
Speed Up Crystal Report 5 47
Installation package ASP.NET with Crystal Reports version 13 12 54
Crystal Formula to "conditionally count/sum" 3 38
Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

930 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now