Search results for query: *

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.

Here is my two cents worth. My biggest and greatest pet peeve is if you have a subreport and you have to return values from it via a variable, the subreport must be in a section of the main report and that section cannot be hidden or supressed. The best one can do is hide in the subreport...

Crystal has a function called split. Something like below should work for you. stringvar Lcode1 := split(LCODE[1-5],',')[1]; stringvar Lcode2 := split(LCODE[1-5],',')[2]; stringvar Lcode3 := split(LCODE[1-5],',')[3]; stringvar Lcode4 := split(LCODE[1-5],',')[4]; stringvar Lcode5 :=...

Yes, the 10/1 and 10/27 records will be included. If you want to confirm this, view the SQL statement.

What version of Crystal are you using? I find that mine crashes when I have a sub-report that is fetching records and I try to do something to the format like click on a result or resize a field.

Is a table with a varchar field size of 1000 bigger than a table with a varchar field size of 500? Or, is the size of the table defined by the actual amount of data in the varchar field?