Search results for query: *

Hi Malcolm, Again I am coming to u to get resolved a doubt.. In selection formula or Formula Fields if i compare the date with some hard coded value or selected text box value which i am passing through VB it is giving "Error in formula".Please give me the answer to this...

Thanks very much Malcolm! I will try and get back to you. Thanks once again.

Hi Malcolm, I need to write a SQL statement in CR. I will be getting all values for different order numbers. The problem is: I wrote buy side columns in the first select at the time of report creation. Then I linked the tables. After previewing the report I opened 'Show SQL Query' and...

Hi Malcolm, I have a query which has 4 selects in it joined with 3 unions. One select fetches buy side values and second one fetches sell side values and 3rd and 4th selects' fetch same buy and sell values but from different tables. The above query is in Oracle. I need to implement it in CR4.2...

Hi Helen, Sorry. You got my question wrong. I don't want to check whether customer id is null or not. I want to make a condition which says that customer_id must be null. Got it? (Here customer_id is a nullable field and for some combinations, customer_id should be null) where clause looks...

Hi Malcolm, What about those people who are using CR4.2 for the same problem? Thanks

I have a query in Oracle which I am porting to Access. My reports will be using Access as database. In the where condition of the query, I have to check for the following: customer_id is null How do I put a check for the above? When I try like {customer.customer_id} is null in selection...

My report goes this way:<br><br>I need to print the symbol and series along with the sum(quantity) group by symbol and series and whenever there is change in subbroker it should print total for him and whenever there is change in broker print total for him. At the end it should print totals. I...