Search results for query: *

Hello, In English, I need to say this in my Where statement: If @Division = M then oh.division in ('Management','In-House') If @Division = B then oh.division in ('Brokerage','In-House') else oh.listdiv <> 'C' (@Division = A) I've been trying it using Case, and also Boolean. I'm having no...

OK, your confirmation that FIRST should have worked when sorted descending by most recent date made me try it again. I had tried that previously but it wasn't consistently pulling the most recent list name. After mulling it over a bit I decided to put another hidden detail row in the report...

Hello, my report is grouped by list id, and I show the list name in the group header. The data is from one ordhist table. We have a list lookup table but I can't use it because we have some data from old systems where the list information is in the ordhist table only. The list name changes...

Hello, I have a report that shows a year to year quantity comparison by client and allows the user to select either clients who increased or clients who decreased. I hide the rows conditionally depending on what they select. I use a running value to total the non-hidden rows, but it totals...

Hello, my report shows order history summarized by group1 (owner aka "vendor") and group2 (mailer aka "customer"). I have the following "percent of total" calculation on group 2 - mailer. There are two types of quantities: Rental and Exchange, so I sum the two together first, then divide by...

Hi RG, still struggling. I added the Group By but now get "the multi-part identifier "LO2.client" could not be bound. Any thoughts?

Hi RG, thanks for your help. This is what I now have: SELECT lo.*, lo4.client as LastBrokerID FROM nm_ordhistall LO inner join (SELECT lo2.* From nm_OrdHistAll LO2 inner join (select client, max(createdate) as maxdate from nm_ordhistall) lo3 on lo2.client = lo3.client and...

Hello. I’m trying to retrieve Last Broker for a particular order. I have an order history table (OH) with the usual info but for purposes here the three relevant fields are: Order#, Customer, Broker. A customer has many orders, and a customer also can use different brokers for each order. I...

OK, I'm good. It was a simple user error. I neglected to remove the SUM that was inserted automatically when I dragged the calculated field. (Not the first time either.)

Hello, I want to take this SQL and put it into a calculated field in my report (SSRS 2005). I'm showing customer categories on a report, and they want to take categories that are broken out into several subcategoris and throw them into one category. (Ex: there is Fundraising-Health...

The page break is on Group 1, which is never suppressed. I'll give your last suggestion a try and let you know.

Hello, I have 3 groups in my report. The first group is by customer ID. The second two groups are conditional groupings by product depending on what the user chooses via a parameter. Dollar totals are on the product groups (2&3) as well as the owner group (1). The user can enter multiple...

OK, it is simple. Once I um...got my sproc names straight. (Changes were made to a copy of the sproc in case I screwed it up, and the report was still pointing to the original.) All is well.

Also tried executing the dataset in the query window. Also clicked the refresh button in the dataset query window. Tried saving again. Should this be this difficult? No. :)

Hello, I have a report using a stored procedure. I have since updated the stored procedure to include a new parameter. I can't get SSRS to recognize the parameter though. Tried refreshing the dataset, saving the report, getting out and going back in. I can't get it to see the parameter. Any...

I think I got it. I was mistakenly using ap. in the nested select. I took it out and it appears to be returning the results I need. Thanks so much for all your help. I'll be back.... :-)

OK, oops on the Where after the Group By. It didn't like me using documenttype either. Another way to skin this cat is to drop off any transactions where the qty is 0 (5's are always 0 and that's the one giving me trouble). I tried below but it now says The multi-part identifier...

Hi RG,thanks for your help. This has gotten me almost there, except I do sometimes have competing max dates. When this occurs, I always want the transaction where ap.documenttype = 1. (They are either 1, 5 or 6) This isn't working for me. It says "incorrect syntax near where". I tried...

Tinkering with this now RG. I'll let you know but I'm feeling confident. You always help me solve my problems!

Hello, This is for a stored procedure I am using for a report. I have a table that has several transactions per order number, and each transaction has an associated quantity and cost (dollars). As an order is revised, so are the dollars and quantities associated with that order. I need all...