Search results for query: *

Yes, there are kludge workarounds but nothing that would work so well as proper support. UGH! What's it going to take to get this feature?

I think I'm missing the easy way of doing this. I've worked out the long way already. I have a range of pledge loss and refusals dumped from the database. Refusal for this year, dollar amount from year previous, and other info that's good to know. The simple pilot table right now is grouping...

http://www.ittrainingblog.com/2008/11/goodbye-mcsa-and-mcse-hello-mcitp-sa.html Has there been any discussion about this?

My pivot table looks like this: class jan feb march april english 5 6 7 5 math 3 2 4 5 geography 4 6 2 8 I'd like to calculate average attendance. Now the easy-peasy way is to just stick =average(range) to the right and...

The data we're tracking is for community services. We have multiple communities and community members who would take part in a class on a particular date. So our data looks like this: date participant class community 1-1-09 joe blow underwater...

Say I've got data that looks like this: Customer...Date...OrderAmount And I have multiple orders per customer and multiple dates and of course varying amounts. I want to create a pivot table that sums my customer orders by year and compares year to year. So far I have the first part just...

Found myself an interesting problem here. So, I have a date 3-1-09. I only want it to appear as 3-09. Well, simple enough with the "format cell" date option. The value in the cell may still be 3-1 but it appears as 3-09, problem solved, right? Not so. The people doing the data entry on this...

Excel 2007. I seem to remember there was a feature in an earlier version of Excel that would let Excel intuit that automatic formulas should be copied down if they were adjacent to manually entered cells on a sheet. So for example, let's assume Column A is titled Length, B is Width, and C is is...

I could have sworn this was possible in earlier versions of Excel. I'm stuck on 2007 now. I have a list of activities on one sheet that I would like to use as a range of options for data validation. In other words, we're presented with what looks like an html combo box, the down arrow is...

I tried googling and haven't found anyone else with this bug yet, wondering if the fine folks here might have seen it. Here's the story: we have a donor database that creates mailer lists in excel for sending off to the mail house. The export standard is the old xls file, Microsot Excel v5. I...

Here's a question about totaling. The data I'm getting back looks something like this: customerid year dollars 1 07 $50 1 08 $250 2 07 $100 2 08 $20 (full list is much bigger, customer ID's not sorted...

I think I can do all this in subreports, the question is whether that's the best solution or a bad one. The report we're trying to generate pulls data from many many different places. What we're looking to put all on one page: 1. Customer name 2. Customer addresses, business and personal...

I have a server, call it happy-iis01. It has a deployed SQL Reporting Services project. None of the local projects we have on the development box seem to be as current as the live site. (I'm inheriting the project, oh joy.) So, how do I open this remote project and copy the data down locally...

This is something that my boss wants to bring in. He's all for it but I'm having trouble getting concrete examples of what it does past the marketing jargon. "You can store documents on here!" Right, just like on the network share. How is this different? "We can automate workflows!" Right, just...

Ok, this is hopefully a simple stupid question. I should have been able to google it but I must not be using the exact proper words to describe it. We have an intranet we're putting together, part of our whole Sharepoint implementation. My boss would like to have the total from our fundraising...

I confess from the start here that I'm not a SQL Server guru. Here's the situation: we're running FR-100, a fund-raising and gift-tracking product from Sage Software. It uses SQL Server as a database but appears to make minimal use of stored procedures. The architecture seems to be essentially...

The dreaded nightmare we always hear about is "oh, well this is something simple we can do on a spreadhseet" but invariably more and more layers of complexity will be added until it's a hacked together nightmare to work with. I'd like to be pointed in the right direciton on how to approach this...

When learning something completely new, I find there's nothing more helpful than watching someone who knows what they're doing go through the steps. I've found this very helpful; I hope the rest of you here do, too. http://msdn2.microsoft.com/en-us/express/aa718391.aspx Learning Resources...