Question

Crystal report command Apps 7

  • 13 November 2020
  • 4 replies
  • 116 views
C
Rank
Userlevel 4
Badge +9

Hi 

I was just wondering if the below was possible. 

We have a report which is built using a commend. The command contains the rep view and 2 other views.

When we preview the report in IFS or crystal it is extremely slow and can take nearly an hour to run. We have a parameter called IFS_RESULT_KEY which is in the main report. If I create the parameter in the command the report runs instantly in Crystal but prompts for the IFS_RESULT_KEY when ran in IFS. I was just wondering if anyone has managed to resolve this issue? 

Regards

Gary 

4 replies

R
Rank
Userlevel 7
Badge +18

@crpgaryw 

Hi

A couple of questions:

  1. Is the IFS_RESULT_KEY set a a number?

     

  2. Have you set the filter e.g.

Regards

 

John

C
Rank
Userlevel 4
Badge +9

Hi John,

 

yes that is correct.

regards

 

gary

R
Rank
Userlevel 7
Badge +18

The report will prompt for the IFS_RESULT_KEY in Crystal but will not prompt for this parameter in IFS so long as you have added the filter correctly.

If still not working would you kindly provide a screen shot of your filter. 

John

R
Rank
Userlevel 7
Badge +18

Gary

Have you used this type command for Operational Reports before and did they work.

I usually don't go down the commands route, I usually add the REP views.

Just curious. 

John

Reply


Terms & ConditionsCookie settings