How to create custom reports?

How can i create custom reports? 

do i need any other software or can it be done with 
default CRM installation ? 

10/7/2004 12:45:15 AM
crm 35858 articles. 1 followers. Follow

3 Replies

Similar Articles

[PageSpeed] 50

Hi Jazz,

You will need crystal deport designer to write your own custom report.


"Jazz" <> wrote in message
> How can i create custom reports?
> do i need any other software or can it be done with
> default CRM installation ?
> thanks

10/7/2004 3:23:56 AM
is that a seperate product ... installed on same 
machine ? 

does that use crm tables ?  and can i show the reports 
from within crm ? 

>-----Original Message-----
>Hi Jazz,
>You will need crystal deport designer to write your own 
custom report.
>"Jazz" <> wrote in 
>> How can i create custom reports?
>> do i need any other software or can it be done with
>> default CRM installation ?
>> thanks
10/7/2004 2:10:44 PM
Hi Jazz,

Yes it is a seperate product. Must not be installed on the CRM server
thought, you can run on client machine on the network.
Yes using CRystal you can access CRM tables to write your own report.

Depending on the version of Crystal you bought, you may need to apply
Crystal Enhancement to your version of Crystal to make it accessable to

Have a look at this website below, this will clear thins up for you.


"jazz" <> wrote in message
> is that a seperate product ... installed on same
> machine ?
> does that use crm tables ?  and can i show the reports
> from within crm ?
> >-----Original Message-----
> >Hi Jazz,
> >
> >You will need crystal deport designer to write your own
> custom report.
> >
> >Rgds,
> >Kyaw
> >
> >"Jazz" <> wrote in
> message
> >news:05e501c4ac06$e9716300$a301280a@phx.gbl...
> >> How can i create custom reports?
> >>
> >> do i need any other software or can it be done with
> >> default CRM installation ?
> >>
> >> thanks
> >
> >
> >.
> >

10/7/2004 10:19:27 PM

Similar Artilces:

Custom Outlook 2007 forms to sharepoint
Hello, Can someone please confirm and help with me trying to publish of send a custom outlook 2007 form that i have created to a sharepoint list of even a database? Can this be done and if so is it hard to achieve? Thank you so much in advance! ...

problem creating report
I have 15 working forms from 2 diferant colums from one table what I want is to run each query on its own line of a report with 4 calculations at the end I can select 1 query and produce the first line but how do I move to second line and query? thanks Duane Hookom wrote: > This is a really unusual question. What do your forms and columns have to do > with your queries and report? > > A report can have only one record source. This record source could be a > union query. You can also use subreports to display additional queries. > thank you ...

Access 2007 SP1
Dear all, the following message was posted several months ago on this newsgroup and on microsoft feedback page from access 2007 beta release ************************************************************************************* Dear all, in access 2007, I can click the "page setup" menu then the "page setup" button, and choose to print the report on a specific printer. However, after saving the report and re-opening it, he still prints on default printer. The specific printer setting is not saved with the report (this worked with all previous versions of access, it s...

Copying only report sheets
Hi: Happy new year. I created a MS excel workbook which has 4 data sheets and 4 report sheets. Each report sheet links to each data sheet. Now I want to create another workbook that will show only the 4 report sheets. How can I do it in VB code? Agin, in each report sheet, I copy and paste data from data sheet and thus each report points to individual data sheet. Workbookname: ctces sheet names:dat1,rep1,dat2,rep2,dat3,rep3,dat4,rep4 Best wishes and thanks -- jesmin ------------------------------------------------------------------------ jesmin's Profile:

Editable .doc bound report object in Access 2003
I have a report which containers a bound word file, which allows me to edit the wording in Word. However, when I convert the database to the .mde format, I loose that functionality. Is there a setting or a way I can keep that functionality for this report in the .mde version? Thanks. ...

Error printing report: "specified path for the output file does
Hi - I'm trying to print a Payable Distribution History report but get the error "specified path for the output file does not exist". It does not happen with other reports. Any help to fix this error would greatly appreciated. thanks Oumar hi Oumar, go check the Report Destination screen and make sure that there is no path listed in the field where you can enter one. It would be in the File checkbox. If it is grayed out, mark the File option, delete the path and then unmark the File box. Should you want to save it to a file, then select a valid path. Hop...

New Mailbox
Hi All, When I create a userid object for a new employee in 'Users and Computers' the NT account is created. I usually wait about 3-5 minutes and the email address are created. Yesteday when I created a new user the email address took about 15 minutes, but Exchange 2003 only created a X500 email address. No smtp etc. I am thinking that this is a problem with RUS, however I have run a rebuild and update, and still no luck, I cant seem to find any messages in the event log either! I deleted the entry and recreated the same user with the same result. I hope someone can help me!!! Tha...

How to create treeview active control as another activex control's child?
I want to create an activex control who will wrap a treeview active control but has some its own logic. I don't know how to create it and how to set its position and size. say,if I want my active control's size is the same as the treeview active control. Any idea ? Thanks ...

Help creating two listings from one record
I have extracted "members" from my database. One record will contain LastName and FirstName, and may also contain SpouseName. Because I am creating membership cards in Publisher, I think I probably should actually create another query or ?? that contains one record with either [FirstName LastName] or [SpouseName LastName] Probablyl something like ... If SpouseName greater spaces List SpouseName LastName else next sentence. List FirstName LastName I don't have a clue how to do this in Access. Appreciate all help. Try this -- [FirstName] &a...

Visual Basic
Hi, I trying to create a table using visual basic, when i try to run it. It prompt me "No fields defined, can't append Table or Index. Anyone, could highlight to me what is the problem. My code is as follows: Public Sub PCreateTable() Dim dbs As DAO.Database Dim tdf As DAO.TableDef Dim idx As DAO.Index Dim fldTradeDate As DAO.Field Dim fldStockName As DAO.Field Dim fldRemarks As DAO.Field Dim fldCurrency As DAO.Field Dim fldClose As DAO.Field Dim fldChange As DAO.Field Dim fldVolume As DAO.Field Dim fldHigh As DAO.Field Dim fldLow As DAO.Field Dim fldValue As DAO.Field Dim fldDay...

Creating Postcard 2 UP & 2 sided with Mail merge
Hi everyone: Good morning. I hope that some one can help with the design and setup for doing the following: 1) Postcard 8.5 by 5.5 (basically half of 8.% X 11 letter paper). 2) Print on both sides 3) Mail merge on both sides How do I set it up so that I can have 2 postcards to be printed on 1 sheet using either one of MS Publisher or MS Word? (prefer Word) I know that my printer does it. First, I already have the design in both MS Publisher and MS Word. I also have the mail merge done. MS Publisher: Page Setup: Width 8.5 Height: 5.5 Paper: Letter (8.5 X 11)...

Keep Pivot Table custom chart type
I'm creating a pivot table custom chart type "Line - Column on 2 Axes". The chart looks great when I create it. The problem is when the user does anything to the chart (filters the data, adds a new flield of data, etc.), the chart changes to where both data series are displayed as bar charts and the second axis is gone. I can't find an event that fires when they modify the chart, so I don't know that I can programatically change it back. Is there a way to keep it from changing in the first place? I'm using Excel 2003. Thanks! Loss of formatting is a known prob...

Importing of customizations is not complete
Hello, I develop on a separate server, the customizations are exported and then imported and published on the production server. Even though I get no error messages not all customizations are loaded in the production CRM! As far as I can judge it concerns relatively "small" modifications such as the modification of the display name of an attribute. I can find the modified display name in the XML file but it doesn’t get loaded! Any ideas? Thanks, Jan ...

Creating Shortcuts
I have a script running in an EXCEL document that creates new workbooks based on input from the user. It then saves the file in a set location. I would like to adjust the code to creat a shortcut to the new file and place the shortcut in a different folder. Is there a way to do this? In the VBE editor, go to Tools > References and set a reference to 'Windows Script Host Object Model" Now, the code below would create a shortcut named "Book1Shortcut" located in the folder "C:\Test\myfolder" with the target Excel file of the shortcut being "C:\Test\Boo...

Creating an additional profile in Outlook 2000?
Iam a newb with Outlook and have searched on here for a solution to my problem. I am using XP home edition and Outlook 2000 with update of SP3. My ISP provides me with 5 email accounts, all of which are not aliases from my understanding of what an alias account is. Mine are "",""etc. I am wanting to be able to access 2 email accounts, one with my nickname for friends and forums and the other for my new business, while using my version of Outlook 2000 without having to upgrade to a newer version. I don't want to create a new '...

Customizing menu item names, form names etc.?
Hi all, Is there any way to customize the names of forms - for example if I want to call an "account" a "business partner" and modify it in the menu items and form/view names as well, can I do it? Thanks in advance, -- Anurag ...

Delivery report #2
In an Exchange 5.5 installation, sometime (only sometime) when I send a message such this : - a messange sent from A to B (internet address), cc C I get the delivery report : From : server administrator sent : <date time> to : A subject : <message subject> the message to : B cc : C subject : <message subject> sent : <date time> was delivered to : D (a new internal address !!!!) <same send time> Any ideas ? Alex Probably an alternate recipient on user A, B, or C. At least that'd be my 1st guess. Open Exchange Admin, look at the properties or user A, B, ...

Using a listbox selection to limit records in a form and report
I am trying to use a listbox of names to limit the results of a form to just those names. On a similar track, I want to use the selected names to limit a report. I have the listbox created and have added a button next to it to initiate the next step, but cannot figure out how to do it. Also, would like to (if possible) use multiple listboxs in the same way (ie, name and/or department). "dascooper" <> wrote in message >I am trying to use a listbox of names to limit the resu...

Printing a range of invoices for 1 customer
Hello, I've been vexed by this a lot over the years, so thought it was time to make sure I wasn't missing something obvious. When a customer's account goes overdue, or one day they decide they want to "settle", is there a way to (in one fell swoop) print all the open transactions for that customer? I don't mean just the summary you can get from Receivables Transacting Inqury--Customer. I mean I want to print each open SOP document complete with all the line details (without opening each one, printing, closing, and going to the next one and repeating). Any a...

Custom scrollbars
Is there way to implement custom drawn scrollbars for standard controls such as treeview and listview? References to code samples would be greatly appreciated. ...

pivot table: create worksheetsheet using pivot table
While working in a pivot table, I accidentally created a new worksheet in my file with isolated data from the report e.g. pivot table shows all days of the month with totals for each deposit account... my 'accident' created a sheet with all the data for a single date. It turns out, this would be a useful tool for my manager, but we cannot reproduce my accident. My mouse was on the blitz and after a few solo selections the new worksheet appeared. Does anyone know how to do this (intentionally)? Please help. ...

Using custom fonts
Hi, I've been playing with this now for a while and it is starting to anoy me. I create my own font file (*.fnt win3.00 format), but no matter what i try, i cannot get the following font character codes to show... They always show as the "replace char with this char if not found in font set" character, no matter what control i try to use this font with! 0xHEX ( ASCII ) 0x80 (128) 0x82 -> 0x8C (130 -> 140) 0x8E (142) 0x91 -> 0x9C (145 -> 156) 0x9E -> 0x9F (158 ->159) All other font characters show up correctly without problems... Is there somthing i am mis...

Discrepancy with report and x/z tape for weighted items
We sell chocolates by weight at one of our stores and we have found that there is a rounding issue with this item, it processes correctly but at the time of closing the sales amounts on the x/z report do not match, it is usually a penny different but because of this the batch won't integrate to our accounting software (Great Plains). Does anyone know how to fix this problem? ...

Can Publisher create professional books?
Hi, I've been told that Publisher can't really format professional books and to try a Tex variation. Wondering about opinions on this. I don't want people to be able to distinguish any difference between a book I publish and any other book in a bookstore. Also, what version of Publisher is recomended for this? I am using one for Win95 and it can't suppress headers on final pages, which makes for stupid looking end pages. Do later versions have significant improvements for the book publisher and what are they? Thanks for your help. Robert -- -- Robert Pearson ParaMind B...

Print 2 reports
Hi, Is it possible to print 2 copies of my report using the following code? thanks. ************************************************* Private Sub Command27_Click() On Error GoTo Err_Command27_Click Dim strWhere As String If Me.Dirty Then 'Save any edits. Me.Dirty = False End If If Me.NewRecord Then 'Check there is a record to print MsgBox "Select a record to print" Else strWhere = "[WarehouseID] = " & Me.[WarehouseID] DoCmd.OpenReport "rptWarehouse", acViewNormal, , strWhere DoCmd.GoToRecor...