Search results for query: *

Hello. I have a table that looks something like this: Line Item Qty Customer Note CIF Date 1 item1 10 customer 1 increase by 5% CIF Edm 2/6/2016 1 item1 10 customer 3 keep steady CIF Cgy 2/28/2016 2 item2 5 customer 2 decrease by 2% CIF Tor 3/1/2016 3 item3 20 customer 3 decrease by 10%...

I have an sql view that has registration numbers for all provinces in Canada, except for 2. These 2 no longer require the registration numbers, so they are not in the view. However, I would still like my detail section to show them with "Opted Out" beside it. I suppose I can add them to the...

I have a spreadsheet that has the following: Invoice No, Invoice Date, Customer, Supplier, Total Price, Total Supplier Cost I am making a customer x supplier pivot with invoice date in the filter section so that my users can select appropriate date ranges. The date filter drop down in the...

I have an invoice report that has as parameters Starting Date, Ending Date, and Customer. I know how to do cascading parameters where they are all dynamic. But, this one has me stumped. I would like the user to select a starting date (static), an ending date (static) and then have the list of...

I have a cleanup task for cleaning out old backups. It hasn't been running. Well, it's been starting, but failing every time. The log file says: "Executed as user: SEYBOLD\SQLAGENT. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit Copyright (C) Microsoft...

Hello, maybe you can help me. And quickly. I have a rather busy chart that shows the forecast by weight of 10 items we bring in to our warehouse over the past 4 years. 10 different colours and symbols all with ups and downs weekly over 4 years. It's rather busy. I'm looking to cut through...

This morning my desktop seemingly wouldn't finish booting up. I went into safe mode and everything was fine. Ran sfc /scannow from command prompt opened as admin. No good. Meaning it didn't help. Decided to let it go longer and see what happened. Got distracted by various things. About 2.5...

I have a list of ordered items. I would like a way to display the most-recent price for each item. unit price based on min(order_date) or something like that. Can I do this? I also want to know if there is an easy way of having it display percent of total other than the brute force method...

I'm not sure if this is the correct forum, but I would like to make a certain step of a job I have inactive. I don't want to get rid of it, but I want it not to run. Maybe I can just set the step before to go to the step after the inactive one on success and failure.

I have an SQL database that I have been running select statements on and manually populating a tab of an Excel file. In this Excel file is another tab that does a vlookup on the data manually deposited on the first tab. That make sense? I'm trying to automate this. How can I? I know it's...

I have a field that will sometimes say "20 bundles" or "1 bundle" or "56 bundles". I would like a formula I can use that will strip the word off the end and then add the bundle numbers together. The trouble I see is that it will sometimes be "bundles" and sometimes be "bundle". I wonder if I...

I want to alternate colours in my cross tab. I have found this thread: thread149-1166557 But, it doesn't quite do what I want. First of all, how can I make it grey instead of yellow? Second of all, I have suppressed zeros, but this messes up the colouring. It only works if the zeros are...

I have a table that has items, prices and the dates the prices were from. How can I build a query that will give me each item, the most recent cost and the date it was used? There should only be one instance of each item.

I have a cross tab report where I am listing my columns in a specified order with a few left over under "Other". What I'd like to do is have it show how many are under other. Other (3) I know I can change what it says, but I'd like it to be dynamic, not static.

I have a subreport located in the detail section of my main report. I know how to suppress the subreport if it is blank. But, I want to go further. I want to suppress (or filter out) the given detail line if its subreport is blank. I'm pretty sure I can have the subreport return a flag to...

I have a file that has a tab full of data, and a tab where you can enter a bunch of cells and it automatically pulls, via vlookup, from the data tab the corresponding information. It's customers and their item codes. Sometimes it pulls the wrong customer's information if they happen to have...

I have a simple supplier vrs customer order $ cross tab in Crystal XI. I have the cross tab in the report header at the moment. I need to sort both the columns and the rows by descending sum of columns and rows. Easy in an Excel pivot. Can't figure it out in CR.

I have a regular line graph with each point marked and 12 lines. I'm trying to change each line to a moving average trend line. How can I just change them? All I can figure out is to add a trendline.

I'm trying to learn all the possible parameters of sp_send_dbmail. The below call is the closest I have got to what I want. It's showing a line of the result on one line of the email, so that's good (by the no padding parameter). And, I have thrown in a tab as the result separator and this...

I want an SQL function that takes a datetime field and returns "month year". Example: 04/30/2012 I want to return "April 2012" but still be sortable by date, not alphabetically.