RDL's / EmailINvoice / EmailStatements |
Post Reply |
Author | |
peach
Admin Group THE BOSS Joined: 01-Jan-2006 Status: Offline Points: 1295 |
Post Options
Thanks(0)
Posted: 11-Nov-2013 at 15:21 |
Adding a field to an SQL report from a table that is not in
the report. I want to add a customer’s Fax No to the Invoice layout but
the Layout does not contain the Customers Table, therefore I have to add a join
command to the Customer Table from the PBSTRANS dataset. To do this you add a left join into the query which calls the
fields from PBSTRANS, (datasets) that are available. The left join will connect
the FAX field from the Customer Table. HOW TO: When you open the report in MSQL ReportBuilder, the Datasets
are down the left side of the workspace. Pick a table that you want to join the
new field too. Here is an example of a Left join to call up the Branch
Email address from the CSGN.area field. trim(BranchEmail) as BrchEmail from (pbstrans left join
csgnarea on pbstrans.area = csgnarea.area) aSo to call up the Customers fax number from the customers table
Ill add the following trim(BranchEmail)
as BrchEmail, customer.fax from ((pbstrans left join csgnarea on
pbstrans.area = csgnarea.area)left join customer on pbstrans.custcode =
customer.custcode) **The trim
command above is how you change the name of the dataset as it
appears in the list of datasets. ***Adding another table to the dataset may mean that some of the tables referred to elsewhere in the query need to have the table they refer to put before them in case of confusion…. E.g. select id, invno,
duedate, custcode Once done click the Explanation mark to ensure the
query runs without errors. So OK to the Query screen and you should be able to
find the Field (fax) in the PBSTRANS dataset now. Edited by peach - 11-Nov-2013 at 15:25 |
|
peach
Admin Group THE BOSS Joined: 01-Jan-2006 Status: Offline Points: 1295 |
Post Options
Thanks(0)
|
The PBSRPTWS.MDB is in the c:\pbsvb\peachonline\reports folder. Ignore the one in the PBSVB Folder.
|
|
peach
Admin Group THE BOSS Joined: 01-Jan-2006 Status: Offline Points: 1295 |
Post Options
Thanks(0)
|
New Program: NetPrint.exe Controls printed documents Netprint.exe now prints RDLs from: POS / IE / SO / CO Screens, as long as you have an RDL layout in setup business > Layout files. Here are a list of current layouts you can use as a base, however rename to 4 characters first, eg: InvLayP.rdl = InvL.rdl Invoice = InvLayP.rdl (portrait) InvLayL = (Landscape)
New POS Docket Layouts in RDL format : (New field in setup business > layout files > Docket Layout [top right corner]) · DKT_FULL.rdl …………………… (Prints LineNo, Part, Descr, Qty, Price, Nett) · DKT_Desc.rdl…………………… (Prints Descr, Qty, Nett) · DKT_AP.rdl………………………… (same as DKT_FULL, just with Autopro Logo) Please update to latest 99801.exe + then download netsute.exe on your own machines, and test: 1. Netmail.exe 2. Netstmt.exe 3. Netprint.exe If you are to upgrade a client, please confirm with Rob or myself first. Edited by peach - 20-Aug-2014 at 09:49 |
|
peach
Admin Group THE BOSS Joined: 01-Jan-2006 Status: Offline Points: 1295 |
Post Options
Thanks(0)
|
1. Don't run any reports from within the report builder as this will lock the database.
2. Reports are in c:\pbsvb\peachonline\reports
3. We don't make custom reports, just improve on what we have but ask Rob First.
Interactive Sorting on reports......
1. Open Report in the Report Builder
2. Right Click on the field that you want to be able to sort and select Tex Box Properties
3. Click Interactive Sorting
4. Tick the option to sort
5. Select the field that you want to sort
6. In the bottom box select Tablix
Save and close.
|
|
Post Reply | |
Tweet
|
Forum Jump | Forum Permissions You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |