Search results for query: *

how to change lowercase text to proper case in crystal 8.5? eg. cat in the house -> Cat In The House

Good evening, I have created a report in crystal Reports 2008, which has two groups (date, and customerID). I need the report ordered by Customer Last name but the order for the report defaulting to the customerID. How can I get the report ordered by customer last name, which is not one of the...

Hello to forum users, I am a new user of VB.net and I need some assistance with designing and implementing a windows form that does the following: 1. Displays the master (employee name) information in a combo box pull-down at top of the form. NB I have this working. 2. Displays the detail data...

Hi all, I'm in the process of developing an interface in visual basic .net to pull data from an excel spreadsheet into ingres tables. I was able to view the ingres tables via ODBC but I have not been able to connect to the Excel speadsheet from within VB.net to read the rows of data into VB...

Hi there, How do I create a pull-down list field on a form to select data from a table? Do I have to write an sql select statement or does Access generate the list field for you in the wizard? Thank you for any assistance offered. wgg

Hi there, I am a new user to MS Access. I'm designing a table to store bid-header information and bid-details information. I see Access has an autonumber field type. The key field in bid-header is bid_id and I want it to be an autonumber. Provided I want to create a form that collects both...

I am designing a form with domino Designer and I am trying to validate my radio buttons. Now I have one radio button with three options. The option selected determines what is stored in another field. I am having a little trouble doing that. I was trying to write the code in the onclick window...

hi I have a database table workdates that has holidays with a type 'h'. HOw do i utilize this table so that my array reads only the holidays? I have used : beforereadingrecords; datevar array holidays:=[ date(1983,01,01), date(1983,11,30), date(1991,01,01),...]0 and hard coded the dates...

Good Morning All I have an audit trail report to produce and I need to find out if crytal report 8.5 can assist me. Is it possible to have 2 detail sections with each showing information from different tables? I have to produce an audit trail report, where the audit table contains the old...

Hi Guys I have a question and would appreciate any help which you can offer. I would like to print a report based on a group total. For example, possible output can be as follows. Transaction Cost A 200 B 500...

Hello everyone How do you create running totals in crytal? wgg

Hi I have an openroad application which uses Crystal reports (CRW32 8.5.0.217. Depending on which user enters the application/report i want to restrict the report only to that user's data only. eg. If User John Doe enters the report then John Doe should only see John Doe's related...

Hi all, I would like know if it is possible to create a macro to run a crystal report from the windows desktop. If that is not possible, how can a crystal report be executed from the windows desktop i.e. without running the report from within crystal Thanking you in advance wgg

Hi all How do you get the page number to appear on each page of a cross tab report( ie. generated from crystal)? wgg

Hi all How do you get the page number to appear on each page of a cross tab report( ie. generated from crystal)? wgg

hello all I am printing a report which puts every group on a new page. How can I get the page footer information to print on the last page with group data and not on the last page by itself. eg. This is what happens. Page 1 Name Amount customer A 200.00 Page 2 customer B...

Hello I am trying to print a report with data from the parent table and data from the child table on the same detail line. As is expected, the parent table information is repeated for as many records as the corresponding child record. Is it possible in Crystal to suppress the parent table...

Hello All I would like to know if it is possible to get records printed in Crystal, which fit the following kind of 'not exists' condition. ****Example**** Select id1, name1 from table1 a where not exists (select id1, name1 from table2 b where b.id1 = a.id1) *** NB I would like the records...

Hello All I would like to know if it is possible to get records printed in Crystal, which fit the following kind of 'not exists' condition. ****Example**** Select id1, name1 from table1 a where not exists (select id1, name1 from table2 b where b.id1 = a.id1) *** NB I would like the records...

Hello All I have created a report with parameter fields FromDate and Todate. Hence the report prints transactions which falls within these date ranges. I've also inserted a subreport which requires the same parameter fields, but the subreport does not pick up the parameter fields unless I...