Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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