3953918

Hi There, You may want to try this: TO_CHAR({today},'fmYYYY') :) Hope this helps! This works great! Thanks!

I figured this out. Thanks!

Do I have the syntax right on this expression? case when INSTR(TO_CHAR({trandate}) , TO_CHAR({today}, 'fmYYYY') > 0 then {amount} else 0 end

We use this setup and have been for a while now. First question, did you install the ODBC driver on the box housing the SSRS site? That's what the error message points towards. Yes, The ODBC driver is insallted on the box that the SSRS site is installed.

For starters, I don't think you need "transaction.trandate," just "trandate." You may not need that on any of those referenced values. I get errors when trying to reference the fields that way. I have to leave those in because the search is a reseller search and the fields listed are not reseller fields.

Try using BETWEEN statement.. CASE WHEN {trandate} BETWEEN '1/1/2011' AND '3/31/2011' THEN {amount} ELSE 0 END Thanks, Raymond I've tried this and it give me an invalid expression error.

We started down the path of attempting to run two companies in a single instance but it was far more work than it was worth and we did run into issues related to posting mistakes and the like. When we moved to OneWorld things got a lot easier. We sell to our subsidiary. We drop ship to our subsidiary's customers. We've…

With option 1 or 2 we are thinking how we the separation would be done. The situation is that company B is a reseller for company A. We have one warehouse, but use location in NetSuite to distinguish company Bs inventory from company As. It's starting to sound like OW could be the better choice depeding on the cost of the…