Search results for query: *

Fields are empty, you mean NULL in this case. If it is so, you can replace NULL with 0 so that when you add up these you get correct summary. You can use REPLACE, ISNULL functions to replace blank space to 0 (As these take string values only, use ToText and then ToNumber conversions)

Hi , ColumnA ColumnB A 15 B 45 C 35 D 75 E 55 I need to get Column A based on Max and Min Value of Column B Here: I need to get the answer as D and A I could do this using formula or running totals but these only display in either...

I could solve this problem finally.

Hi , I am trying to run few on-demand reports in CMC, but I get this error after I enter the parameter values The database logon information for this report is either incomplete or incorrect. This problem occured recently when I changed my Datasource location from one database to other. The...

I could see both the summaries in my drop down list but can add only 1 to it at once(not both) anyways I made it by adding "order by" clause in the sql command, I was wondering can I do it in Group Sort Expert.

but I could not find second level of sorting in Group Sort Expert. I could add only one summary field to it...

Hi, I have a group name which should be sorted by 2 fields - COUNT and AMOUNT. This is because the field COUNT has ties (same number for different groups) GROUP_NM COUNT AMOUNT 1 9 20 2 4 10 3 4 50 4 4...