Solved

promptex not working for my report

Posted on 2006-07-05
7
424 Views
Last Modified: 2012-06-21
I am having a problem passing arguments to my report. This is basically the link that is being used:
http://crs99/test/viewrpt.cwr?id=487811&init=actx:connect&apsauthtype=secWindowsNT&promptex-parWorkPackage_ID='5399'&promptex-parStartDate='06/01/2006'&promptex-parEndDate='10/07/2006'

Note that all 3 of the parameters are created in the report and parStartDate and parEndDate are Date values. The problem is it is still prompting me for the parameters when I run it.  What am I doing wrong? Thanks in advance.
0
Comment
Question by:mathew_s
  • 4
  • 3
7 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 17045537
Try promptex-0=5399&promptex-1=....etc...
0
 
LVL 1

Author Comment

by:mathew_s
ID: 17045693
It still asks me to provide a value for parStartDate then parEndDate and finally parWorkPackage_ID. Is there something I have to do with the parameters in the report?
0
 
LVL 42

Expert Comment

by:frodoman
ID: 17045734
It's been quite a while since I've passed anything in a URL but if I remember correctly I never did get dates to work as dates.  I had to use text-type parameters in Crystal and pass the date as text and then within Crystal convert from text to a date.  You might want to give that a try.

Also, what is the datatype for package ID parameter in Crystal?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
LVL 1

Author Comment

by:mathew_s
ID: 17045756
parWorkPackage_ID is a number. I will try what you suggest...
0
 
LVL 1

Author Comment

by:mathew_s
ID: 17045938
OK. I changed my date parameters to string parameters and changed my selection formula. Now I get the following error.

------------------
Error in formula <Record Selection>/
'({parWorkPackage_ID}={T_Proposals.WorkPackage_ID}) and
'

Bad date format string.

-------------------
T_Proposals.WorkPackage_ID is an integer in the database.

This is the url I am using now:

http://crs99/test/viewrpt.cwr?id=491529&init=actx:connect&apsauthtype=secWindowsNT&promptex-parWorkPackage_ID=5399&promptex-parStartDate='06/01/2006'&promptex-parEndDate='10/07/2006'

Here is the selection formula:

({?parWorkPackage_ID} = {T_Proposals.WorkPackage_ID}) and
({ACR_Tasks_0607.proposed_start_date}>=CDate({?parStartDate}) and {ACR_Tasks_0607.proposed_start_date}<=CDate({?parEndDate})) OR
({ACR_Tasks_0607.proposed_end_date}>=CDate({?parStartDate}) and {ACR_Tasks_0607.proposed_end_date}>=CDate({?parEndDate}))
0
 
LVL 42

Accepted Solution

by:
frodoman earned 50 total points
ID: 17046031
I would try it without the single quotes:  promptex-parStartDate=06/01/2006&promptex...

I believe everything in the URL is treated as text automatically so your Crystal formula is probably trying to do a CDate conversion including the quote marks.
0
 
LVL 1

Author Comment

by:mathew_s
ID: 17046101
Thank you!
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

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. …
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…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

839 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