Recent content by catbebe

This formula is working and returned with correct value =SUMIF(RAW!C:C,5,RAW!D:D) However, I have another criteria would like to add in, which is: (RAW!O:O="2B4AE01W") I tried both below but not working =SUM(OR(RAW!C:C=5),(RAW!O:O="2B4AE01W"),(RAW!D:D)) and...

My dear, would like to clarify something first before really do a test on your query:- Are you connecting your data using OLAP features? Which and which backend are u using?

Hi, I have this problem before. I create a parameter field and apply in main report. Then create the same parameter field and apply in sub report. The value of Sub-report's parameter referring to the value of main report. I am sorry that I am on leave and I do not have Crystal REport install...

Downloand the Microsoft Repoting Service trial at www.microsoft.com/sql try it then only decide. The REporting Service might be good tool for you.

I come across this problem. What I did was to import to outlook express first, then only "import address book from outlook express" at Microsoft Outlook. I do not know whether this is the only way, but it works.

The Solution: After you had embeded the object as a word document, right click the word icon, select "Action Setting"->at "mouse Click" tab, check "object action" radio button, select "open" at the drop down list, then click "OK". Now, click power point slide show and try to click the word...

Not sure what is the expression of your chart. You mean Total Number of People in a Dept or the Employee's Number?

The solution is to make your Microsoft Outlook a default e-mailing program. 1) First, open your outook Express-->Tools-> Option-> general, at bottom, check whether the "make Default" button" for "This program is the default e-mail handler" is on. ** Just check but do nothing because because...

Hi, the solution is: 1)At Task, right click on the "subject" panel, select "customize current view" -> select "automatic formatting" 2) Click "Add", point your cursor to "untitled" and click "condition" too set the rule 3) click "advanced"--> "field" --> select "Date Time field" --> "Reminder...

I am trying to edir the Statement but in Crystal Report version 9 Professional, I can only find the SQL statement by clicking Database->Show SQL. I can not see any key the enable me to edit the statement. Any Idea?

I am not sure what version of Crystal Report you are using. Anyway, in version 9, there are some very useful sample reports that you can located at C:\Program\Crystal Decision\Samples\En\Reports\General Business. There are some different type of sales reports, accounting/inventory analysis...

Yes, this report is group by "specified orders". I was just tried group by "Ascending Order", resulted the same. There is no running total. I referred to the samples from "general business" folder in Crytal Report program file. Seldom have SQL statement...

The report isn't drill down, hidden details and only show groups in specify orders. The SQL statement listed below: SELECT "SAH05"."ZMCOMP", "SAH05"."BTLTYP", "SAH05"."DMITCL","SAH05"."BTITNO&quot...

Hi, I do faced this problem before. What I do is log-off current user and signed in as power user (or the Highest authority user) for the ODBC connectivity.

Hi, I am new to Crystal Report, using ver9. Connectivity via ODBC to AS400/DB2. Sometimes, it take me few hours to generate a Sales Report. However, the result is correct all the way. The "Perform grouping on server" tab is turned on. Question: Is it a normal nature or I miss out...