Printing Picture Tool of Chart
I�ve started working with Dashboards using the Picture tool but can�
print the information and Excel and / or the Print driver (even Adob
Acrobat) squash the picture graph. If you hit print preview, the thre
inch high graph is compressed to about 0.5 inch high and the sourc
chart is even changed. Any ideas why this happens
Tal's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3357
View this thread: http://www.excelforum.com/showthread.php?threadid=53355
Have a read of this MSKB ...Split report into pages?
I have a CRM v4 report that groups data by account.
I want to display each account on a separate page. Or ideally a separate
Excel Worksheet within the same workbook!
Any pointers? Thanks in advance,
MR ICT Ltd - http://www.mrict.co.uk
When you create groups in a single Table opr Matrix in SRS, you can open the
Table Properties dialog, go to the Groups tab, and click the "Group Detail"
button (for Tables) or the "Edit..." button (for Matrices) and specify that a
Page Break occurs at the end of each group. This way, if you gorup by
Acc..."Sending messages x of x" in Outlook 2007 status bar
When I send a message in Outlook 2007, appears "sending message x of x"
where x is greater than 1.
I read that it seems automatic responses, but automatic responses are
Thanks for your time,
It's a bug in outlook- x-1 should = the number of email accts in your
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Ex...Having Word Print Blanks
I teach school and I would like to be able to have a document where I can
have the answers to questions show up on the screen but be blank when I print
them out. Is there anyway I can make word leave things blank only when I
Have the background of your document black, and make the text white, then
don't let it print the background.
"Bart" <Bart@discussions.microsoft.com> wrote in message
:I teach school and I would like to be able to have a document where I can
: have the answers to que...Stop print more than one copy of a report
I am trying to print only the current record with the following code and I
get 2 copy of the same report everytime I print and I also get an error
Private Sub Command59_Click()
On Error GoTo Err_Command59_Click
Dim stDocName As String
stDocName = "rptDocSub"
DoCmd.OpenReport stDocName, acNormal
DoCmd.OpenReport "rptDocSub", acNormal
Reports![rptDocSub].Filter = "Primary ID = " & Me![Primary ID]
Reports![rptDocSub].FilterOn = True
M...Macro to show only rows with X
How would I write a script or macro to display rows that have and x in "A"
and hide all other rows?
With data starting in ColA; try
Cells.AutoFilter Field:=1, Criteria1:="=x"
Jacob (MVP - Excel)
> How would I write a script or macro to display rows that have and x in "A"
> and hide all other rows?
> Thank you
Dim rng As Range
Dim cell, RowArray As Range
Set rng = ActiveSheet.Range(Cells(1, "A"), Cells(Rows.Count, &qu...Picture does not print
Using Publisher 2003 SP1 in WinXP SP2 to create a newsletter. I have
several photographs in this single-page publication and one of them will not
print. It is inserted at about 20% of original size and is cropped.
I have deleted the picture and re-inserted it (Insert Picture From File),
put it on its own page all by itself, made sure it is in the foreground, and
it just will not print.
If I start Publisher and create a new publication with just this one picture
it does print. In this test the picture was reduced to 10% but was not
If I duplicate the page where the ...Upgrade from Mac Office 2004 to Office X?
I've been running Mac Office 2004 and I want to upgrade it to Office X.
Do I really have to buy the complete version of Office X to do this, or
can I just buy the Office X upgrade?
The reason I ask is that from what I've been able to research, the
Office X upgrade only allows you to upgrade from Office 2001 but not
from Office 2004. Am I correct about this? And if I am correct, does
anyone know why Microsoft would have implemented such a policy?
Thanks in advance to anyone who can help!
Wait! don't answer that. just realized 2004 is the upgrad...modifying field in report?
For days of the week (not including Sunday) the field had numeric 1 or 2 or
3, etc. or combinations such as 13 for Monday and Wednesday. The database
had only 6 places for possible days a class could be held during the week.
For the report is there a way to:
1) Place a text line stating that 1=Monday, 2=Tuesday, etc.? I tried to
place * by the caption for the field and place the text in the Page Footer
but the = sign caused fits when I tried.
2) Test the field so that if there is a 1, Mon. would be written, etc.?
3) Do a query and generate the Mon, Tue, based on the numbers in the field...Aging Report
1) DateRecvd: E2 (ex 7/19/07)
2) DateClosed: F2 (ex 10/16/07)
3) Days (should close with in # of days, Example: 60) H2
4) DueDate: I2 (ex 9/19/07)
5) TurnAroundTime: DateClosed - DateRecvd (example:60) H2
6) # of days out of compliance (example 29) L2
A) If date closed is null then calculate now() - date recvd otherwise give
me dateclosed - daterecvd, is this possible? What formula would I use?
B) Take 6 & do buckets in a pivottable of 30, 60, 90 and 120 or greater? Is
this possible and are there any examples that can be downloaded?
Any help is greatly appreciated.
...active X control
I have a calandar (active x control) on my form.
Does anyone know how to link/sync it to a bound control; i.e., when a
user chooses a date control, the calandar appears, and when a date is
selected it populates into the requisite field.
Arvin Meyer, MCP, MVP
"alex" <email@example.com> wrote in message
>I have a calandar (active x control) on my form.
> Does anyo...Print header at margins
I have changed my left and right page margins to .25". But the left and
right Header sections still print with a 1" margin.
How do I get the left/right header to print at the margins I set?
Please reply to newsgroup, not e-mail
You don't. Left and right Header positions are fixed.
Gord Dibben Excel MVP
On Sun, 22 Feb 2004 16:48:08 -0600, "Fred Smith" <firstname.lastname@example.org>
>I have changed my left and right page margins to .25". But the left and
>right Header sections still print with a 1" margin.
>...Macro to change X-axis scale has errors
I've read and studied code from a number of posts on this subject but my
"newbie" macro code has errors. I have the minimumscale value and
maximumscale value (entered by the user) stored in Sheet1 at $E$2 and $F$2.
My chart is in Sheet2. This is my complete macro:
' ChangeXAxisScale Macro
With ActiveChart.Axes(1, 1)
.MinimumScale = Range("$E$2").Value
.MaximumScale = Range("$F$2").Value
I know I am missing s...Report Printing 12-07-07
I have a database name Transfer Deed & I have a form in which I’ve to give
data for fields.
Shares Distinctive No. From
Shares Distinctive No. To
No. of Shares (Difference of above)
I’ve a report also on before open the report a popup form occurs & ask for
Deed No & Lot which represent data above what I want know that before open
the report it open with lot of nos. provided for example.
Distinctive No from is = 500
Distinctive No to is = 1000
No. of shares is = 500
And lot provided on popup form is 100 then 5 pages report of 100 each...Getting query data for a report
If I have the query "UniqueCounts" and following query results:
2 Food Basket
99 Men's Dorm
84 Personal Needs
5 PN Family Pack
14 Program Dorm
7 Temporary ID
What would I put in a text field in a report to get the query results
from Count for the ServicesType "Men's Dorm". (Which should be the
you would want to put in 'Men's Dorm' as the criteria in the query....on in
a new query that is applied to this query
...unable to use ip literals user@[x.x.x.x]
my exchange server 5.5 had an open relay which has now
been fixed. but the IP address of my mail server got
listed in www.dsbl.org. and now i am not able to send
mails to our branch office which uses the list of
www.dsbl.org to get rid of spam mails.now i need an
address postmaster@[x.x.x.x] to receive a confirmation
email from dsbl.org. i did everything that the following
miscrosoft site says.
but still i am not able to receive mails at postmaster@
[x.x.x.x]. i tested this by sending a mail to this ID ...Sub Report Repeating Details
With On My Report I Have a Sub-Report,
The Main Report Shows The The Project Number, Project Title and
Enquiry Type: IE SUPPLY DUCTWORK ONLY
The Sub-Report Shows The Drawings That Are Needed To Be Sent For that
The Sub Report Is A Contineuous Type,
What The Problem Is That Some Times I May Decide to go out 3 Ductwork
When I Print The Report, it Repeats The Drawings Depending How Many
Companys Ive Gone To for that Enquiry,
Ive Tried Going Into The SubReport Properties and Selecting The Fields
Hide Duplicates No Difference.
Is there a simple way of Stopping it, or ...Office v.x Word
When creating mailing labels I am unable to print. I can
preview page layout under data merge manager and print
the page. But when I complete the merge to new document
and then print it seems to be sending somewhere other
than my printer.
This merge file was created in word 98. I recreated in
v.x and it still does not print the labels. Could it have
something to do with entrouge. Help please!!!!
I am new to OSx I just upgraded from 0S 8, I know behind
When you use File > Print you can select which printer (if you have more
than one) from the dialo...Active X Pop-up???
Blank How does one delete MS Internet Explorer "Active X" pop-up
By asking in an IE newsgroup, perhaps?
"Rudy" <email@example.com> wrote in message
: Blank How does one delete MS Internet Explorer "Active X" pop-up
: message?? Thnxxxx........Rudy
> Blank How does one delete MS Internet Explorer "Active X" pop-up
> message?? Thnxxxx........Rudy
What did you find when reviewing the ...Framework X error
I am getting this message when I open Office X programs:
"An unexpected error occured while trying to load the Microsoft
Framework X library"
There are users on the ibook. This happens under student where much is
I checked permissions for the user data folders in the users Document
folder and these are ok.
Thanks in Advance
On 8/6/03 1:08 PM, in article
> I am getting this message when I open Office X programs:
> "An unexpecte...Thermal printer cuts twice on Access report
I have an Access report that supplies data to a thermal receipt printer. I
noticed the previous developer placed a label at the bottom of the report
with the letter "P" in it. Next to this label, he placed another label
pointing to the first label saying "Used to cut the receipt at this point".
I'm assuming the P label sends a command to the receipt printer to cut the
paper? I ask because the users have been complaining that now (after they
installed a new printer driver), the Access report now cuts the paper twice!
It prints the receipt, cuts, then adva...Sales reports #2
Can anyone tell me how to run a sales report that includes sales per customer
for a given dept.
Go here and download the Detailed Sales with Customer Detail;
Put in you dates, drag the Department column so that its first, change the
grouping to the first 2 columns, then collapse grouped rows.
Must have access to CustomerSource
Get Secure! - www.microsoft.com/security
You must be using Outlook Express or some other type of newsgroup reader to
see and download the file attachment. If you are not using a reader, follow
the link below to setup O...Using a dll to generate report data
I am assessing whether we should move to reporting services to make
available various company reports via the web.
While most reports have a stored procedure origin for their data, there are
a few of our reports that require some programatic massaging.
These reports typically involve some specialised data pivoting and/or
My question is, can reporting services utilise a custom dll as the source of
data for a report? As an example, reporting services can generate a report
from a stored procedure via a select statement. Can reporting services build
a rep...Putting a label on the x-axis of a column graph
For a column graph with 2 columns for each month, how do I get a label
to appear for each of the 2 column groups (ie show Mar Apr May
repeatedly for 4 different groups)?
I'd like to see an x-axis like below:
2 columns each month
Mar Apr May Mar Apr May Mar Apr May
If you can figure out a little 8th grade algebra (where's an 8th grader
when you need one?), you can use an example like this to apply custom
labels wherever you want:
Basically, you hide the ...SRS Reports
We were certainly hoping that executives could access the reports on the SRS
server without having to have a license to CRM.
What we are discovering is that a user has to have a license just to view
the reports. Is that the case?
I can't justify spending $1000 a user just so they can view the reports of
the data within the system.
You have a couple of options here.
Since the reports in CRM uses the impersonated user they will need to be
users in CRM.
1. Develop custom reports using a proxy CRM user.
2. You can create the same report in SRS but using a different data source....