Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

promptex not working for my report

Posted on 2006-07-05
7
Medium Priority
?
428 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
[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
  • 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 200 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
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…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

609 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