Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: dianemarie
  • Content: Threads
  • Order by date
  1. dianemarie

    Where Case expression or Boolean

    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...
  2. dianemarie

    Showing most recent record in a group header

    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...
  3. dianemarie

    Can I do a runningvalue on non hidden rows only?

    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...
  4. dianemarie

    Runningvalue on calculated field

    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...
  5. dianemarie

    Show most recent information for a field

    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...
  6. dianemarie

    Trouble with Iif/Case/Switch/InStr expression (calculated field)

    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...
  7. dianemarie

    Don't want grand totals in table footer on separate page

    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...
  8. dianemarie

    How do I refresh a stored procedure to show new param?

    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...
  9. dianemarie

    SQL query to pull max orderdate and corresponding quantity

    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...
  10. dianemarie

    Select Case Statement

    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...
  11. dianemarie

    Why won't this OR statement work for table visibility?

    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...
  12. dianemarie

    Dedupe parameter list

    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...
  13. dianemarie

    Parameter help

    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...
  14. dianemarie

    Replace parameter values with &quot;All&quot; in title heading

    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...
  15. dianemarie

    SSRS 2005 Parameter Value in Heading

    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...
  16. dianemarie

    Top 20 Filter/RunningValues

    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...
  17. dianemarie

    Can I mix Asc &amp; Desc in Sort Expression?

    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...
  18. dianemarie

    How to allow user to run report by Vendor or Client

    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...
  19. dianemarie

    Line chart - show nulls (no data) as 0

    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...
  20. dianemarie

    Conditionally hide all but the last group footer in a table?

    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...

Part and Inventory Search

Back
Top