Your full service technology partner! 
-Collapse +Expand
Search Paradox Group:

-Collapse +Expand Paradox To/From
-Collapse +Expand Paradox Store

Prestwood eMagazine

May Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Reports Topic   Print This     

Passing Variables to Report

Passing Variables to Report in Paradox Reports topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Passing   Variables   Passing Variables   Passing Variables Report  
Addison, IL USA

I have a form which runs a query to select data within a specfied date range.  The form then opens a report based on the queried data.  Can I pass the start and end dates to the report in such a way as to display this range on the report?

 Posted 13 years ago (Thread Starter)
Comment Quote
About MikeWA -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12231, 3 replies
Thread Started 10/23/2007 2:29:49 PM
View Counter=3680
Last Reply Posted 12/27/2017 10:47:13 PM)
Location=Addison, IL USA 
Joined=13 years ago   MB Posts=12  
Daniel Fought
Prestwood IT
Home office in Fresno, CA.
There are a couple a methods you can use to do this.  You can save the information to an environment variable and then read in into a calculated field.  You could also create a simple one record table to store the data and then attach a field to the table.  You can also open the report in design mode and update a field on the report with the data. 

Dan Fought
Senior Programmer Analyst
Prestwood IT Solutions

 Posted 13 years ago
Comment Quote
About Daniel Fought -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.
About Daniel Fought
Danial Fought is a senior programmer analyst with Prestwood IT where he develops custom Windows software and custom websites. When Dan is not coding for clients, he participates in this online community. Coding specialties include Paradox/ObjectPAL, MS Access, Visual Basic, and VS.Net/VB.Net.

Post ID #12232 (Level 1.1)  Reply to 12231
Thread Started 10/23/2007 2:35:43 PM
View Counter=2
Location=Home office in Fresno, CA. 
Joined=18 years ago   MB Posts=401   KB Posts=12   KB Comments=4  
-- USA
As with the environment variable, you could use write/read profile string. The advantage of each is environment - no trace of the info you are passing. profile - a record in an .ini file you can look back on. These are also disadvantages, depending on what you are looking for.
 Posted 13 years ago
Comment Quote
About chomp -Collapse +Expand
Visit Profile
Inactive member.
Member does not subscribe to this thread.
Old Account!
If this is your account, sign in to activate web presence data (sign in quarterly to keep active). Alternatively, you can subscribe to our monthly eMag with a valid email address.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #12234 (Level 1.2)  Reply to 12231
Reply Posted 10/23/2007 4:06:38 PM
Location=-- USA 
Joined=13 years ago   MB Posts=45  
Most Recent Post
Addison, IL USA
You guys are more advanced programmers than I am!  I was trying to generate a quality control report for my manufacturing facility that generated information only for a user specified date range and have that date range shown on the report.  I ended up generating 2 additional fields (Start & End) with my query (calc startdate as Start, calc enddate as End).  This generates a lot of redundant information but was easy to reference from my report by just selecting the first occurance of each.
 Posted 13 years ago (Thread Starter)
Comment Quote
About MikeWA -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #12236 (Level 1.3)  Reply to 12231
Reply Posted 10/23/2007 4:12:23 PM
Location=Addison, IL USA 
Joined=13 years ago   MB Posts=12  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.

Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1307A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #12231 Counter
Since 4/2/2008


Linked Knowledge Base Article.

This thread is linked to the following KB article.

Mike Prestwood
1. Power: Chapter 12, Handling Reports

Chapter 12, "Handling Reports" from Paradox 9 Power Programming by Mike Prestwood.

Posted to KB Topic: P9 Book: Power Programming
17 years ago, and updated 11 years ago

KB Post
Nothing New Since Your Last Visit

Corel Paradox / ObjectPAL Coding

Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site:

©1995-2020 Prestwood IT Solutions.   [Security & Privacy]