|
EDIT:
I'm told that making you guys read means I get less attention. My apologies. Here's a simpler version:
Bill got $100 dollars worth of items from a store.
He wants to return enough of the items to get exactly $30 dollars back.
The store has a Point...
Started by Anthony on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
SELECT.
If this is not satisfactory, then maybe SQL is not the right tool for this job.
Is as follows.
|
|
Lynz,
Here is the solution you can try.
The first column "Screened" it is working correctly why it is not missing any X's that why it is counting all the rows as X's. Where in "Screen Failure" it is not so we have to write the data definition as follow...
Started by winson on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at ittoolbox):
Studio
Go to
-Query Explorer -> Insertable Object -> Select tool tab then Drag and Drop.
|
|
First, apologies as I am very, very new to Cognos reporting (have been working in it for just over a week, now).
I am in Report Studio 8.2, customized for Phase Forward reporting.
We have sites and patients as our sorting criteria. The client has asked...
Started by LynzM on
, 11 posts
by 4 people.
Answer Snippets (Read the full thread at ittoolbox):
Explorer -> Insertable Object -> Select tool tab then Drag and Drop into Your DataItems, a data Item.
|
Ask your Facebook Friends
|
If not then you can send me your report xml and the output to my email id. I can take a look at it.
winson11(at) yahoo.com
Thanks,
Winson
Started by winson on
, 9 posts
by 4 people.
Answer Snippets (Read the full thread at ittoolbox):
Studio
Go to
-Query Explorer -> Insertable Object -> Select tool tab then Drag and Drop.
|
|
On Tue, 28 Oct 2008 11:29:59 -0500, gls858 <gls858@yahoo.com
Sometimes when I add subtotals and then remove them the sheet still has
the subtotal 1,2 columns on the left side of the sheet.
How can I remove them.
gls858
Started by gls858 on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
My guess is that some
how when I removed the subtotals the lines.
In face, I'd select all and the 1,2 columns dissappeared .
You select the entire range (or whole worksheet) that has the
subtotals.
|
|
On Thu, 20 Aug 2009 16:31:35 GMT, "TraciAnn via AccessMonster.com" <u50702@uwe
I need to export data to excel and include subtotals.
The query selects EmployeeName, StartDateTime, EndDateTime and DurationHours
and filters on StartDateTime (Between...
Started by TraciAnn via AccessMonster.com on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
Why? You really don't need to answer this question; but there's a very... .
On Thu, 20 Aug 2009 16:21:30 -0500, "Clif McIrvin" <clare.moe@nevergmail.com.invalid
Hi TraciAnn -
"TraciAnn via AccessMonster.com" <u50702@uwenews:9ae2de43cab3d@uwe.. .
|
|
On Mon, 17 Aug 2009 12:18:01 -0700, Staceyglow <Staceyglow@discussions.microsoft.com
Lately, when I use the subtotal function, it does the subtotalling I want,
but I don't get the plus or minus signs on the left of the spreadsheet to
collapse ...
Started by Staceyglow on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
--
Dave Peterson On Wed, 19 Aug 2009 07:33:41 +0530, "Ashish Mathur... .
Tools|Options|View tab|check Outlining symbols.
On Mon, 17 Aug 2009 15:54:00 -0500, Dave Peterson <petersod@verizonXSPAM.net
In xl2003 menus, I'd check here first .
|
|
Hi,
I'm struggling with charts in Excel.
My data looks like this: (it's a lot bigger in fact)
code1 code2 01/08 02/08 X A 12 10 X B 8 15 Y A 52 0 Y B 5 5
Every day I add a column with extra data (the output of a sql statement).
A chart with 4 series (...
Started by jan on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at superuser):
DB Extra is also another tool.
An eval copy out there to see if it really does what you need it to do .
|
|
On Mon, 2 Feb 2009 09:03:01 -0800, Quana <Quana@discussions.microsoft.com
I am using 1997-2003 version of Excel
When using the subtotal on a spreadsheet and when the subtotals are shown,
the spreadsheet does not list the groupings on it. The ...
Started by Quana on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
On Mon, 02 Feb 2009 11:50:21 -0600, Dave Peterson <petersod@verizonXSPAM.net
Maybe you're not showing the outlining symbols:
In xl2003 menus:
tools|Options|view|check "Outline Symbols"
--
Dave Peterson
Hi all,
VLOOKUP(lookup_value....
|
|
On Wed, 28 Jan 2009 12:50:05 -0800, pjryan <pjryan@discussions.microsoft.com
I am working on a spreadsheet that was developed by someone else. There are
several data columns followed by 12 monthly columns containing numerical data
for each month...
Started by pjryan on
, 3 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
What version of Excel are you using?
--
If this helps, please click the Yes... .
On Wed, 28 Jan 2009 13:40:01 -0800, Shane Devenshire <ShaneDevenshire@discussions.microsoft.com
Hi,
Check to see if Tools, Options, Calculation is set to Manual.
|