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...Word 2003 Header Problem
I've checked all the messages and cannot find the answer to this problem.
Hopefully, someone here knows the answer!
I need to create a unique header on page 2 of a multi-page document.
Section breaks or page breaks didn't work. Breaking the link didn't work
either. I actually tried to use an IF statement, but my skills are modest at
best and could not get that to work either! Thanks for any help!! :)
You were on the right track!
Create a section break for pages 1, 2, and 3, so that each is its own
section. Now click on View->Header and Foote...Word crashes when I hit ctrl and mouse click (equivelent of mouse right click)
Operating System: Mac OS X 10.4 (Tiger)
My word program stops responding (freezes) whenever I use the control key (ctrl) with the mouse click. This essentially prohibits all the functions you use a right click on a mouse, such as spell checking a work. The program stops working and I have to force quit. <br><br>Someone at the Mac store thought it might have to do with macros but I have no idea what to do or what that means. Any help would be very appreciated. Thanks so much!
In the Information Technology field, "someth...i can't figure out how to calculate percentages in excel
I can't seem to get excel to show my the right numbers in percent format
i'm dividing a cell of 3000 by a cell of 342 and i get 8.771929825. if i try
to switch this to percentages i get 877%.
what am i doing wrong?
Nothing. 8.77 *IS* 877%, just as 1.00 is the same as 100%.
What are you expecting?
In article <63010FFE-C18F-41B7-A652-0F512F575D95@microsoft.com>,
Laserbeak43 <Laserbeak43@discussions.microsoft.com> wrote:
> I can't seem to get excel to show my the right numbers in percent format
> i'm dividing a cell of 3000 by a cell of 342 a...mail merge from excel?
How do I merge lists onto letters?
Take a look here:
In article <A2126B11-6212-4553-840C-2156A6B3B539@microsoft.com>,
bswope <email@example.com> wrote:
> How do I merge lists onto letters?
...Excel 2003 Array Formula in Excel 2007
I am moving from Excel 2003 to Excel 2007. One problem I'm having is
with the following array formula which works in 2003 but returns a
#VALUE! in 2007. Is there something I need to change in my 2007 setup
to make this work?
.... I know there are probably more efficient ways of doing this so I'm
not looking for better solutions. I'm wondering ... why won't it work?
There are 3 array formulas on the spreadsheet and all are returning
Thanks in advance!
On ...Excel 2002 Issue
When I have Excel open and I receive an email with an Excel attachment in
it, I can't open the email without closing Excel and reopening it. I've
tried repairing my installation, but that doesn't help. Any suggestions?
Try right ckick on the attachment>save
"shawn" <Shawnp_29@hotmail.com> wrote in message
> When I have Excel open and I receive an email with an Excel attachment in
> it, I can't open the email without closing Excel and reopening it. I&...FIND AND REPLACE FUNCTION CRASHES WORD
Operating System: Mac OS X 10.5 (Leopard)
New Mac User. Office: Mac 2008 Home and Student version
When I use the find and replace in Word, Word closes, does not save changes and tells me to report the error to Microsoft.
What do you suggest I do? I did report it each time it crashed. Thank you.
Doesn't happen here.
Diagnostic tricks to help locate the cause of the problem:
1) test in a variety of documents--new documents, old docs, long docs,
short docs, to see if it happens in every document or just certain
2) Log out of your user...error bars on bar chart in Excel 2007
I would like to assign a separate error bar value to each of the data sets
within my bar chart. When I use the customise error bars feature it allocates
the same error bar to all of the bars in the graph.
Each chart in the bar is a mean in itself, hence the requirement for
individual error bars.
I see from previous posts that this appeared to be possible in Excel 2003
but I don't have access to this version.
If each bar represents the average of a set of numbers, then you can
calculate the standard deviation (or other measure of dispersion) for this
set of numbers. Put these ca...Exchange 2003
Is there a way in exchange 2003, to query all mailboxes for:
ASX/ASF/MPG/MPEG/AVI/QT/RM/RAM - movie file formats.
And have exchange 2003 which we run . . to generate a detailed report
showing how much data of the total information store that movie files
are taking up(eg: if employees are using the mail system appropriately).
Also if it can, once it queries which users have movie format files in their
inbox, to then list how much of the overall information store is being used
by each employee(movie formats).
ie: user1: 2% of the organizations total storage data is from this users
total ...Opening excel from launch bar opens 2 existing files, not blank on
Opening excel from launch bar opens 2 existing files, not blank one - does
anyone have any idea why? I checked the setting under Tools > Options >
General > at startup open all files in: and there is no entry.
Look to see if those files may have gotten saved in the XLSTART folder. HTH
Sincerely, Michael Colvin
> Opening excel from launch bar opens 2 existing files, not blank one - does
> anyone have any idea why? I checked the setting under Tools > Options >
> General > at startup open all files in: and there is no ent...Excel function to do this?
Say I have this:
4 11.....and so on
How can I produce column B (e.g., B5=A5+B1+B2+B3+B4)?
In article <5ff86e7e-4215-4fde-85d4-9fe110a658e2
@l24g2000vby.googlegroups.com>, firstname.lastname@example.org says...
> Say I have this:
> A B
> 1 1
> 1 2
> 3 5
> 2 7
> 4 11.....and so on
> How can I produce column B (e.g., B5=A5+B1+B2+B3+B4)?
Type =SUM(A$1:A1) in cell B1, and then drag the formula down as far as
Dollar signs in formulae force absolu...how do i extract the formula from a trendline in Excel?
I have a lot of data with an order 6 polynomial trendline. I know I can see
the equation used to plot the trendline by displaying the equation on the
chart, but is there a way to output this equation to a cell instead? I would
like to analyse the data, but copying each equation for each set of data into
cells (and having to rewrite them as formulae that excel will recognise) will
take a long time. Thanks.
If it's a poly fit, use the LINEST worksheet function:
If it's more complex, try Tushar's approach:
www.tushar...Subtotaling in Category Report
Trying to accomplish very basic in Money 2005: Setting up a Category
Report (no problem) that will subtotal by Payee (problem).
How does one do this very basic modification?
On the rows and columns tab (at least in 2004). It won't give you a category
total below the payee subtotal. Rows can't be different report topics, such
as payees and categories, in the 'spending by category' report. You can show
payees as rows under categories in the 'Transactions by category', but the
payees aren't summarized - they're individual transactions.
Gaine...Show maximum date in a query/report
I am having trouble with a query/report that I run that should show the last
payment date that a tuition payment was made. It works for most records but
for the ones where the tuition payment is more than it was the previous month
then it it showing the payment date and tuition payment from that previous
For example the records are
PayDate of 2/3/2010 and TuitionPayment of $45.00
PayDate of 3/2/2010 and TuitionPayment of $80.00
I would expect the query/report to show the 3/2/2010 payment but it is
showing the 2/3/2010.
Like I said most of the accounts are showing the c...Choose filename and folder when saving report as PDF
My form contains a button to save a report to PDF. However, the future
user can not choose the folder the pdf is placed, nor the name of the
pdf: this is all automatically generated; I assume this is done by the
Is there a way to make it possible that the folder and/or filename of
the pdf can be chosen by the user?
I was thinking of using fHandleFile or acSysCmd, but I definitely
could use some hints to help me on the way somewhat more.
My curren...Access will report error and shutdown when attempting to view a re
Cannot view a record in database. receive faulting application msaccess.exe,
faulting module vbe6.dll in application event viewer. Source: Microsoft
Office 11, Event ID: 1000. PC is Windows XP SP2 with Office 2003 and latest
Rocks <Rocks@discussions.microsoft.com> wrote:
>Cannot view a record in database.
Is this one particular record? Using a form or table or query view?
If a form is this all records or just one record.
I ask because this could be a corrupt form or a corrupt record.
See the Corrupt Records in a Microsoft Access MDB page at my website
http...z report #2
When my customer does a Z report at the end of the day, it only prints
receipt showing zero dollars, almost like a 'no sale' receipt. Yet, when
you go in to the 'manager' you can view the receipt and it shows all the
report information. Anyone have any idea why?
You may want to check both receipt printers and the register properties.
It's possible that the journal is not printing a hard copy, and the one that
is printing to the receipt is a different receipt format.
"SBM" <email@example.com> wrote in message
news:uMaq...Excel Macros #8
Is there a keystroke combination that will disable further
macros from running on a loaded spreadsheet? If, fo
example, I allowed macros to execute when the spreadhseet
originally loaded, how do I disable this function while
inside the same spreadsheet?
If you add this line in each macro/event then the macro will not work when cell A1 have the value "stop"
you can run a macro with this line to place the word "stop" in the cell
Sheets("Sheet1").Range("A1").Value = "stop"
If Sheets("Sheet1").Range(&quo...excel crashes when changing web query
In excel 2003, i have a file that pulls in data via Data / Import External
Data / New Web Query. I've been using the file for about 3 years, and now
when I try to edit the query to pull in the latest table on the same website,
excel crashes. And it does the same on another pc running excel 2003.
However, I can successfully import data using the same method from other
websites. (When I'm editing the query, I can the IE Script error, but not
sure if that's related.) I would be grateful for any suggestions.
...Graph lines formatting in Excel 2007
I appear to have a couple of problems in Excel 2007 SP1
i) Although the help says you can reformat multiple lines by using the Ctrl
button and the mouse, it doesn't seem to work .. I highlight the first line
and when I try the second it deselects the first . Any ideas
ii) I'm using Excel to display sets of spectra .... the default line
thickness is 2.25pt and I want to set the default to 0.25 pt, how do I do it
iii) I resized a graph of 160 lines by hand (yawn, yawn) and saved it as a
template ... however when I draw a new graph from the 160 lines and apply the
temp...Required fields in Excel
I'm brand new to using VB.
I have been playing around with setting up required fields in Excel. I
was lucky to find a post with the following code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
If Worksheets("Sheet1").Range("A2").Value = "" Then
Cancel = True
MsgBox "Please Fill-In A2"
I have tested this and it works fine. This basically ensures that excel
can't be saved unless the specified cells are filled in.
Now for a really stupid question. How do I save this script to the
excel workbook so ...accessing excel in another thread
I am using
this to send data to excel, it works ok, but when I try to use it in another
thread it fails.
AfxMessageBox("Couldn't start Excel and get Application object.");
Does CreateDispatch works only in the mai nthread of the program ?
...how do i generate invoice from excel datafile?
how do i generate invoice from excel datafile?
mailmerge in word
> how do i generate invoice from excel datafile?
...Open Excel 2007 .xlsm doc, but not allow user to copy it?
How do I prevent a user from copying a Excel2007 Workbook.xlsm the user has
rights to open and run?
"CrownJewels.xlsm" is an Excel Workbook with VBA for Oracle read-write code
and lots of VBA user functions. Users in the company need to read data from
the database, process estimates of assets and opportunities, have those
inputs and outputs saved to the Database. CrownJewels is fully protected:
Passwords on the VBA Project, Worksheets, Workbook, some worksheets Hidden,
some VeryHidden. I even have a Workbook_BeforeSave event to capture and
cancel any attempt to S...