Solved

Crystal Reports Prompt is not popping up within Sage

Posted on 2014-04-11
9
637 Views
Last Modified: 2014-05-01
Hey guys,
So every now and again I will make a report as i always do and my prompts will not show when the report is run within Sage(but they do when its run in crystal).

In the past I have just made new parameters and it worked this time no dice.

any thoughts will be greatly appreciated.
0
Comment
Question by:mikeg95
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39994433
Does the report run?

WHat happens if you refresh the report?

I assume you put the parameters in the report somewhere like the selection filter.

mlmcc
0
 

Author Comment

by:mikeg95
ID: 39994442
yes i put the parameters in the Selection expert and when you refresh the report in Crystal it requests the parameters but when you run in Sage it runs the report with the last used parameter from crystal without prompting  if that makes sense
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39994463
When viewing from Sage can you refresh?  Does it prompt then?

What version of Crystal?

mlmcc
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:mikeg95
ID: 39994494
i am using Crystal reports XI release 2 for sage, and when i am in sage and run the report I do not see a refresh option.
This is the Selection expert code
 
{WRKORDER.QPM} = "Y" and
{WRKORDER.SCHEDDATE} = {?Date} and
{WRKORDER.ARCUST} = {?CustomerID} and
{TIMESTMP.STATUS} = 70

Open in new window

0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39994698
I am not familiar with the Sage Interface.

DO you enter values in the interface before clicking to run the report?

Does it pick up the values based on a selected record?

When a report is loaded to Sage, is there an option to turn parameter prompting on?

mlmcc
0
 

Author Comment

by:mikeg95
ID: 39994712
I have several dozen reports running in sage that are built in crystal I believe this is a bug in the version of crystal i am using.

When in Sage you choose the report you want to run from a drop down. the report runs and if their are any prompts built into the selection expert then it will pop up and request them. there is no interface to turn on or off the parameter prompting. either the report has a prompt or it doesnt.

the problem is that instead of it running the report fresh and asking for parameters it is running the preview that i have in my report. any parameter I chose in Crystal report while designing it is the sage data it passes to sage. its very odd and happens very seldom
0
 

Accepted Solution

by:
mikeg95 earned 0 total points
ID: 39994721
I just closed the preview then saved the RPT and it worked... that was odd
0
 
LVL 35

Expert Comment

by:James0628
ID: 39995940
I'm not familiar with Sage, so this is really a shot in the dark, but when you open that report in CR and look under File, is "Save data with report" checked?  If so, then I would guess that Sage is just using the saved data, so it doesn't ask for parameter values.  And, in that scenario, I would guess that when you closed the Preview window, you also removed the saved data, so Sage had to use the parameters to get new data.

 I've never used saved data with reports, so I'm just guessing that closing the Preview might remove the saved data.

 James
0
 

Author Closing Comment

by:mikeg95
ID: 40034108
there was nothing wrong only the preview needed to be closed before saving
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

726 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