Here is my code:
set @current = datepart(week, @pFCreated_1)
set @aweek = @current - 1
set @bweek = @current - 2
set @cweek = @current - 3
select wk_amount
from @summary
where week_nbr = ...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23004654.html
Is there a slick way to add grand totals to my report? so far, in my report table I have the following sections
TableHeader1
TableHeader2
Group1
Footer1
I added one of the same fiel...
http://www.experts-exchange.com/Database/Reporting_/Q_21722778.html
I am trying to find out how to get a grand central account. seems like I need to know someone who can invite me or else wait a few weeks. i travel alot and have been having my calls forward from ...
http://www.experts-exchange.com/Networking/Telecommunications/Q_23373269.html
Hi,
Re: Grand Theft Auto for the PlayStation
I'm looking for any reference material on the 'net' or otherwise which can give a step by step guide for all the missions, including all the secrets.
...
http://www.experts-exchange.com/Gamers/Tips/Q_10138279.html
Zones:
Game TipsDate Answered: 03/26/1999 Grade: A Views: 0
Is there a way in which you can play this game online?!?
http://www.experts-exchange.com/Gamers/Misc/Q_10319633.html
Can someone tell me if it is possible to program a PivotTable in Excel XP to display grand total for certain columns? I tried that but it is either nothing or grand totalling on every column. Is ...
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Q_203...
Ive noticed that MySQL doesn't support ROLLUP or CUBE in GROUP BY to handle subtotals/grandtotals. What is the common workaround to support subtotals and grand totals?
Everything I try involves ...
http://www.experts-exchange.com/Database/MySQL/Q_20418041.html
Zones:
MySQL ServerDate Answered: 12/09/2002 Grade: B Views: 0
Recently created a small home network. I have my old desktop pc (which now serves as a dedicated Grand Prix Legends server) and my laptop, which sits on the desk for myself and family to access th...
http://www.experts-exchange.com/Networking/Misc/Q_20522564.html
Hi there,
I have a query to get a count of the total # of records for a month. But I also need to know if the record count for that month is. How do I display that month?
In the query I ha...
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_20534144.html
Zones:
MS AccessDate Answered: 03/01/2003 Grade: A Views: 0
I'm trying to create a report with the following detail:
Date Reference Operator
I need the report to print as follows:
3/1/03 Ref 1 Operator 1
3/1/03 Ref 2 Op...
http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_20595125.html
