Search results for query: *

Hi All, VB6, Crystal 9, Win XP. I have a VB6 application for collecting and reporting sales data. Initially everybody could log in with Administrator Rights to the PC and the reports would run fine. Recently, I created user accounts so that some can log into XP as Administrators and others as...

Am getting some output but the rows are running upto the first month in the database to the last month in the current year ie 01/01/2003 upto 04/2006. The columns are ok ie 2003,2004,2005 etc This is what am getting 2003 2004 2005 2006 01/2003 02/2003 03/2003 etc 11/2003 12/2003 01/2004...

Hi All, Cystal 9, Access2000 I have tried but cant figure how to go about this. The report is to show annual sales, month by month over a period of say five years, then graph the output. In mind is a report that looks like; 2006 2005 2004 2003 etc Jan $100 $900 $600...

Cystal 9, Access 2000. I am trying to run a comparisson of current year vs. last year, month by month. Please help on how I can achieve the following, What I have on the crosstab 12/2005 11/2005 10/2005....12/2004 11/2004 10/2004 Units 5000 4800 6000 6000 4500 4600...

This link was passed on by Lbass. I found it quite helpful. http://support.businessobjects.com/communityCS/TechnicalPapers/cr9_charting_print_time_formulas.pdf.asp

Thanks LBass. Looks like I have a long way to go.

Lbass or anyone who has tried the sample using the above link, I have tried it with the Xtreme DB and it works fine. Am still trying to implement it in my report. One question, the formulas on the main report, @onchangeof and @showvalue when viewed from the sub report are now parameter fields...

Lbass, Thanks a million. The article is Crystal(9?) Clear and it also explains why the field is not available. You deserve more than a star! Cheers!!!

Sorry am back on the same report.. The figures are reporting correctly and now I want a graph to display the parcentages.The formula is Percentage=whileprintingrecords; if {@actualpaperused}<>0 then ({@actualpaperused}-{@actual})/{@actualpaperused}*100 @actual=whileprintingrecords; shared...

Lbass, Gary, Thanks for the hints. After placing the sub report in the department group header, the main report was still reporting the same figure ie 400. The main problem was with the link because after putting a check mark on the "Subreport Link" form and selecting "Select Data in Subreport...

Sorry, the main report is also grouped on Departments. This is what I get.. Department1 105 400 Depaerment2 160 400 Department3 408 400 The 400 is being returned from the sub report. There is only One Group, Department.

Am having a problem with a shared variable and hope somebody can help. I have three tables invheader,invdetails, meterreadings and departments. The sub report takes the quantities of different photograph sizes and calculates the total area of all photographs as follows. whileprintingrecords...

Hi all. Am very new to crystal and what I want is to display percantages from two crosstabs on a text field. This is the format; item1 item2 item3 item4 Total Department1 100 50 60 0 210 Department2 10 20 30 20 80 Department3 20 20 100 0...

Hello all. How can I make a column in DBgrid disabled. ie i have 5 columns; ItemCode: ItemDescription:Qty:UnitPrice:Total After typing the itemcode and hitting enter, i would like the cursor to jump straight to the quantity field. The ItemDescription,UnitPrice and Total columns are locked cos...

Somebody pls help. Am trying to develop a simple invoicing system using VB6 and access 2000. In access I have 3 tables, (1) Products which has ProductID, ProductDescription Qnty and Unitprice. (2)Invoiceheader with Invoice details,date, Customername etc. and (3) invoicedetails which requires a...

Vidru, thanks a million. Thats just what i wanted. It works fine.

Thanks Katy44 but it looks like this gives the grand total.

Somebody pls help. am new to crystal 9 and what i want is to print TOTAL in each page footer. The data is from Access 2000 database. eg 1. Mr XYZ 200 2. Mr. WXY 200 . 500 . 300 . 100 PAGE1 FOOTER TOTAL 1300 36. Mr. GTF...