Search results for query: *

Could anyone tell me if I can use macro substitution in dex.? I am working on something in Payroll. All the field name I need to work on are 1 - 12. I try to avoid typing all the fields from 1 to 12. Is it a way I can avoid to "hard code" them?? thank you. sherry

Hello, I am getting an error code 59 from SQL_Execute(). The SQL statement works fine if I run the statement from SQL analyzer. Could anyone let me know where could I find the complete list of the return codes for SQL_Exceute function? Thank you. Sherry

lbass, Like you suggested, I used inserted total. It still tells me that this field cannot be summarized.. The data would be ordered by sale persons' name. Thanks sherry

this is what we would like the report will look name booking rank John 200 4 San 500 3 Lisa 1,000 2 Sherry 5,000 1 thank you. sherry

I found the following code which should be very useful. This is what I am doing to : 1) I created a field {#RTotalBookbyRep}in the running total to summarize the total booking for each sale person. 2) total count of the sales. 3) I created RepRanking and formular is : Local NumberVar i...

Hi, thank you for your reply. I am using version 9. I could not find anything TopN. I have Nth largest and Nth smallest. Sherry

Hello, I am doing a report that I have to rank all the sales people based on their sales for the month. Is there a funtion I can use from CR? thank you. Sherry

It suppose to be ms sql from ms crm. I don't know what kind of connection that was. That is what I am trying to find out(This is my first week working with ms crm and crystal report). Yes, I am having a lot of fun.

I already tried that it does not work. sherry

Yes, all other fields are returned correctly for each record. No contact information displayed for all the records. sherry

Thank you for helping me out.. there are 2 tables are used in this report. This field could be null but the problem is there is not data show up at all for this field in this report. Sherry

Hello, First of all, I am so happy to find this forum. I just started to work with ms crm a week ago. I am trying to understand the data structure of the application. I am working on a couple of reports that involve data from opportunity table, account, competitor and so on. I found the...

yes, here is the extra information: crystal 9.0. Yes, I see the data display when I do the right click and browse data. I am not doing any surpressing or formatting the field. it is a string field that contains all the contact names. Thank you. sherry

Hello, I have one string field in my report. The data is there but the data does not show up in the report. Does anyone know why and what to do to display the data ?? thank you. sherry

Thank very much for the replies. I am new to Crystal Report and to application (MS CRM). Everything works when I created a new sql connection. Thank you again.

this is my first time using the crystal report 9. I am testing out the sql command function. I have working with ms sql for a while. simple command: select account.accountid from account where stagecode > 0 must be some kind of syntax error. Could anyone help?? sherry