My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

Go Back   SellerDeck Community > Knowledge Base > Order Processing > Reports

Search powered by Google
Register FAQ Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Search this Thread Useful Thread? Display Modes
  #1  
Old 22-Nov-2009, 10:27 AM
KB KB is offline
Administrator
Join Date: Nov 2009
Posts: 1,012
Thanks: 0
Thanked 34 Times in 29 Posts
Can I add my own user-definable (custom) report into the list of available reports?

Yes. Firstly you need to save your custom report in the SellerDeck installation directory* (you will see all of the other .rpt files that SellerDeck uses there).

Next, you need to edit the file called ‘Reports.ini’ with a plain text editor, which can be found within the site** folder (If there is only one site within the software it will be called 'Site1', if there are multiple sites within the software you will need to browse to the site folder name corresponding to the current site you are using).

At the top of the file are a detailed set of instructions and parameters then the bottom of the file is divided into 'sections' these are names surrounded by square brackets, groups of parameters that instruct the software how to present each one of the files grouped below it.
There is already a main section included within the file called: -

[Reports]

and everything must appear below that.

Therefore to include your report you would need to add a section name for that report, firstly we have to make a declaration of that section, so a section called 'ArbitraryName' would look like this: -

ArbitraryName="My Reports"

The text to the right of the declaration ("My Reports") would be displayed in the report dialog box within the software and would be what you click on to select the report.

Once you have made the declaration you can add the section and name of the report. In this example that would look like this: -

[ArbitraryName]
ReportName=MySpecialInvoices.rpt

This gives the section name and uses the parameter 'ReportName' with the file name of the report that you have created. Together they will look like this: -

[Reports]
ArbitraryName="My Reports"
[ArbitraryName]
ReportName=MySpecialInvoices.rpt

This is the bare minimum required to add the report and display it in the 'Report Selection' dialog in a tab called 'User Defined Reports'.

Here is an example of a report using some of the parameters available: -

[Reports]
TransactionsSummaryByReferrer="Transaction Summary by Referrer"

[TransactionsSummaryByReferrer]
ReportName=ME_TransByRefV6.rpt
FromDate="Select &From:"
ToDate="Select &To:"
TestedDate="orders.date ordered"
PromptID=4
PromptPhase=1
SelectionFormula=
ExtraConditions="{Orders.bOrderIsDeleted} = false and {Orders.nPaymentStatus} <> 8 and {Orders.nPaymentStatus}>0"

Here is a brief outline of some of the parameters available: -

[Reports] : A section that lists the user defined reports and references a section giving the report details.

[TransactionsSummaryByReferrer]: the section for this report

ReportName: the file name of the report. The file must be in the main catalog installation directory*

FromDate: displays the date prompt in the reports dialog box for the 'from date'

ToDate: displays the date prompt in the reports dialog box for the 'to date'

TestedDate: the Crystal format date field to test

PromptID: prompt id for report string

PromptPhase: prompt phase for report string

SelectionFormula: selection formula for the report

ExtraConditions: extra 'where' clause conditions

PLEASE NOTE: Unfortunately, you cannot make a custom report work with the Catalog items or orders currently selected within the software.

*This is the 'SellerDeckvX' folder (where X is replaced with the version of the software) under the 'Program Files' folder.
** Depending on the installation option chosen or operating system used, the 'Site' folder can be found in either 'My Documents', 'Documents', 'Shared Documents' or 'Program Files' in the folder 'SellerDeckvX\Sites\' (with X replacing the version number).
Reply With Quote
  #2  
Old 05-Dec-2016, 11:46 AM
rookers rookers is offline
Registered User
Join Date: Jan 2003
Full Name: Jez Hall
Posts: 261
Thanks: 14
Thanked 4 Times in 4 Posts
OK I have now finally got round to looking at this again and it works, I have added a section to reports.ini called

[AltReports]

as instructed in the instructions at the top of the ini file. Then added

PackingList=orderssticker.rpt

which is my modified version of orders.rpt, formatted to print a sticker label.

But how do you define the name that appears on the button? Which I click Packing List, the new report is there and works, but it is called "Alt Packing List Report". I want to rename it.

How ?
Reply With Quote
  #3  
Old 06-Dec-2016, 12:04 PM
Duncan Rounding's Avatar
Duncan Rounding Duncan Rounding is offline
Administrator
Join Date: Sep 2005
Full Name: Duncan Rounding
Posts: 10,258
Thanks: 117
Thanked 458 Times in 415 Posts
I don't think you can. I presume you only want to print this sometimes rather than all the time?
__________________
SellerDeck/Actinic Report Modifications - Add your logo to your invoice - email for information
Integrated e-Commerce Web Design
SellerDeck/Actinic Upgrades, Custom Designs, Layout Modifications and General SellerDeck/Actinic Help
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 02:25 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.