Search results for query: *

Is it possible to determine the length of a memo field? I don't need to display the field itself, only determine the number of characters it contains. I'm using CR10 with a SQL server.

LBass - Thanks! That's exactly what I needed, and very thorough. I have a couple of questions so I better understand this and can apply it to other uses. Where you used "000" as in if not(totext({table.user},"000") I was getting an error message "Too many arguments have been given to this...

Thanks for the responses. The rank value is calculated by the report itself and that is what I'm having trouble generating. I used a formula I found in another thread to generate the YTD rank, but it works off of a TopN and the order of the list. There is only 1 MTD value, but I need to be...

The workaround I've used for this is to print the field in the Tool Tip section and not on the report. It requires the user to mouseover the field to see it, so it's not as convenient as you're asking, but it will prevent it from being printed on the report. Right click on the field, format...

I'm using CR10 with SQL server. I have a report that correctly ranks YTD performance. I also need it to rank MTD performance. Example: USER MTD RANK YTD RANK 111 4 1 021 1 2 303 3 3 ... etc I need the report listed in order by YTD rank. I tried a...

I've inherited some code that doesn't work properly. There are two functions involved in the problem. The first one calls the second one with this code: for (var x = 1; x <= document.all.maxBehavioralID.value; x++) ResetRadioSelection(x); The next function is: function...

I've inherited some code that doesn't work properly. There are two functions involved in the problem. The first one calls the second one with this code: for (var x = 1; x <= document.all.maxBehavioralID.value; x++) ResetRadioSelection(x); The next function is: function...

There is a function called running total. You'll find it in the Field Explorer. Right click on "Running Total Fields" and click on NEW. A box opens up that takes you right through what you need. Make a name for your total, choose the field you're summarizing, make the type of summary SUM...

lbass - That's exactly what I needed. Thank you.

I have been writing Crystal for a while now, but this is my first Cross Tab, so I'm hoping my question is easy. I'm using v10 and SQL I created a cross tab that has a count by location by period by year: location feb'05 feb'04 mar'05 mar'04 .... etc. two 1 0 2...

The first thing I would check is if the type of field is different in the subreports. For example, if you have a DATETIME field in the main report and the subreports are DATE fields, they won't match. In the past when I've had this happen, I've created a formula to change the type of field to...

Redsand... I was having the same problem, with no solution for months (mind you, I hadn't asked the experts here). The difference in my problem is that I was to use graphics (red octagon, yellow triangle, green circle). I had the jpg's, but was not sure how to implement. It came to me last...

I'm working with version 7 (I know - upgrade... it's in the works) and SQL I have two tables: vIncidents vWeek I work on Fiscal periods / weeks, and the vWeek table references fiscal period and week numbers to ease reporting. My problem is joining these two tables. Dates are the only thing...

I believe you just need to add a ( after isnull as in this example: if isnull({LOAN_STATUS_CD.loan_status_dsc}) then 0 else if {LOAN_STATUS_CD.loan_status_dsc}= "cancelled/Denied" then {LOAN_APPLICATION.loan_amt} else 0