CRM / SQL Reporting Co-Exist
We are trying to run Microsoft CRM and SQL Server Reporting on the same
server. We have experiemented with several approaches but with no luck.
Either SQL Server Reporting's Report Manager will not run with an error that
session state in disenabled in ASP.Net or I get an error that there is a
problem with the assembly Microsoft.CRM.Platform.Types.
Does anyone know where I could find a document on how to make CRM and SQL
Reporting co-exist on the same or server. It must be possible since many
people run Small Business Server 2000 or 2003.
...Updating a table from Form Entry
I have a form that pops up when a user clicks a button to Print said form.
The form is for the user to enter the name of the table and any footnotes for
that particular form, this form is connected to a table that stores this
information for everytime the report is printed. THe problem I having is that
when the user enters the information and clicks [PRINT] the report is blank,
when I open the table the info the user has entered has not updated onto the
table yet. Is there a way so that when the user clicks [PRINT] the footnote
table will update BEFORE the report prints?
Neve...Update textbox on form
The following are events on two combo boxes on a subform "NewJobsSubform",
the first sets the rowsource of the second and also sets a default value in
the second. The second event sets the value in the text box "Sell" to the
price associated with the RepProduct in cboRepProduct - collected from the
"Private Sub cboCatName_AfterUpdate()
On Error Resume Next
Me.cboRepProduct.RowSource = "SELECT RepairProduct.RepProduct FROM" & _
" RepairProduct WHERE CatName = '" & Me.cboCatName.Value...Linking Combo box to pivot table?
I have a pivot table which has teams on the left, months on the top and a
count of the calls in the data area.
What I would love is that if I could have a combo box on a worksheet which
when I select a team from its list it only shows me that teams data in the
Is this possible please??
Windows 98 + Office Pro 97
You could move Team to the page area of the pivot table.
Select a team, and the pivot table will only show its data.
> Hi All,
> I have a pivot table which has teams on the left, months on the top and a
> c...Forms Based Authentication
I have configured Exchange 2003 Server on Windows 2003 Server. Everything
works , HTTP,HTTPS, OWA Password change , but whenever I enable forms based
authentication I recieve an error "440 login timeout" and the page will not
I hesitate, because it doesn't fully match your diagnosis
but take a look at:
to see if it's of any help.
>I have configured Exchange 2003 Server on Windows 2003
>works , HTTP,HTTPS, OWA Password change ,...Vendor summary report
Hi, This is my first post here. I am trying to generate a report in GP V8.0
that will allow me to identify local vendors (by zip?) and provide a summary
total of how much we have purchased from them during different time periods.
Thanks in advance for any help.
Have you tried to create a smartlist under payables transactions? You can
then export to excel and sort and subtotal any way you like.
> Hi, This is my first post here. I am trying to generate a report in GP V8.0
> that will allow me to identify local vendors (by zip?) and provid...Can I see the summary report of each resouce's booking status ?
Here we using AutoAcceptAgent to booking resource account like meeting room.
Is there any method to view the summary report ? for example, a summary
report show which meeting room booked by which one for what agenda. I have
tried to use public folder with email address, but can't register by
AutoAcceptAgent. Any one has any idea of such request ? Pls help soon. Thanks.
On Thu, 20 Jul 2006 19:14:02 -0700, Enid
>Here we using AutoAcceptAgent to booking resource account like meeting room.
>Is there any method to view the summary repor...SQL Back-end / Access Front-end using linked tables????
I have a backend that contains tables that I pull Driver information,
Customer information , etc. (these are MAS 200 accounting software
tables that are exported nightly to the SQL backend). I also have on
the backend tables that I push information to; information that we
enter on the forms located on the front end. I might not have this
up correctly, but I'm linking all tables on the back end to the
database on the front end. When trying to set up an Auto Lookup off
a query I've created in Access it says I need to go into the table
change Data Type to the Lookup wizard,...Please help with last formula for order form.
I am able to accomplish this with 1 column by the formulas below.
Cell H160 is the subtotal: =IF(SUM(H72:H111)>0,SUM(H72:H111),"")
Cell H166 the total: =IF(SUM(H160)>0,SUM((H160*H163)+H160),"")
Cell H163 is for Tax.
I am almost finished creating an order form. I would like to get the SUM
of 3 different columns that are separated. I am not able auto fill
strait down the column, because the information is separated in groups
with titles, and the cells are not identically sized.
I tried varations of this formula:
=IF(SUM(H72:H111)+(116:131)+(135:154)>0,SUM ((H72:H...reported error (0x80070057)
When I try to send an email to several addresses using Outlook 2003, I get
Task 'xxx - Sending' reported error (0x80070057) : 'Could not complete the
operation. One or more parameter values are not valid.'
I see no apparent problem with the addresses. Please tell me in simple
English (well, as simple as possible) how to solve this problem. I am not an
What type of mail account is this? Exchange, POP3, IMAP?
"lemonscented" <email@example.com> wrote in message
news:EC994AB1-B72B-4...Automatically generate a new record
Can I autumatically generate a new record adding information (future date)
from a current record?
Yes. In your form have Double-click event call an append query that pull
data from your form fields to append one record.
INSERT INTO [YourTableToAppendInto] ( Field1, Field2, Field3, Field4 )
SELECT TOP 1 [Forms]![YourForm]![1stField] AS [X],
[Forms]![YourForm]![2ndtField] AS [Y], [Forms]![YourForm]![2rdtField] AS [Z],
[Forms]![YourForm]![4thtField] AS [A];
Build a little - Test a little
"Crown Jenny" wrote:
> Can I autumatically generate a new record addin...looking for cash drop and paid out reports
Does anyone have a report on these transactions that can be selected by date?
Any help would be appreciated.
...can't find form
i have a command button on a form [frmMainMenu] that when clicked, closes
that form and opens another [frmFixtureSchedulePrintOptions].
The 2 share the same table as a record source, so i'm doing this to avoid
the code behind [frmMainMenu] reads like this (below), and functions
stDocName = "frmFixtureSchedulePrintOptions"
DoCmd.OpenForm stDocName, acNormal
on the new form [frmFixtureSchedulePrintOptions], there is a command button
to save to close itself, and open the previous from [frmMainMenu], and the
...received/not invoiced report #5
All things being equal, is there any good reason as to why an item would not
appear on the POP Received/Not Invoiced Report one afternoon but land on that
report the next morning?
The item should have been on the report that afternoon. The client says
that the receipt for the item had been posted, prior to that report having
been run that first time. She, also, says that the report option used both
that afternoon and the next morning were the same.
Could it just have been a glitch in the system that prevented the item from
showing on the report that afternoon?
child...Both sides of a report page
Is there a way to utilize both sides of a report page as if printing a book?
On Wed, 9 Jan 2008 08:06:03 -0800, TRS <TRS@discussions.microsoft.com> wrote:
>Is there a way to utilize both sides of a report page as if printing a book?
Yes. But it is dependant on the printer your using, not on Access.
I want to know if i can write up my form on excel and then on anothe
sheet it summarizes it so i have a log of all the forms i send out bu
each time i create a new form can it create a new summary underneat
the old one ??
Message posted from http://www.ExcelForum.com
Does this mean that you have certain cells that you want to track?
If yes, then you could run a macro when you're done with the form:
Option Base 0
Dim myCellAddresses As Variant
Dim FormWks As Worksheet
Dim LogWks As Worksheet
Dim nextRow As Long
How do I record keystrokes and then evoke a command to repeat those
keystrokes? For instances; I want to change the first word in a numbered
list in the document all the way through the document.
You cannot record loops with the macro recorder.
The following will replace the first word in each paragraph in the selected
text with the word(s) defines in sText
Dim oPara As Paragraph
Dim sText As String
sText = "Replacement Text"
For Each oPara In Selection.Range.Paragraphs
oPara.Range.Words(1).Text = sText & Chr(32)
End ...Import Customer Records
I am trying to import customer records and I am running into the following
DOC 1 ERROR: Are you sure you want to delete this customer record?
Ln 810 Col 2, Update module, Last CBOM field read was root.'Customer ID',
Last window field visited was 'Clear Button' of window
'RM_Customer_Maintenance' of form 'RM_Customer_Maintenance'
Are you on the latest integration manager service pack?
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
The Dynamics GP Blogster at h...using program to record audio comment and compress audio to MP3
I can use VBA to record an audio comment into a Word file using
Selection.InlineShapes.AddOLEObject ClassType:="SoundRec", FileName:="", _
LinkToFile:=False, DisplayAsIcon:=True, IconFileName:= _
"C:\WINDOWS\system32\sndrec32.exe", IconIndex:=0, IconLabel:="Wave Sound"
BUT but by default the file is stored as a PCM at 44kHz and 16 bit stereo
whcih is about 200kB per second
Sound recorder (which is used to do the recording) allows me to manually
convert this to a MP3 and a much smaller file e.g. 3kB per second
Is there any way I can aut...Pass infomration from a form to a report...
I have a form that displays a certain fields from a specific record. How
can the selected values be passed to create a report?
From my understanding reports can only get information from tables and
queries. How can I query th information from a form?
Thank you for any help,
On Fri, 26 Mar 2010 12:13:31 -0400, George <MyEmail@FakeEmailAddress.com>
>I have a form that displays a certain fields from a specific record. How
> can the selected values be passed to create a report?
> From my understanding reports can only get information from ta...Linking Drop-down list to worksheets
I need 20 dropdown list on the worksheet. some of drop-down lists has the
same values. I need a list thats has one set of names and worksheet has
another set of names. Here is a example want I need.
LIST names Worksheet names
Red - Black 770rb
My list will have 15 items in each list. When user click on the color it
would take them to that worksheet.
What is best way to do this?
...How do I read in a record / row from a table.
I have a form where I need to read in the parameter setting for the current
I know I can use DLookup but I have to lookup about 14 different parameters
off a single row. But that seems quite inefficient.
I need to read the record and extract the values from the record / row.
Here's one possible approach ... there are many ...
You could create a form that is bound to that record, and make the form
hidden. You can refer to controls on the form with:
Microsoft ...Sum of Top Values in Access Report
In an Access report, I'm presenting the top 15 cost values in the detail
section. I have a counter to do start a new print page. That is working,
but I also want to present the group total (=sum[netofreturns]) with the
total of the top 15 values [top15only] and calculate the percentage of the
top 15 to the group total (top 15/group total) in the group footer.
...Problems Sending Messages to domains w/ multiple MX records
Got a question for the Exchange experts out there. We have a wierd situation
occuring where e-mails we send to domains w/ multiple MX records either do
not get through or the recipient receives the message multiple times until
we manually delete the message in the ESM/Queues. All other messages get
through fine. We have come to this conclusion (problem is with multiple MX
records) by testing the domains we are having problems w/ using
www.dnsstuff.com DNS Lookup tool for MX records. All of them come back w/
multiple MX records.
Here is what has changed recently: We moved to a new locat...FootNote links and PDFs
Does anybody know how to get Word 2003 SP3 with Acrobat Std 7 to generate
PDF links... I know this is more likely an Acrobat question... figured I'd
check in here.. 900 page document with lots of foot notes, and when you
convert it it removes the links Word inserts...
Thanks for anything you can do.
There's more than one way to create a PDF in Acrobat 7. If you just print to
the Adobe PDF print driver, you will not get any hyperlinks. However, if you
open Adobe and select Create PDF - From file, you should get the links you
If you have the Ado...