[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 850
  • Last Modified:

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.
0
rceballos
Asked:
rceballos
  • 5
  • 2
  • 2
1 Solution
 
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
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
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
 
rceballosAuthor Commented:
Please close, thank you
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

  • 5
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now