Where's the Sort by New Message option?
Not sure when the layout of the newsgroups changed but I can't seem to find the ability to sort by new message in a thread instead of sorting by just the original thread date.
That was hugely helpful as I could follow along and see what threads were still active.
If you're gonna hang around in the newsgroups (any newsgroups), you may want to
start using a newsreader.
Microsoft Outlook Express can do it for you.
Saved from a previous post:
You may want to connect to the ms newsserver directly:
If you have Outlook Express installed, try clicking on these links (or copy and
paste i...Summarizing a Report
I have a database linked to an excel file for the table. The excel file
contains the results for a school archery tournament. Each school is allowed
to have 24 archers but only the top 12 count as a team score and 4 must be
male and 4 must be female. My report works fine giving me the top 12 and a
team total for each school and division, but it does not ensure the gender
ratio is met. Any ideas??
Also, I would like to create a report that shows just the schools and team
totals, but the only place I currently have team totals is in a report.
is it possible to use variable for sorting?
declare @sort varchar(10)
SET @sort='column1 DESC'
SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
Is dynamic SQL only option?
On 15/04/2010 11:28, simon wrote:
> is it possible to use variable for sorting?
> Something like:
> declare @sort varchar(10)
> SET @sort='column1 DESC'
> SELECT ROW_NUMBER() OVER (ORDER BY @sort)AS rowId, * FROM table
> Is dynamic SQL only option?
You can use CASE to he...How to sort account list?
I'm using MS Money 2004 Small Business. In the account list, my accounts
are catagorized by and in this order:
- bank accounts
- credit accounts
- investment accounts
- loans and liabilities
- asset accounts
In the above view, I cannot easily determine totals for assets and
liabilities. The following view does this.
- bank accounts
- investment accounts
- asset accounts
-loans and liabilities
How do I get the above view?
I don't use Small Business. But you can run a Net Worth report to get total
assets and ...Row names will not move with sort
Each row in my summary table in Sheet1 is hyperlinked to a corresponding table in Sheet2 with additional details.
I need to move the rows in my summary table (Sheet1) and preserve the links to and from the details tables (Sheet2).
I found that I can move rows in Sheet1 with cut & insert and the hyperlinks are maintained. I can travel from a row in summary table (Sheet1) to details table (Sheet2) and back, even after the corresponding row (Sheet1) was moved.
But if I sort the rows in Sheet1 the links from Sheet2 back to corresponding rows in Sheet1 lead to presorted locations. Apparen...sorts not sorting
OK- Thanks to everyones help I now i have a list i can work with... but
there are a few problems.... the zips are all 5 digit and now i have to
sort them... the problem is, THEY WONT SORT CORRECTLY!!!!!!! The
numbers are not in order... some are but a lot are not... is there
anyway to fix this???? i need to sort them by zip code but cant seem to
get them to do it correctly.. any ideas???
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You are going to be far better of...V10 - Transaction by debtor enquiry report
Anyone any ideas why when printing the transaction by debtor enquiry report,
the last digit of the amount is dropped off?
This is when printed as A4 - payables is okay going to same printer.
Okay when displayed to screen - only lost when actually printed.
Is the last digit perhaps trying to print outside the 'printable' area of the
printer? If you do not use A4 paper does it work? Do you have the A4 module
> Anyone any ideas why when printing the transaction by debtor enquiry report,
...Yearly Monthly break-down Cost Report
I need to report each month how many kids were in the program (New &
Carry-over from previous month), number of days in program and cost (per
diem). Time frame can be for calendar or fiscal year or past 2 months so
Begin Date: (1-1-07) and End Date: (2-28-07) are variables entered.
(example: Johnny "Date Placed" in program on 1-10-07 "Release Date" from
program 2-5-07) so for January & Feburary how do I calcualate each month?
January 10 - 31 and Feburary 1 - 4 (we don't count actual exit day)...HELP!!!
...Costed BOM report w/o Mfg Module
How do I get a costed BOM report when the following conditions occur:
- we do not have the Mfg module
- we are using FIFO Perpetual costing method
- I see a field for standard cost under the indented BOM view, but do not
know how/when this is calculated......
Is there a costing document that you can refer me to? I was unable to find
much depth in the on-line manuals.
Manager, Materials Systems
The standard cost rollup process is part of the Manufacturing Modules. You
will have to manually set the Standard Cost
Since you are not using manufacturing, I assu...import- number- sort?
I imported this data into a spread sheet- I tried to format it to number,
but when I sort it- I get :
Whats up with this?
Install the TrimAll macro, select the column and invoke
the macro from Alt+F8
Directions to install and use a macro at
I expect that you have spaces or CHAR(128) "Required Blank"
characters in you data you can check is =LEN(A1)
David...sorting macro #3
I need to sort on 8 cells in a row and on 1500+rows. I can do it one at a
time but I know there must be an easier way. Can ANYONE HELP?
C3:J3 I need these cells sorted and then down to C1532:J1532
I did create a macro to sort after I selected them but still one at a time.
Does it have to be a macro? I can edit a macro but don't really know how to
Yes, it has to be a macro. The following should do it. This macro loops
through all the entries in Column C, and in each row it sorts the values in
Columns C:J. HTH Otto
Dim rColC As Range
Dim i As...Customising Crystal Reports + File Location
We have installed Crystal 9 with the CRM Enhancement pack on top of it. What
i was wondering is there a list where i can know which report in crm is for
what? All i see is lots of folders with funny names like
9e4361ec44fd1190.rpt is there anyway you can get logical names from?
Should you create your own report where would you save in in CRM to be able
to access in via the crm menu?
Thanks and Regards
Sr. Systems Analyst / Programmer
CATS Tanzania Ltd.
NIC Life House 4th Floor
P. O. Box 2569, Dar es Salaam, Tanzania
Tel. +255-22 2137915, 2112631
Fax +255-22 ...big problem with reports. two much slow
I have a report that gets that from a query. well query is "heavy" and I
know that. the problem is that the report it takes too much to make the
preview, almos t5 minutes and then if I choose to print it, it takes again 5
minutes, it seems that it's running the query again.
I can I make prints be much faster?
Hard to say.
How long does the query take to run? If it is taking all the time, then you
need to work on the query and see if you can speed it up. Indexes on fields
used for selecting records would be the most likely thing to speed it up.
If t...Printing Form to Include All Options in Excel
I am extremely new to creating forms in Excel so bare with me here!
Is there a way that I can print my form so that all options in my list box
appear? I have a list box that is extremely long, so on the electronic
version I want to have a scroll bar to save space. However, when I go to
print, I would like all options to be visible. Can I do this w/o having to
make the list box extremely long on the elctronic version so that all options
Maybe you could print the list from a worksheet range?
> I am extremely new to cr...Bug in Grid Lines in CListCtrl Report View
This thing is again annoying me!
whenever I display the grid lines using LVS_EX_GRIDLINES , there are
problems when scrolling the CListCtrl at once , the grid lines seem to loose
their position and thus generating a blurred view or sometimes just disappear
Have anyone else faced the same thing ?
>whenever I display the grid lines using LVS_EX_GRIDLINES , there are
>problems when scrolling the CListCtrl at once , the grid lines seem to loose
>their position and thus generating a blurred view or sometimes just disappear
> temporarily...Frx report launcher-error when email report
I'll like to email a report in report launcher, but a have a message error
9060 during the ParseXML procedure. Output setting is excel
I connecting to GP in terminal server
Eric, please change the Excel output file format to:
"Formatted Excel" and try again, i have seen errors
when exporting to excel that do not replicate when
using the "Formatted Excel" option.
...Can we sort a form and also be able to enter new records.
It is possible to sort the data on a form and also be able to enter
new and edit the existing records in it.
On Tue, 15 Jan 2008 15:41:16 -0800 (PST), Rex wrote:
> It is possible to sort the data on a form and also be able to enter
> new and edit the existing records in it.
I assume you mean "Is it".
The form sort order has nothing to do with editing or adding new
records, so the answer is yes.
If you cannot edit or add new records, make sure the form's record
source, if it is a query, is updateable. Some queries are not.
O...Reports Access Demied Error
I get an Acces denied when trying to access to reports or some CRM Setup
even when I log as the administrator
However when I go tho the reports site directly through WEB interface, I can
what am I missing?
For the momment I have not configured SSL for authentication to the SQL
and both servers are in the same domain
the SQl server Services are handled by the user network
Thanks for any support
> I get an Acces denied when ...Draw continous vertical line in report detail section
My report has a report header approx 1.5" tall, a page header approx 0.5"
tall, followed by the detail section.
How can I print a fixed height detail section with verticle lines even if
there are only a few records? Essentially, trying to replicate a paper form.
The line starts at the bottom of the page header and continues to the top of
In a post a couple days ago, Allen Browne recommended the below for drawing
a line down the entire page.....this close, and I am trying to figure out a
similar approach for the detail section.
Private Sub Report_Page()
Me....Sorting checking register
How do i sort my check register in Money 2004 Deluxe so
that uncleared transactions appear below cleared
transactions? In Quicken i could click on the column to
provide that sort.
In microsoft.public.money, Dean wrote:
>How do i sort my check register in Money 2004 Deluxe so
>that uncleared transactions appear below cleared
>transactions? In Quicken i could click on the column to
>provide that sort.
You don't. Available choices are chosen by clicking View at the top
of the register.
...No password protect workbook box in Tools>Options>General
As is the case with much of this limited CD that was installed, some
important features are missing. I want to password protect any given
workbook. When I went to help (since the Tools>Protection didn't work) it
told me to go to Tools>Options>General, and click on the box that said to
password protect the workbook. As usual, this version has nothing of the sort
on the General tab under Options. Now what?
Why don't you get a full version if you expect full version capability? I'm
at a loss...
"MS" <...Full Page X Report
I hope someone might find this useful. This formats the X/Z report to
fit on one Full Page. Slapped together quickly but you can format it
how you like using XML...
New West Technologies
...Supplier List and Sales Report
I am trying to build a report that lists all items for a given supplier, and
then lists sales quantities (including zeros for items not sold) within a
given timeframe. My attempts so far have allowed be to list all items for a
supplier with sales for all time, but the minute I put a timeframe for the
sales in place I lose items that have not been sold from the list.
Does anyone know where I can find such a report or have any suggestions that
would allow me to complete it?
What report did you base it off of? Detailed Sales with a filter on the
Supplier field will giv...using addrress books to sort incoming mail
I use address books to sort incoming mail.
An odd thing: depending on how the sender's name comes across, it doesn't
get caught by the filter (amd moved to the "Family Mail" Folder I have set
up. for example: my mom and dad's email (from email@example.com)
comes as from that address. However, in my contacts, they are listed by
their names: John and Mary Smith, with firstname.lastname@example.org as their
email address and John and Mary Smith as the display name.
What have I done wrong?
1. The big ONE - failed to post your version of Outlook. Rules operate at
...Unmerge so I can sort
I coy/pasted data into Excell and when I try to sort it I get "This operation
requires merged sells to be identically sized". I understadn the work around
in KB but how do I find which sells are merged?
I wouldn't bother looking.
I'd just remove all the merged cells from the range to sort.
Select that range
uncheck the merge cells box
But if you wanted to search, you can do it via process of elimination. Select a
range, format|cells|alignment tab.
If that merge cells box is checked, then the whole selection is merged. If it's