multi-column data consolidation
Hi guys, here is my problem....
- Column A to F are months (Jan to June)
- Beneath each month (starting row 2 downwards), text data will b
How can I have the six months add up or compiled as a single colum
database in another sheet or a separate column in that same sheet?
will be adding data every so often under these months and it shoul
update the database.
Thank you for any assistance/help
Message posted from http://www.ExcelForum.com
Question is not clear to me.
Not sure what 'add up or compile' means with text entries
Perhaps, in G2 enter =...Historical Open Purchase Orders sql
I have a need to see all purchase orders as of a given date (01/01/2010).
The problem is the Open Purchase Orders Smartlist report only shows what is
open as of today. Can someone let me know if SQL can be written to get this
data? I do not have a backup from that date.
If you double-click on the Open Purchase Orders SmartList, there are four
search definition fields that are available to restrict the search results.
If you are using the default, the first three should be populated for you.
You have the option to leave those or change them to sui...Jump to SSRS report
I have a report which calls different sub-reports depending on the
parameter’s value from the main report. All this works as expected when i
view it in visual studio.
However, when I try to upload the sub-reports into CRM 4.0, I cant seem to
link the sub-report to a parent report and the system doesn’t recognize this
either, normally it recognizes that the file being imported is a sub-report.
I would really appreciate some help here.
When i deploy the report using Visual Studio deploy tools everything works
fine on the reporting services website. I would really appreciate some hel...Public Folder Permissions
Can I use an AD Security group to set permissions on the entire Public Folder?
I want to ensure my Admin group can delete any public folder from within
I know I can do this from the system manager. But is there a way I can set
outlook Client permissions on all folders without having to touch each folder?
And if I can do step one above, Can I have these permission apply to any new
public folder created via outlook?
Yes. It must be a mail-enabled universal security group.
MVP - Exchange
"Protecting the world from PSTs and brick backu...SQL Version (Build) with WMI
How can I get the SQL-Server Version and Edition with WMI or registrykey?
This server is patched with SP3 and CU5. The BuildNumber is 10.0.2746.0 now.
This RegistryKey give only the basic insallation version, not with updates.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\100\BIDS\Setup]
With this SELECT I can list what I want, but I search a WMI querie.
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('edition')
Enterprise Edition (64-bit)
thanks for your help
...Count number of records on a report page
My report has several grouping levels and works OK. I am OK with creating a
text box to count the entire number of records in a report and in a group.
But I've been asked to count the number of records printed on any given
report page. How can I do this?
I'm using version 2003.
Thanks in advance
Add a control to the detail line to number the detail lines
Control Source: =1
Running Sum: OverAll
Add a control to the page header
Control Source: =[txtLineCount]
Add a control to the page footer
Control Sour...Multi profile
I have configured outlook 2007 to use multi profiles. When I close the
outloop and re-open to select other profile the profiles select list is not
prompted. I have set for prompt for profile. But I observed this, after
closing outlook still the task manager shows Outlook.exe is runing..when I
kill that and re-open I can see the profiles and select particular.
Now my question, why Outlook is runnning though its closed. My setting "Hide
when minimized" is already OFF.
have a look in the "Task Manager" under "Process" if Outlook.exe is stil...Reporting Options
Can someone tell me where the static reports are stored? I found some static
reports (PDFs) that load up in a webpart; however, it's unclear where they
are stored. In general, I am researching the various reporting options. We
would like to create reports (scheduled) and store them in a document
respository, making them available to specific users based on custom roles.
...SQL Server 2005 and 2008
All of my databases are currently in SQL Server 2005. Thus, I have SQL Server
2005 Management Studio installed on my machine to connect to my SQL Server
2005 instances. We now have a SQL Server 2008 instance setup and I want to
know if I connect to a SQL Server 2008 database via my current Management
Studio? Should I be upgrading to the 2008 version?
Also, is it possible to create Maintenace Packages to backup my SQL Server
2005 database from my SQL Server 2008 server? I want to start setting up new
Maintenance Plans on the 2008 box if that's possible?
Finally, I have S...Mac Stuff CDs, A to Z, updated 15/Jan/2006, and Win & Mac programs, 'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform', 'MultiFormat', 'MULTIOS', 'HYBRID'
Mac Stuff CDs, A to Z, updated 15/Jan/2006, and Win & Mac programs,
'WinMac', 'PC/MaC', 'Win-Mac', 'Multi', 'Multi-Platform',
'MultiFormat', 'MULTIOS', 'HYBRID'
GARAGE SALES, buy, risk-free purchase, working, tested, fully
functional, very cheap discounted price, low cost, quality OEM
Abvent Artlantis v4.5 Mac 1CD
Adobe Acrobat 6.0.0 Professional Mac OSX 1CD
...Messages Summary Report
I have three thousand mails in my inbox & same in sent folder
Now I need to summarize them in excel sheet in tabular form
from / to, subject, date, time
Is there is any way or tool to do it
-- Prasad Auti
Not using Windows Live Mail.
"Prasad" <Prasad@discussions.microsoft.com> wrote in message news:38DF756A-AFEA-4BBD-BF4C-962D9FD02D71@microsoft.com...
> Hi All,
> I have three thousand mails in my inbox & same in sent folder
> Now I need to summarize them in excel sheet in tabular form
&...reports using filtered views
Would any one explain me the steps of using filtered views in the mscrm
database for creating reports?
although it is for crm 3.0 but it can give u clue what to do.
if you have specifc question then please post again .
...FRx to include unposted reversals when reporting unposted transac.
If you have an unposted reversing journal and you run an FRx report for the
following month, FRx does not pick up the unposted reversal
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/defa...Hide Intermediate Levels in Date Dimension
I have a pivot table (built from a ms cube using ms query) that has a date
dimension. My raw data has the Date as mm/dd/yyyy and the pivot table
automatically generates the month, quarter and year from this date. I cannot
seem to be able to display only the Year and Month (without the Quarter). I
can show the top level of the dimension (Year) or the Months alone, but I
cannot supress just the Quarter. All of the "Hide" options are greyed out for
the intermediate levels. Can anyone tell me how to do this with a Date in a
pivot table? (Excel 2003) Thanks.
...Report Must be Clicked to Enlarged
I developed an application which runs several reports. When a report opened
it remained minimized so I put a command in the open event of each report:
This solved one problem, however, the report still does not fill the entire
screen until the report is clicked after it is displayed. Is there a way to
do this programatically so that when a report is opened, it not only
maximizes, but fills the entire screen without the user having to click on it
On Sat, 12 May 2007 08:38:00 -0700, rmcompute wrote:
> I developed an application which runs several reports. When ...Report Viewer
I am looing for ReportViewer control from the Reporting group of the Toolbox.
I am not finding the Reporting Group in Vsiaulo Studio 2010 Express.
Am I blind or do I need to get the professional version?
Certified professional Geek
...Multi-threading with multi-port server
Can I ask your guidance on how to imeplement server with multi-
threading and multi-port? meaning, I would like my server to receive
audio and video in different ports, and they run concurrently and send
the data to clients.
I am so lost, because I would mess up my .accept and .listen and
setparent if i have videosocket and audiosocket object. I tried and it
"Rehmet" <email@example.com> wrote in message
> Hi guys,
> Can I ask your guidance on how to imeplement serve...Adding two items on report to get a sum of both
Hi. I am in the process of modifying a established report to make it more
meaningful. In the report there are two quires that give an answer. I want to
add a third box adding these two together.
The first one is: =IIf([TotalCash] Is Null Or 0,"0:00",(Int([TotalCash]/60))
& ":" & (Format((([TotalCash])-((Int([TotalCash]/60))*60)),"00")))
The sencond one: =IIf([Time] Is Null Or 0,"0:00",(Int([Time]/60)) & ":" &
I would like to add those 2 results together,...Multi Store Workflow Question
We have one store and a warehouse. We need to order and receive items at the
warehouse and transfer them to the store. We need the store to be able to
see what is on order and all inventory at the warehouse. Is anyone doing
something like this, and how easy it it? At a recent demo, this required
many steps, logging into 3 different databases, doing updates, etc. Very
confusing for simple tasks we need to do every day.
Microsoft RMS HeadQuarters would be the solution for you.
You can view the inventory in Warehouse and items on order from the Store
Diviasoft, In...Parameterized Report
Does anyone know how to send parameter eg. invoiceid to
the custom report in MSCRM?
I want to be able to display crystal report of a selected
invoice by clicking a button in the CRM toolbar.
Any help is greately appreciated. Thanks in advance.
...If all Sub Reports are null dont show Parent
I have a Parent Report that contains individual information such as name,
director, manager, dept. It also has 6 Sub Reports in it linked by employee
ID, These different Sub Reports are for Phones, Computers, Pages and such. I
have it set so if the sub report is null it does not show but the other sub
reports will show their data.
Now what I would like to do is IF all of the Sub Reports are null don’t show
that employee on the parent report.
If possible and someone could point me in the right direction it would be
>I have a Parent Report that co...Multi axis chart
Hi, I want to show a stacked chart, ie 4 products sales value in a given
month. But then compare it to the prvious years results.
I know you could use a 3D chart to show 3 axis, however I can't find how to
have the 2 axis (last year and this year) stacked.
Hope you understand what I'm asking
A 3D chart is more likely to obscure than show anything.
I'm not sure what you're looking for. Perhaps a stacked-clustered column
chart, where each column in the cluster has the four stacked values for each
http://peltiertech.com/WordPress/2008/05/19/clustered-stacked-co...Check Links Error Message
It seems that whenever I run Check Links on the Inventory
Series, I get a series of error messages for the file
Item master saying, for example "The default price level
STANDARD is not included in the price list for item 427-
00001, and has been cleared." Last night I got 13 pages
of this error message.
STANDARD is the only price level that we have. 427-00001
is a typical item number. This number changes with every
error message as obviously it is deleting the price level
for these items. However, I have numerous other items
that have the price level where the price level is...Mfg BOM for configured item
I am trying to setup a configured item in Great Plains 8.0
After setting up the superBOM and routing, when I try to create a configured
BOM, the system tells me that I need to create a Mfg BOM and do a cost rollup
before creating a configured BOM. Costing is FIFO perpetual.
a. For a configured item, do I need to create a mfg BOM. If so, what is the
logic here. Where is this explained in the documentation. Please provide page
numbers and name of document.
b. How do I calculate standard cost for the configured item.
c. When I run the BOM report (reports-manufacturing-BOM), the report han...Pros and Cons of default Report Installation Services (SQL 2000)
During the install of CRM 3.0, it give us the option to point to a reporting
services server or install a new default using SQL2000.
This is on a Small Business Server 2003 Premium R2 box and it have SQL2005
workgroup edition installed.
Which option should I use? Should I let CRM 3.0 install it's default or
have it point to the SQL2005 for reporting services. Since it's on the same
server, what's the pros and cons between the two options? Is it a matter of
performance between SQL2005 and SQL2000? Thank you for your input.
Reporting Services a...