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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. suave2damax

    Web preview size not the same with Crystal Designer preview

    Hi Naith, Thank you so much for your reply, Naith. [smile] I've finally stumbled upon a solution to my problem. The init parameter in the URL that is used to invoke a report can accept certain values that determine which type of viewer you'd like a browser to use in displaying a report. The...
  2. suave2damax

    Web preview size not the same with Crystal Designer preview

    Hi Naith, I believe it's the Java plug-in viewer. (By the way, is there a way to specify in CR the type of viewer a report is to be previewed with over the Web, i.e., ActiveX, Java, or DHTML? just curious...) If it's to be of help, the same printer driver is installed in our IBM Websphere...
  3. suave2damax

    Web preview size not the same with Crystal Designer preview

    Hi everyone, I have a report which needs to be previewed over the web. It involves quite a number of columns of data that it required custom sized print page: 11x17 - Landscape. Viewed with the Crystal Designer, everything is ok. However, when viewed over the web, the web preview is not sized...
  4. suave2damax

    Adding All Records for an Employee

    Hi, Place the DSum function given to you inside the nz() function: =nz(DSum("WeeklySalary","tblWeeklySalary","EmployeeNo=" & [Forms]![frmEmployee]![EmployeeNo]),0) That should do it.
  5. suave2damax

    Adding All Records for an Employee

    Hi, Placing the DSum function given to you inside the nz() function: =nz(DSum("WeeklySalary","tblWeeklySalary","EmployeeNo=" & [Forms]![frmEmployee]![EmployeeNo]),0) That should do it.
  6. suave2damax

    #Delete in Subforms

    JPhillis, Try checking the tying Link Child Fields and Link Master Fields among the forms (main, subform1, and subform2). I believe there is where the cause of the prob lies. Now, provided you have settled the link field issues, try placing a me.requery line in the After Insert and After...
  7. suave2damax

    Query Expression where one field is greater than another

    Hi, guys! (",) Well, both of you dawnd3 and rajeesh are correct in that both of your suggestions would yield to the same set of records: "record(s) of those who's Total_amt is greater than the Access_amt". You can either plug the working query or the SQL equivalent of that query...

Part and Inventory Search

Back
Top