Fixed Account Numbers
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10390
Printed Date: 04 May 2024 at 4:58pm
Topic: Fixed Account Numbers
Posted By: crist
Subject: Fixed Account Numbers
Date Posted: 29 Jun 2010 at 7:50pm
|
Dear Expert,
I am really new with CR.
I created a report with cross tab and with detail report below my cross tab.
My columns in crosstab are in specified orders, meaning each columns are composed of different ranges of account number.-- This okay already.
But - Further on, my detail report of my crosstab will be using the same account number as my cross tab report.
i created a parameter of this account numbers specified in my cross tab and used select expert to select this accounts numbers.
But when i print view, it prompts to select the range of account numbers.
I do not want this screen to select the range of account number, because these are fixed range of account number in my cross tab.
i want to be fixed also in my details - no need to select range of account number. How to do that way?
please help me. thanks...
|
Replies:
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 8:22pm
|
you should create a formula NOT parameter.
that is why CR prompt you to select a range.
hope it help.
------------- Emir W |
Posted By: crist
Date Posted: 29 Jun 2010 at 8:29pm
|
can you please advise to create a formula for that?
i have 87 account numbers.
thanks
|
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 8:44pm
|
how you define the range of account field for columns (as you said '...each columns are composed of different ranges of account number...')?
is it printing for all your accounts? or is there any specific range (e.g.:account category, etc.)?
------------- Emir W |
Posted By: crist
Date Posted: 29 Jun 2010 at 9:08pm
|
this is the sample formula i did for range of account numbers:
i named this formula as (account number)
{accountnumber}="806101 to 806981" and
{accountnumber}="806B01 to 806F01" and {accountnumber}="805001 to 805701" and {accountnumber}="807001 to 807601" and {accountnumber}="808501 to 808799" and {accountnumber}="808811 to 808819" after this formula, i go to select expert to select the formula name, right?
what do i need to select?
-is any value,
-is true
-is false
-formula
i tried to select formula and auto select the {?account number}.. Now my report shows nothing....
 please help
|
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 10:11pm
|
formula for column (acc-col): and you can put which field for the detail in cross-tab. till here try to preview it.
then create a parameter to restrict which data you want to be printed.
- from Field Explorer
- right click 'Parameter Fields'
- click 'New' and put any name for the parameter (xyz)
from here you can see all the options.
then create 'Select Expert'
- click 'Report' menu
- select 'Selection Formulas' - 'Record'
- and put the parameter that you just create
e.g.: {xyz?}={tbl.accno}
till here it will print only data for what you enter in parameter.
let see what you've got.
------------- Emir W |
Posted By: crist
Date Posted: 29 Jun 2010 at 10:43pm
|
dear emir,
i did your instruction but CR prompted me the parameter to select the account number.
I do not want the user to select any account number because these account numbers are fixed in this report. this is my intention.
|
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 10:49pm
|
in this case, remove the parameters in order for CR not to prompt any parameter.
------------- Emir W |
Posted By: crist
Date Posted: 29 Jun 2010 at 11:03pm
|
dear emir,
i can remove that but the account number used in my detail report is different against my crosstab.
i want all the account number used in crosstab should be used also in my detail report.
i tried to remove that parameters but the figures now is incorrect from my detail report against my crosstab report.
figures in cross tab are correct because i specified the account range per columns.
how to restrict my account number used in the cross tab should be same as my detail report? so that my figures are tally.
thanks....
|
Posted By: Emir_W
Date Posted: 29 Jun 2010 at 11:08pm
|
Crist,
can you attach a dumpscreen from your report here for us to review?
(the crosstab, etc.).
------------- Emir W |
Posted By: crist
Date Posted: 29 Jun 2010 at 11:23pm
| i will send to you tomorrow morning. thanks for your assistance.really appreciate! |