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...
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...
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...
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...
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...
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...
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...
Hello, I have two parameters. First one (@ByOwnLst) has two options "owner" and "list". The second parameter (@OwnLst) runs the report by owner or list number, depending on the choice selected in the @ByOwnLst parameter. In my Where statment I have the following, which returns the error...
Hello, I am conditionally hiding tables in a report. The visibility property accepts this, but when I run the report I get an error on it - Hidden expression for Table2 contains an error. TruePart of PubicFunction Iif as object.
I have:
=iif(Parameters!Export.Value = "false" or...
Hello, in my report I have a parameter which pulls by client ID and displays both client ID and name. A second parameter brings up a list of products associated with that client, by product ID, and displays product name.
I'm using one table with a mixed dataset of old and new product names...
Hello, I have a report that compares 3 years of data. The user wants to pick a starting month and year, and an ending month and year (usually YTD) and then have the report display that information as well as two years previous, same starting and ending months. They don't want to fill out the...
Hello, we have a report heading that shows the selections a user makes in a multi-value parameter separated by commas (in this case for profit centers). Example of formula for doing this:
=join(Parameters!ProfitCenter.Label,", ")
When the user selects "Select All", I would like it to say...
Hello, we have a report heading that shows the selections a user makes in a multi-value parameter separated by commas (in this case for profit centers). Example of formula for doing this:
=join(Parameters!ProfitCenter.Label,", ")
When the user selects "Select All", I would like it to say...
Hello, I have a report filtering a group on Top 20 and subtotaling with RunningValues so that only the totals of the Top 20 are calculated, and not the entire dataset. The issue is when there is less than 20. (I know this is a common request.) I've been all over the web on this one but am...
Hello, SSRS 2005. I am using a sort expression on a group. In English: If @Parameter = "A", then sort by Field1 ASC else if @Parameter = "B" then sort by Field2 DESC. This doesn't seem possible in the sort properties of the group, as the Direction does not allow expression. I'm wondering if...
Hello, I have to create a report with a parameter (@RunBy) that allows the user to run the report by Vendor or by Client. Could someone give me a general direction as to how you would then select the data according to the parameter pick? I have thought maybe a table variable (I've worked with...
Hello, I've seen other posts about showing 0 as null, but I want to (I think) show no data as 0, so as to get a data point on the chart equal to 0. I have a simple line chart, by month (X - category), year (series) and order quantity (Y - data field). If there is no order quantity for a given...
Hello, I'm working with filtering records in a table (top 20 on a group). I am using runningvalues to grand total the top 20 records returned. (As many know, SSRS will total all the records, not just the records returned from the top 20 filter). The developer I work with did a second row on...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.