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 ...

Thanks for the solutions.. I changed the font and increased the margin but still can't seem to fit it all into 1 page. The Text goes onto the next page The text still appears longer, I am trying to figure out a way to widen the text ?

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...

That does not work. It displays the heading again and my text starts on the details section.

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...

I need for the text to appear after my page footer. When I put it on the report footer it seems to overlay onto the details section. Still need some help with this.. Cheers.

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...

My subreport falls into the details line and therefore I had to segregate it onto Details a and Details b. My total should fall into a GF#2 I am not getting my desired results, instead there is a cumulative count. Please suggest.

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...

It looks like the "Work" column works well but shows everything in hours. Is it possible to show the "Work" column details in Days instead of hours ?

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 Lbass, When I try to save the formula,it gives me a message stating "A number is required here" on this line : left({table.field}," &") else

Thanks lbass. You got me on track to figuring out what was wrong..

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...

Those were placed on Detail C The running total was placed on Detail C without any Evaluation or Reset Options.