Access reports 04-01-07
I have check boxes in an Access report. I am exporting the report as an rft
file. When I do this, the captions for the check boxes show up, but the boxes
Is there some way to fix this problem?
I assume you mean rtf and not rft.
An answer given by Allen Browne on the subject:
None of the graphical elements survive when you export in RTF (Word) or TXT
(text) formats, so you lose the lines, check boxes, pictures, etc.
If the recipient does not need to edit the report, you could use Snapshot
format. The snapshot viewer is a free download for them:
http:...Difference between XML templates and Active Reports
Why does RMS use XML templates (for receipts and P.O.s)
and for most other reports Active Reports?
I realize that the XML receipts can not be changed or
resorted on the preview screen, but why use not all
Active reports are based on formating the results of a SQL Query - if you
can work out the SQL to get the result set you want, you can create almost
any report you want.
The XML Templates are based on objects internal to RMS, like the current
transaction for reciept printing, the active PO or Transfer request for PO
prining, or a given customer for Statements. Y...Quarter-End Payroll Reports #2
When trying to process quarter end payroll reports I am receiving and
unhandle script exception: [Microsoft][ODBC SQL Server Driver][SQL Server]
Could not find stored procedure 'SCSB.dbo.uprGetPension'.
...Custom reports, where are the .rdl's found?
I've created a dozen or so custom SRS reports and imported them via the
Reportserver. Now, I'll be moving to a new report server and am unable to
"extract" my .rdl files (yes, I know, stupid that I didn't keep the
originals). Are these held somewhere in the report server or on the web
server? I was able to find where the vanilla ones are saved to my custom
ones aren't there. I don't want to rewrite them unless absolutely necessary.
More Actions did not work either. Thx.
Not sure why the 'More Actions/Download report' doesn't work, but the ne...e-mail 2 reports
Is it possible to email 2 reports as 2 separate attachments?
With outlook as an email client:
Arvin Meyer, MCP, MVP
"Samuel" <email@example.com> wrote in message
> Is it possible to email 2 reports as 2 separate attachments?
On Jun 21, 2:07 pm, "Arvin Meyer [MVP]" <a...@m.com> wrote:
> With outlook as an email client:
> http://www.datastrat.com/Code/Outloo...Deployed SQL Reports
I am trying to deploy the GP SQL reports. I have assigned the user to the
database, but it appears they do not have proper access. I am getting error
messages like the following:
• An error has occurred during report processing. (rsProcessingAborted)
o Query execution failed for data set 'dsPrmLocation'.
Semantic query execution failed. The SELECT permission was denied on the
object 'InventoryPurchaseReceipts', database 'TEST', schema 'dbo'.
If you are referring...Mailbox Manager and "Report only" summary reports are wrong
I've just started utilizing the mailbox manager on out win2k3/Exchange 2k3
I created a Mailbox Policy to "REPORT ONLY" and send a summary report to the
Every time the mailbox manager runs and does what it is supposed to, but the
Summary report that is sent to the administrator is wrong.
It always reports a
Messages Moved #
Size of Messages Moved #
With values greater than 0.
Now I know that it is not actually moving anything because the same wrong
values keep coming up every time.
Of course my question is, How do I get a corrected report?
T...RDC Crystal Reports integrated problem
I use Report Designer Component (RDC) in my program to allow user
modify reports. I downloaded RDC Merge Modules for Crystal Reports XI
Release 2 from BO. It is the zip file contains 4 files:
I made a build and install but I got the error about license. So, I
try to add all 4 merge modules and use the install serial (I bought
the Developer Edition) for keycode property of
CrystalReports11_5_RDC_License.msm. Unfortunately, ...Copying Advanced Financial Reports Into Another Company
I am on version 9.0 and I created some financials in the Advanced Financial
reports area, but I would like to use the same layout and customization for
the other entities we have in Great Plains. Does anyone know how to do this?
I am really trying to avoid having to recreate the same reports for every
Thanks in advance
There is a tool on CustomerSource that lets you copy Advanced Financial
Reports from one company to another. On the left side of
CustomerSource click on Support >> Automated Solutions.
Microsoft SBF Specialist
www....print multiple reports from database
I have a table in my database that contains customer orders, within
those orders are the products reuired to fulfil the order. For each
product there is a related product information guide (in pdf) stored
in a folder on my computer.
Is it possible to run a query/report that prints the requires
information sheets, for each customer order?
(also posted in microsoft.public.access.queries)
Use the Sorting and Grouping to force a new page for each group.
Build a little, test a little.
> I have a tab...Customising monthly reports?
I'm just starting out using Money. One thing that's annoying me is
that I can't see how to customise the monthly report. I have income
and expenditure from a small business which I don't want to see on
this report. I've removed the relevant categories from other reports,
but I don't seem able to do it on the monthly report, and consequently
the figures are skewed and pretty much useless to me.
I'm I stuck with this?
<firstname.lastname@example.org> wrote in message
news:email@example.com...Printing crystal reports invoices?
I am looking at a GP install that a user tried to upgrade to version
9 themselves (from 8). apparently in 8 they had an option to print
invoices in crystal.. when they printed the invoice they had an option
in the print menu dropdown to print to crystal. apparently it was
configured somehow using the named printers setup.
Is anyone familiar with this? The user has absolutely no idea whether
or not they had any third party apps installed and from what I believe
is their v8 dynamics.set file I don't see any additional modules that
would do this.
Are they using the Forms Pri...Crystal Reports 10 Licensing
At Convergence, I spoke to the people at the Crystal
booth and the impression was that the pricing structure
had changed substantially and now the bulk of the
expense is with the licenses to view the reports as
opposed to the licenses to write the reports.
Do you have any pricing details for the latest version of
I've developed a vb.net application that uses Crystal's
API calls to deliver reports on a citrix server and that
eliminates to have user licenses.
>At Convergence, I spoke to the people at the Crystal
>booth and the i...Installiang the Crystal Reports add-on to a workstation
Hi, one of my colleagues is trying to generate custom crystal reports for
CRM. He has installed Crystal Reports v9.0 + SP3 which makes his version
126.96.36.1990. When he attempts to install the CRM Crystal addon piece (CD5) he
gets an error message referring to "Setup has detected that you have Crystal
Reports 9.2.0 installed. You must first upgrade to Crystal Reports 9.2.2 to
continue with this setup." We are not sure what is causing this message.
Can anyone help?
You can download the appropriate version of Crystal Reports 9.2.2 from the
Business Objects Web s...Unrealized Capital Gains Reports
This is a new problem. When I sell a partial lot of a
given stock, and refresh the "Portfolio Value by Account
or Investment" report, the cost column doesn't change to
reflect the lower share count. Here is a specific
Have 200 share of xyz at a cost of $20/share. Prior to
selling a partial lot, the report gives the correct
unrealized gain information with a total cost of $4,000.
When I sell 50 shares, and refresh the report, the cost
column stays at $4000 and recalculates the unrealized
gain of the remaining 150 share as if the remaining
shares were at a co...Unable to Access Reports from CRM Interface
We have deployed Microsoft CRM, but there is problem that the reports
cannot be accessed by using Microsoft CRM interface from client's
machine. There is no problem accessing the report in local server, it
can be shown correctly from CRM interface, if it's accessed in the CRM
There are two servers, one for CRM application and the other for
database+report server. User can access the Report Manager interface
from their local machine (http://dbserver/reports).
Anyone has idea, what is the possible error? Thanks.
there is a white paper that requires additional ...Documenting Smartlist Reports beyond report name
Is there a way to document within GP further information about
smartlists. I would like to be able to write a 2 or 3 sentence
explanation of the uses of the report, etc. that would be readily
available such as in a report properties but I don't see any such
I was wondering if anyone new how to generate a simple report. Daily Sales,
showing just day and total sales for that day.... for a month
Ive tried, but no good results...?
Do you need detailed sales or just the basic dollar figure?
Manager> Report> Sales> Summary sales --choose filter
Manager> Report>Sales>Detailed sales
"cjones" <firstname.lastname@example.org> wrote in message
>I was wondering if anyone new how to generate a simple report. Daily
> sho...Top 5 Most Important Reports
I was wondering ( based on ALL of your experiences) if you could
share the top 5, lets say, reports that people want to see or know
about from the Project Manager?
And I understand that different stakeholders are going to want different
things and that no one organization is the same. However, I have to guess
that there have to be "Best Practice" methods for reporting project
information right? Thanks for your help.
Earned Value Reports (includes PV, EV, AC, SPI, CPI and their variances)
Critical Path & Total Slack Analysis
Poor performing tasks ba...One user unable to see reports
I'm wondering if anyone else has encountered this problem - a user is unable
to view reports. Going to Workplace->Reports results in the "Server Error in
'/' Application." error message. Sometimes the records page does load, but
the list of reports is empty. Also, context sensitive reports don't show up
in their regular places - in fact the reports button is completely gone from
the forms that usually have it.
I've tried other user logins and they have no problem viewing reports. Only
this particular user has the error. Reports has been working for t...log of printed reports
I have a set of reports that I print on a regular basis. I need to be able to
keep a track of the date and time at which each report was printed in a table
of query so if it goes missing, i have a record of whether and when it was
printed. I have been unable to come up with a way in which i could generate
this automatically. I would be thankful if i could be helped with this.
Create a table with columns ReportName and PrintedDate. Let's assume you
name the table ReportLog
In the Close event of each report, put code like:
Dim strSQL As String
If MsgBox("Did...How to backup reports created using SQL Reporting Services?
Can anyone please tell me how do I take backups of reports created through
SQL Reporting Services (SSRS).
Does anyone have documentation on procedure of backing up reports created
with SQL Reporting Services? Also does anyone have steps on how to restore
reports from backup?
I have been assigned task to modify some reports using SQL Reporting
Services. It is my first time working with SSRS reports, so I want to be sure
to take a good backup of all the reports created so far using SSRS and I'd
like to be able to know how to restore a report from backup in case something
goes wrong....Verify Database (Crystal Reports)
We are tryhing to add selected custom fields to existing crystal reports on
CRM Version 1.2.
We are running Crystal Reports Developer Edition 9.2.2+. Any changes we make
to existing rpoerts data, structure, formula, etc work fine.
The problem is we can not verify the database in order to grab our custom
"Failed to load database information". Can we not use the Developer Crystal
Version to add custom fields ?
can you go to database verify database location and make sure the location
says SSO rather than a server name
Microso...Crystal Reports and Memo fields
Is it possible to use Memo fields to filter Crystal Reports?
We are using the description field on the account level to store marketing
campaigns that the account has been sent. I now want to be able to filter
the opportunity reports to display information on each marketing campaign, so
I want a filter which says something like 'Description contains "MKT-01"'
where MKT-01 is the name of the marketing campaign. Each account can
potentially be involved in multiple (100's) of different campaigns, which are
listed in the description field.
Any ideas woul...cannot access reports on crm web
i am running crm 3.0 system. i am able to see and run reports on
outlook client of crm but not on web. is there anybody else who has
encountered same problem or can anybody please recommed a solution to my
in the web client can you go to crmwebserver/reports and see a list of
Microsoft CRM MVP
"RG" <RG@discussions.microsoft.com> wrote in message
> i am running crm 3.0 sys...