Reports not working in CRM 4.0 with SQL Server 2008 R2
Rollup 7 adds support for SQL 2008 R2
(http://support.microsoft.com/kb/971782/) so I’ve upgraded my SQL 2008 to R2.
The problem is that the CRM reports are no longer working.
This article explains how to do the upgrade:
but it’s too late for me: I’ve already done the upgrade without uninstalling
What is the easiest way to fix it now that SQL R2 is installed?
Is it something with repointing to the SQL R2 paths (I noticed that R2
changed the path for report server files).
...Excel Sort #4
Using Excel 2002 and have a list as follows:
When I hit sort, the list sorts as:
I want it to sort:
Can that be done easily?
Copy to Word.
Convert table to text (separate text with paragraph marks)
Edit, Replace. Wildcards enabled. Replace ([0-9])([A-Z]) with \1^t\2
Convert text to table (separate text at tabs)
Sort by Column 1
You can use either Word or Excel to put the two parts together.
> Using Excel 2002 and have a list as follows:
This is a multi-part message in MIME format.
Are there in Visual C++ plots drawing library like BCB TeeChart?
Thanks in advance.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dkoi8-r&q...Circular Logging #4
We are a small company with 17 users running an Exchange 2k3 Server.
I have had to disable circular logging so that we can have regular (during
the day) differencial off-site backups peformed prior to our full backup
I have been told that without circular logging the log files will continue
to get larger.
What methods, if any, can i use to keep the logs as small as safely
The logs don't get larger - you just get more of them, since the old ones
are not overwritten as they are with circular logging.
A regular full or incremental backup, ...plotting long plots
I have a HP designjet 110 nr plotter. I've created a plot that we nee
to show drilling activity. My first plot was 24"x36". Plot works grea
and to scale. My next plot was to be 24"x72". Now the charts will no
even display in Print Preview. I can scale back the plot where it i
about 48" and it will preview and plot, but I need it to go out eve
futher than 72 inches. I may go out as far as 30 feet.
I have images on the plot area and it will print it just fine at th
Is there a way to create range names for each row in a table and by
using a drop down list with these names in the list that are then used
as the series range in a graph eg
Row1 named RowA = 100 200 300 400
Row2 named RowB = 250 350 100 400
Row3 named RowC = 10 4 9 30 5
Row4 named RowD = 1000 40 500 40
Then as the graph range based on a drop down list one selects RowB and
250,350,100,400 is used in the graph. If one selects RowD then the
Yes you can.
Highlight each row of data, e.g. A1:D1, click on <Insert>,<Name>,<Define> ,
type the name...Getting charts to automatically pick data from a series
Can I get a chart to always use say the last 9 values of a series?
Does excel also do interactive charts?
Yes you can have Excel chart the last 9, 30 or whatever number of values
that you would like.
You'll need to use dynamic range names to do this. Here are several links
that will get you started.
The idea is to create dynamic ranges that will update as you add data and ...Plotting Data
Hi, how can I plot the analysis data in the document
class, in its related view class. Is it possible to make
plots like in MATLAB (surface plots,mesh plots of a
\m/ O_O \m/
I have a question . The question is how
to make a graph=85.I do know your name or kind
For example I have range the value of mean and variance. I need to
plot the two in same graph how is attachad .
tn 287.787 120.619
t12 2.147.523 13.843.230
t18 2.698.113 22.254.429
t24 3.288.497 17.780.971
td 1.841.121 7.918.387
Anyone have one idea.. how to make it?
Highlight all the data, with titles and click the Chart Wizard button and
choose a line chart type, follow the wizard. However, your first two data
points are very large relative to al...Graph not plotting what it should be plotting
I am having difficulty with Excel and was hoping someone
could be of assistance.
I am plotting a series of graphs with time on the x-axis
and water level on the y-axis. The first set of graphs
looks good. If you put the pointer over one of the points
on the x-y scatter plot graph you see: "EW-5 Pump Test"
Point "4321.00" (4321.00, 2445.04) 4321.00 is time in
minutes and 2445.04 is the water level in feet.
However, my next series of graphs for the same well (plots
the same type of data for another event) looks like:
"EW-5 Recovery Test" Point "43...Outlook #4
I am using Outlook 2002 and i want my outlook to leave a
copy of the mails in the server. How to enable this
feature. We are using Exchange server to download our
By default, your mail should already be stored in your Exchange mailbox,
Ramesh. You can check the setting using the steps outlined in this article.
296622 OL2002: Messages Disappear from Your Inbox
Microsoft Exchange Support
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ramesh" <l...drawing box plots with excel
I have different sets of data and would like to draw box plots (Minimum
lower quartile, medium, upper quartile, maximum) to present them. I
there any way to do this with excel or do you know another program
that might help?
Message posted from http://www.ExcelForum.com
do you want to actually plot the box or do u want excel
to work out the results for the upper quartile ect?
MVP Jon Peltier has some instruction on his site for
creating box and whisker charts:
>-----Original ...plots sent to to a chart tab do not show plot & I loss the plot
I have a spreadsheet that has a chart tab with a plot of data from another
part of the spreadsheet. Now, however, the chart is empty and when I try to
send any plot to a chart tab the plot is lost and the chart tab is empty.
This is happening now in all my spreadsheets the plot can be created within a
spreadsheet but as soon as I move it to a tab the plot is lost and the chart
tab has nothing in it. !!!????!!!!
...XY Scatter Plot
I have a stringline chart I have made out of the XY scatter plot chart
for trains in our area. The file is a program that allows users to
input a train number (e.g. 520), start time (8:20 - using military
time) and a starting location and an ending location. This if for my
boss so he can experiment with various train schedule and see the
trains in a stringline diagram (time of day vs. mileposts for each
train). I currently have all the trains plotted against the mileposts
and, correctly, some trains start and end midway where as others
complete the entire run. My problem is I am getting some ...Upgrading #4
I have xp and money 2004 premium when i use my account
(not the admin account) i get an upgrade is available
for download. I download the upgrade in admin and
install then go back to my account and get the same
message. I have reinstalled the program a few times.
Any advice? i dont want to work on the program in
Thank you all in advance for your help
<email@example.com> wrote in message
> I have xp and money 2004 premium when i use my account
> (not the admin account) i get an upgrade is...Protecting Cells #4
I want to protect a few cells in a worksheet - not the whole worksheet. How
do I do it?
Sorry, you have to protect the whole worksheet, then UNprotect all of the
cells except those that you wish to secure. Alternative may be to provide
data validation on the cells that you wish to protect, but this is not
particularly secure (copy/paste will override, for example). For that
matter, nothing is secure, I guess.
"Paul" <Paul@discussions.microsoft.com> wrote in message
> I want to protect a few cells in a worksheet ...how do i plot a rose diagram to show frequency of wind direction
can i use excel or another program in microsoft to do this?
Get a wind rose for Excel here
"kathryn" <firstname.lastname@example.org> wrote in message
> can i use excel or another program in microsoft to do this?
...multiple series bar and line chart
I am creating charts with 5 data series. I have it set up to create both
bars and lines. (bars plotted agains primary y axis, lines against secondary
y axis) However, it always sets the first four series to display as bars and
the last one as a line. I need the first two as bars and the last three as
How do I force a series from one type to the other?
I have already tried "plot series on secondary axis" but that only plots the
bars against the second axis. it does not change them to a line.
I am using excel 2003, and cannot use plugins. Only stock excel.
...deleting hypen from zip+4
I'm trying to delete the hypen from the zip+4. Example:
90210-1234 into 902101234.
I need to take out the hypen in order to mail merge the
zipcode using a postnet font.
If they're numbers, you can remove the custom formatting (Format - Cells -
Number). If they're text, put this in a helper column and copy down:
You can now copy this column, and use Paste Special - Values to replace the
original zip codes, then do away with the helper column.
mvpearl omitthisword at verizon period net
-------------------...Time Series Question
I have a line graph depicting product tests over a 2 week period.
The Y axis are the results ranging from -10 to +10. The X axis is
timescale. The problem I have is that the timescale only allows days,
months and years. What I actually need is the x axis to breakdown into
hours as multiple tests take place each hour.
Is there any way that such can be accomplished in Excel?
Use an XY chart, not what is confusing called a line chart. You can then
set the X axis increment in Excel's time format.
"news.microsoft.com" <Post2Group@Only....Voting Buttons #4
Is there a way to set up a Voting Button to select
Multiple Voting buttons. I need a response with 2 votes
to be selected. Thanks.
No, but you can send 2 emails, each with single choice voting buttons.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After searching google.groups.com and finding no answer, email@example.com
| Is there a way to set up a Voting Button to select
| Multiple Voting buttons. I need ...Forwarding mail #4
I am trying to find out if it is possible to forward a
individuals emails from from his account in exchange to
an external address?
Sure, see http://www.msexchange.org/tutorials/MF015.html
For Exchange news, links and tips, check:
"Matt Owen" <firstname.lastname@example.org> wrote in message
> I am trying to find out if it is possible to forward a
> individuals emails from from his account in exchange to
> an external addre...Windows Update for HP Photosmart 475 DOT 4
I keep getting an Error Code: 0x80070005 everytime Windows Update asks me to
install Windows Update for HP Photosmart 475 DOT 4. How do I get around the
You may receive an "0x80070005: Access is denied" error message when you create
a scheduled task on a Windows XP-based computer after you install security
Can you install the printer update from the HP web site?
Mary Sauer MSFT MVP
"Roger" <Roger@discussions.mic...how to plot a polar chart / plot
Andy Pope, Microsoft MVP - Excel