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!

Register Log in
  • Congratulations Chriss Miller 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: briesen
  • Content: Threads
  • Order by date
  1. briesen

    Group by Name

    I'm trying to group some data together in which I want to separate groups to be considered one. Below is a sample query, but basically I want LargeNail and SmallNail to be considered the group 'Nail'. The issue is that it just lists 'Nail' twice, with all the numbers separated. I want the two...
  2. briesen

    Merge Month and DateName

    I have a query that lists the aggregate Month and DateName by month in two separate fields. I would like to merge these together so this query displays like so: 2009 1-January 2009 2-February etc. SELECT 'Year'=Year(vtr."Billing Date"), 'Month'=Month(vtr."Billing Date")...
  3. briesen

    Nested Formula Issue

    I have a fairly simple nested formula, but I'm struggling to get the correct format. I know that the formula at the end is redundant, but I was just trying to figure out how to get it to work. Round (if isnull({tei.dteFileCreated}) then if {vtr.Mode}="LTL" then...
  4. briesen

    Left Outer Data On One Row

    I did a left outer join between two tables. The order number is split into different classes. When I return data, the order number lists multiple line items for each Class, like so: Order Class 1 25 1 26 1 27 2 32 2 33 I'd like to make it so it lists the one...
  5. briesen

    Numerical Parameter without field

    Is it possible to have an SQL parameter in which is just asks for a numerical value to input into a formula? It would be a non-existing field that would just import whichever value I wanted. Everything I've seen for SQL parameters is that you input a field and it asks you which value to use...
  6. briesen

    Chart Year over Year Comparison

    I have a Crystal Report which is essentially just charts. Currently, the Y-axis is a count while the X-axis is a billing date. The billing date is by month of the Fiscal Year. The categories are two different locations, which are displayed in the key. Instead of just having one fiscal year...
  7. briesen

    Refresh Open Works and Copy to New Workbooks

    I'd like to setup a macro so that Excel will refresh the query in each sheet in an open workbook and then copy everything to a new blank workbook. With that, I'd like it to be able to do this for all open workbooks. Here's the code I currently have, but all it does is copy the first workbook...
  8. briesen

    Multi Part Identifier Could Not Be Bound

    Could you please help me correct my formatting? I cannot figure out what I'm doing wrong. Thanks! The multi-part identifier "tbl.dteEffectiveDate" could not be bound. The multi-part identifier "tbl.nbrFuelSurcharge" could not be bound. Invalid Column name 'dteEffectiveDate'. Invalid column...
  9. briesen

    Drawing Line Above Chart

    I'm trying to draw a line above a Crystal Report generated chart, but the line keeps going behind the chart. I've tried moving the chart to the back of the section, but the line still gets blocked out. Is there anyway to fix this? It's just a set number that I was trying to manually display...
  10. briesen

    Null Dates in Group

    This may be an unusual request, but I'm not sure. I have a report where everything has a value: Customer Order Number Date Value When I group this report by month and there is a month with no values, I want the report to automatically field out the fields as zeros. For this example, the...
  11. briesen

    Custom Grouping multiple values

    I'm doing an SQL query where my first field has six different values. Theoretically, they are Blue, Green, Red, Yellow, Orange, Purple Is it possible to force them to group two or more colors together? For example, I want Blue and Green to group together, Red and Yellow to Group together...
  12. briesen

    Select but do not display or Group

    I'm pretty green to SQL queries as I come from Crystal Reports. Is it possible to select several different fields and use the WHERE statement to filter some fields, but not display the filtered fields? Here's an example of what I'm attempting to do, but it tells me I must either group the...
  13. briesen

    12 Month Rolling Average in Pivot Table

    I have a pivot table that is grouped by a category (Department), another category (Employee), the year, and the month. The data is from January of 2007 up to April 2008. Right now, I have it so it totals each column for the month and then for the employee. If I try to average it, it averages...

Part and Inventory Search

Back
Top