HELP! Crystal Reports 10 (CR10) crashes when I try to save

I have a report that that uses 4 sub reports to display data from an oracle database.  The main report pulls primarily static data from a table.  It also uses links to pass parameters for the main report to the sub reports.  The subreports use a command to pull specific data from a table.  The sub report query uses 2 parmeters {?uname} & {?dvalues}.  {?uname} is used 4 time in the query and {?dvalues} is used once.  I am able to get one instance of the uname parameter in the query and saved without any problems.  When I add another parameter instance, either uname or dvalues, CR10 crashes when I try to save the change.  By crash I mean the application closes completely.  On those times that it does not close it locks in a working state and uses 50% CPU and memory allocation.

I have checked the query and it pulls the data in less than .3 seconds from SQLPlus.
I have tried:
1) Removing all but 1 sub report and only work with that. - no dice
2) Speciying a unique parameter for each parameter instance that is used. - no dice
3) Removing parameter link, or adding parameter links - no dice

I am working on a win2k development server with 2GB of ram. No other person or services uses this server.
I have been working with Crystal reports for over 5 years and have never run into a situation like this.
I have checked the event log on the server and it show absolutly nothing.
rceballosAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

gopatincCommented:
could you post the subreport query with the {?uname} being used 4 times? It seems there is some error when you insert the parameter multiple times.

Did you try using static values to check if the query is accepted?
Then start giving 1 {?uname} in the query (I believe this already works)
Then move this parameter to the 2nd location, then 3rd and finally 4th
See if it fails in any position.
0
rceballosAuthor Commented:
Below is the code that I am using. I have changed the names of the tables and fields but the process is exact.
uname is an upper case user name (string type).
dvalues is a siingle string value with multiple values seperated by comas (split out later) that can have from 1 to an unlimited amount of values (string type).

I already tried putting the values in manually and it does work fine. Even when I put in one parameter is still saves and populates data ok. It is when I add an additional parameter, not neccissarily the same one, does crystal crash.


select USR_NM,
SEQ_NBR,
SORT_NBR,
ACTUL_AMT,
ACTUL_PCT
 from reports1
 where usr_nm = '{?uname}'
   and sort_nbr in ({?dvalues})
UNION
select USR_NM,
SEQ_NBR,
99,
GRND_AMT,
Round(((SELECT DISTINCT GRND_AMT/
     (SELECT DISTINCT GRND_AMT
        FROM reports1_grand_view
           WHERE GRP_NBR = 4080
                AND usr_nm ='{?uname}')
  FROM reports1_grand_view b
     WHERE usr_nm = '{?uname}'
        AND a.grp_nbr = b.grp_nbr)*-100),2) GRND_PCT
 from reports1_grand_view a
 where usr_nm = '{?uname}'
0
gopatincCommented:
You mentioned 'when I add an additional parameter'
Do you mean a second paramter? or the same parameter being used in multiple places?

In other words, does you report save with only {?uname} being used in all 4 places?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

rceballosAuthor Commented:
It does not matter what the name of the parameter is. It will crash the same. I have tried same and different names, also I have tried different parameter types.
0
mlmccCommented:
How are you adding the parameter?

Are you trying to change the SQL inside Crystal?

mlmcc
0
mlmccCommented:
If you don't make any changes can you do a SAVE AS?

If you make a minor change move a field, can you save the report?

mlmcc
0
rceballosAuthor Commented:
It doesn't matter what parameter or where I put the parameter. If I have 1 parameter in the query it works fine and I can save all day. If I add another parameter to the query, anywhere in the query, crystal crashes when I either save or save as.
0
rceballosAuthor Commented:
I installed SP4 for Crystal 10. This corrected the problem.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rceballosAuthor Commented:
Please close, thank you
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.