Search results for query: *

Hi jay, Can you post some macros that you written? I find the code that the macro recorder produces is cumbersome and clutterful. It is the same with Excel VBA macro recorder. Thanks.

I am newb to ACCPAC programming (and programming in general) and I am looking for information on ACCPAC ComAPI. I know of some of methods like browse and fetch but I would like a more complete list along with how they should be used logically matter. Does anybody know where to find this...

Hi jay, It says i do not have permission to the url. I heard that there is an object model in the tech support area... if you have access, would it be possible to get that information? I understand if you dont want to. TIA metalgears

Anybody have any recommendations for a good book relating to the Accpac object model? TIA metalgears

This array formula works fine on main report. The counter "i" increments and the array gets populated. The customer orders are aggregated together by customer name. When I put the same array formula in the subreport, the counter "i" stays at 1 and does not increase. The array does not pick up...

DOH! That was it. Thanks again, Rosemary.

Hi Everyone, dim i as number dim str as string for i = 1 to 4 str = str + cstr(i)+ chr(13) next i formula = str This simple formula field returns 1 I want it to return 1 2 3 4 if I take out the chr(13) i get 1234 I am using CR 11. TIA

Thank you for the link Rosemary. There was alot of good smples to run.

Hi Everyone, CR 11 Is there a way to loop through the Details of a report and put them into a array? I want to gather all the details output and do some work on them. TIA,

I have no groupings on the subreport. The two fields apply to both the project name and project category. I.E. field 1 field 2 Project Name Project Category 100 1 Acme Category 1 The two fields are not displayed, only the Project Category. The...

Hi MisterMo, I did what you recommended. I created a category group on the sub report and put the category field and the sum of the amounts in the group header suppress the details. But when I ran the report, it still show the categories as separate. I think because the sub report treats each...

Hi Madawc, I am very new to Crystal Reports so I may not explain everything very well. In Accpac, we setup up optional fields for GL Entries. So after an account is entered, you then choose a project name and then a project category from a drop down box. In the main report, I have it group...

Hi all, I have a main report with a sub report linked by a sequence number field. When I run the report there are multiple instances of the same item in details of sub report because the sub report displays items by sequence numbers. Is there a way to summarize the items that are the same in...