Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Prompting for username/password before creating dynamic parameter
Sounds like I might have similar problems. Report created with parameters and then compiled and distributed to another PC. That PC asks for a logon defining.... ODBC MSAccessDatabase User name prefilled as admin Password blank My techie guys are unfamilier with this (as am I) saying there is no...- 2CsDavid
- Post #10
- Forum: Business Objects: Crystal Reports 2 Data Access
-
Display data where one field is blank (null?)
JobID is in both tables and used as the link. But the Job No. (as distinct from JobID) is the field I am reporting on in Table 1, The hours field is in Table 2- 2CsDavid
- Post #9
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Display data where one field is blank (null?)
ODBC - both tables have Field 'JobID' and have lineds these by left clicking mouse on 'JobID' in Table 1, dragging over to 'JobID' in Table 2. This places and arrow between the two. To date its the only way I have ever known to link tables. However, I note that at the foot of the links tab...- 2CsDavid
- Post #7
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Display data where one field is blank (null?)
Nope, none of that has worked. I am running Crystal v7 Picked up 2 access database tables (call them T1 and T2) T1 has field 'Job No.', T2 has field 'Hours'. The 2 tables are joined properly. I want to see a list of all job numbers even if no timecard type data (hours) has been entered in the...- 2CsDavid
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Display data where one field is blank (null?)
Report created with fields: {Job No.}, {Job description}, {Hours quantity} If there is no data in {Hours quantity} the other 2 fields are not listed but I want to see them on the report with the {Hours quantity} giving a zero (i.e. 0.00) answer. Have tried using the Display Null options but do...- 2CsDavid
- Thread
- Replies: 8
- Forum: Business Objects: Crystal Reports 4 Other topics
