hi try creating formula depending on language selection from the paramter
ex:
@French
if
{?Language} = 'French'
then 'Bonjour'
else
'Good morning'
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
hi
would be better if you can create a view to limit the record return
simply import in the view the record field you need for your report
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
Hi
Try saving your report first then close it and close crystal report app
then reopen it and see
sometime crystal does not refresh the changes made on a report and will run older version
try and see
PS clear your temp folder on your local drive to remove old crw temp file before opening crystal...
Hi All
cr 9.0
ms sql
i have a cross tab
i created a group base on trade_class and order by S and R and i need to get grand total at bottom of report footer
i have a formula that breaks it down by trade_class
here is my formula
---------------------------
@RorS
if...
got it gigure out
used kens formila and modified it to work
thanks Ken was worth the money to get your books
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
Hi folks
ms sql
cr 9.0
I have these date and would like to pass them to my variable
-------------------------------------------------------
New Year's Day Monday, January 1 this does not change
------------------------------------------------
Martin Luther King, Jr. Day Monday, January 15...
hi
check the report option and check convert to null
so null int is 0
string null is ""
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
Hi
you can look at these thread for more help
http://www.tek-tips.com/search.cfm?searchstring=suppress%20main%20report%20based%20on%20subreport&action=search&CFID=22774335&CFTOKEN=11398722
cheers
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
Hi All
Cr 9.0
ms sql
I have a formula that calculated the average
here are my formula
--------------------------------
@Daily_Red
if {TRANSACTION_HISTORY.POSTING_DATE} <={?End_Date}
and
{TRANSACTION_HISTORY.TRADE_CLASS} = "R"
then
round({TRANSACTION_HISTORY.GROSS_AMOUNT})
else
0...
Hi All.
cr 9.0
ms sql
I used Ken formula for the Holiday
here is what it looks like
BeforeReadingRecords;
DateVar Array Holidays := [
Date (2007,1,1),
Date (2007,1,15),
Date (2007,2,19),
Date (2007,4,6), //changing
Date (2007,5,28), //changing
Date (2007,7,4),
Date (2007,9,3), //changing
Date...
Hi All
I check Ken formula and modified it
not sure if this is right way.
Mayby someone can check and see if i'm on the right track
-----------------------------------------------------------
The number of "Work Days" between two dates:
Calculating the number of calendar days between two dates...
hi
in your home page create a table and drop each report in it's cell
<Table>
<tr> your first report
<\tr>
<tr> second report
<\tr>
<\table>
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
ops forgot
all has to be from the {?End-date} paramter the user select
Thanks
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
Hi Folks
ms sql
cr 9.0
i have a report that has a {?End-date} that i used as my parameter.
i need some help on how to calculated Sales Daily YTD Avg
keeping in mind they want working days with are monday to friday and holidays.
my date field is
{Transaction_History.Posting_Date}
to calculated...
hi All
cr 9.0
ms sql
i have this report that contains 2 subreports
1. i have these amount
sub report 1YTD sub report 2 Rep_Count
1062875/5294
1019197/4397
556346/4080
1123620/3837
409887/2801
3211420/1916
523793/2512
410306/2956
264899/2051
395437/3988
70871/1790
68954/2511
i'm dividing YTD by...
hi
Yes i did and found how to create a share var
but i found that my branch id is a varchar so i cant sum only count
Durango122
if it moves and should not used Duck Tape
if does not move and should used WD-40
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.