Change the Paremeters
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=18872
Printed Date: 01 May 2024 at 3:40pm
Topic: Change the Paremeters
Posted By: guy723
Subject: Change the Paremeters
Date 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,
Guy
 |
Replies:
Posted By: hilfy
Date 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 ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |
Posted By: guy723
Date 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 !!!!
|
Posted By: hilfy
Date 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 ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |
Posted By: guy723
Date Posted: 29 Jan 2013 at 3:22am
| They are not formulas they are a column from Pervasive table |