Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Change the Paremeters Post Reply Post New Topic
Author Message
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Topic: Change the Paremeters
    Posted: 24 Jan 2013 at 1:50am
Hello everybody,
 
I have a question to ask the expert, I am trying to modified the existing A/P reports and the report itself it genereate by the INVIOCE DATE. How can I edit the parameter to make the report gerenrate by the INVIOCE DUE DATE instead?
 
 
Please help,
 
GuyCry
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 28 Jan 2013 at 6:05am
You won't change the parameter itself.  Instead, go to the Select Expert and change the date field from Invoice Date to Invoice Due Date.
 
-Dell
IP IP Logged
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Posted: 29 Jan 2013 at 1:41am
I added the select expert and add the invoice due date as one of the selection but still didnt work.
 
this is how my report looks like at the moment
Inv #    Inv Date      Inv Due       Amount        Current    30-60    60 -90
123       Oct 31, 12     Dec 15,12    5.00                                         5.00
 
This how I would like it to looks like:
Inv #    Inv Date      Inv Due      Amount        Current     30-60     60-90
123       Oct 31,12      Dec 15, 12    5.00                            5.00
 
Because all of the values are coming from 4 buckett, Amount, Current, 30-60, and 60-90 days. I dont know how to do this?
 
Help please !!!!
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 29 Jan 2013 at 3:00am
Are the values for Current, 30-60, and 60-90 database fields or are they formulas?  If they're formulas, you'll need to edit them to base the calculation off of the correct date.
 
-Dell
IP IP Logged
guy723
Newbie
Newbie


Joined: 16 Jan 2013
Location: Canada
Online Status: Offline
Posts: 16
Quote guy723 Replybullet Posted: 29 Jan 2013 at 3:22am
They are not formulas they are a column from Pervasive table
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.