Recent content by teknogeek9

MS SQL SERVER 2005 CR XI R2 I have an RTF field that is an (image,null) field in the database. I am able to display the contents of the field in CR using the following SQL Expression: //%Notes {fn substring(BEHOLD_Tasks.TASK_RTF_NOTES,0,100000000)} This field displays in hexdecimal. Is there...

CR XI here.... I have a crosstab report that displays the number of referrals by referral source, by month. Jan Feb Mar Apr Total Referral A 10 10 10 10 40 Referral B 9 9 9 9 36 Referral C 8 8 8 8 32...

Wish there was a way to delete a post.... lbass' solution works very well. I had a group suppression on for the Weekly value. Thank you lbass

The monthly version totals correctly; the weekly does not total at all. There is a parentheses missing so I added it to the end. I showed the formula on the detail line to see what it was returning and it returns the week begin date. Yet, it won't total by that group.

Multiple weeks/months. The data spans at least a year.

The problem with doing that is with the month being group 1 and week being group 2, the week will stop at the end of the month. And that may not necessarily be an end of the week.

Using CR XI, is there a function that allows for dynamic control of "This section will be printed"? The users want to be able to print the report with totals by week or totals by month. They will get one or the other but not both. I have a report that has a detail section of daily...

Couldn't you use a sub-report?

You might want to use IF/THEN to check to determine which parameter to use.

How can you not have a record selection? Your IF statement is a condition for one. After all, you are testing before doing something with {CURRENT_JCT_TRANSACTION.Amount}. Having said that, have you disabled the suppression and then test the revised IF statement?

I think you will find what you are looking for on Ken Hamady's website. Here is the link... http://kenhamady.com/form01.html

I suspect you have the closed parentheses in the wrong place. Try... IF({CURRENT_JCT_TRANSACTION.Transaction_Type} = "Aprvd schdl val chng" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Scheduled value" or {CURRENT_JCT_TRANSACTION.Transaction_Type} = "Pndng schd val chg 2") and...

The IF/THEN clause is only working on RCyrtot := RCyrtot + Sum ({@Revised Contract Amt}, {CURRENT_JCT_TRANSACTION.Job}); Try this... Numbervar Amount; Numbervar RCyrtot; Numbervar RCgrtot; if not({@YTD Costs Recognized} = 0 and {@YTD Revenue Earned} = 0 and {@Over-Billing} = 0 and...

You can execute SQL commands against the Progress database. Is that what you mean?

Do your inner joins first and then your left outer joins. In Crystal, under Database Expert, click on order links and then drop the outer joins to the bottom.