Search results for query: *

Crystal reports 11 I am incorporating some number fields into a formula. E.g : Batch number - 110 Entry number - 1 Sequence number - 1802 My formula is : Batch number&"-"&Entry Number&"-"&Sequence number I want my result to look like this 110-1-1802 However, it appears as ...

Crystal reports 11 MS SQL Server 2005 I have placed a large volume of text on the last page of a report. It is a sales invoice format and the terms & conditions of the deal are on the last page. I am trying to fit it all onto the last page but the only way I can see now is to shrink it to a...

Crystal Reports 11 MS SQL Server 2005 I have a form designed in crystal reports. The form is designed in such a way that if more than 20 lines appear on a single page, it repeats the balance lines on a new page. On the new page the header details appear again. I am trying to put a page full of...

ACCPAC 5.3 Windows Server 2003 Terminal Services MS SQL 2005 I have created a custom report in Crystal utilising tables from Peresoft Cashbook. I have placed my report on the ACCPAC desktop but when I try to run the report I get the following error message : Logon Failed Details : Cannot find...

Sage ACCPAC ERP 5.3 MS SQL The physical stock counting function in ACCPAC involves generating a worksheet, updating it and then posting it. Can the posting be made to work using the location override feature in ACCPAC ? i.e can the transactions be posted to the adjustment write off GL...

Crystal reports 11 I have created a customer invoice format using crystal reports. At the end of the report I need to put in a page of terms and conditions. When I put this page full of text,crystal gives me an error which says text is too big for the group header. How can I put in the text...

Hi, I am using Crystal XI and I am trying to perform a split function. My data field is looks like this: (e.g) A01-Admin D001-Dorm Z1-Temp I would like to split it as "A01" on a separate column in my report and "Admin" on a separate column The formula I used was split (field,"-")[1] to get...

Hi, In Crystal 11. I am trying to consolidate an amount field based on Year to Date figures. My MONTH and my YEAR fields are separate. If I wanted to get the figures only for the month it would be simple as I can link my parameters directly to show a particular MONTH and YEAR. But how do I do...

HI , I have a subreport which gives a summarised total of a set of values. Now I need to get the total of that sub report. Example A 100 Total (Subreport) B 50 Total (Subreport) C 20 Total (Subreport) D 300 Total (Subreport) Need to get total of these above What is the best...

Hi, My tasks look like this : +Implementation 15.38 days -Database creation 5 days -Installation 1.38 days -Payroll Implementation 3 days -Other Implementation 2 days The total calculated is based on the days range and that amounts to 15.38 days...

I have a formula which sorts transactions based on criteria I have specified in a formula, that formula is the group # 1 header. An example of my formulas there is as follows : if {?YEAR YYYY} = "2008" and ({@dept} in ["100"]) then 01 else if {?YEAR YYYY} = "2008" and ({@dept} in ["200"])...

Hi , I have a field which contains data in the following ad hoc manner, here are some examples : Type # 1 John Smith<br>9 days at $1,800/day Type # 2 System Implementation - Peter Jones & Paul Simpson<br>Period: 15/11/08 to 28/11/08 Type # 3 Market Operations Management Improvement - David...

Hi , I have data which appear as follows : Amount Consultant's Name XXXX Description Reimbursable expenses XXXX Example is as follows : Adam 1000 Consulting for march Reimbursable expenses...

Hi, I am trying to modify a standard Invoice report created by someone else: The report heading are as follows : Description Amount Tax amount The following groups exist : Group # 1 - Customer Group # 2 - Invoice or Entry Group # 3 - Detail Group The following details exist : Details a...

I have a report which I now want to incorporate into another main report as a subreport. The report has uses parameters YEAR and PERIOD. The YEAR parameter is linked to a field in the database and I can use selection criteria but the PERIOD is used in a formula field. How can I get a formula...

My problem is as follows : I have a a database of chart of accounts with the following 3 segments: 10000-000-A 10000-100-A 10000-200-A 11000-100-B 11000-900-B Account - Department - Category I need to sort them by the following criteria : 01 All items ending in category "R" and all items...

Crystal 11 I have a table which contains main headings as follows : 01 Tables 02 Chairs 03 Sofa 04 Lamp These are linked to transactions tables. When I run the report,the report displays as follows : 01 Tables 100 03 Sofa 55 *Crystal is suppressing the null values from the...

Hi, ACCPAC 5.4 All modules including Lot tracking. All latest Service Packs. The users have accidentally allocated 5 units of an item. Now they want to sell the 5 units but cannot because they are classed as unallocated. Is there a way to unallocate those ?

Does anybody know the Difference between using an MS SQL ODBC SQL Server and a SQL Native Client ODBC ? In what instances are each one used ? Which one is better ?

Hi , I did a Data conversion ACCPAC from 5.0 to 5.4 but the Inventory Transactions detail for IC Receipts, IC shipments and IC adjustment entries are missing in the entry forms as well as in tables. The History details are intact!! Before the conversion in the 5.0 database, the posted...