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!

Register Log in
  • Congratulations wOOdy-Soft 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: *

  • Users: jhermiz2
  • Content: Threads
  • Order by date
  1. jhermiz2

    easy help..but not so easy for me!

    In my vb application I have created a crystal viewer... I allow the end user to select a customer from my own combo box in the application..and I do the following vb code 'Proposals report Case "rptProposalInfo" If frmReports.cboRptQuoteNumbers.Text = "" Then 'no quote...
  2. jhermiz2

    Help Formula!!!!

    In my select expert I need to include a lot of conditions... but its not working..or it works on some and not all... Here it is: {TBLLABOR.ACTDATESTART} in {?Start Date} and if {?FunctionalGroup} = "" then True else {TBLEMPLOYEE.DEPARTMENT} = {?FunctionalGroup} and...
  3. jhermiz2

    dont show first record of each employee...

    I'm doing a report on labor hours by week. I select a date range and it does it by week...but for instance I select Feb 16 till March 8 and it shows week 7,8,9,10...I want to skip week 7 for EVERY employee...but I cant. I tried to suppress on that section using: OnFirstRecord but it only works...
  4. jhermiz2

    grouping it.

    We had a contractor a long time ago come in and create this wonderful beautiful report which showed labor hours by date range. The problem is it totals all the hours for Monday, Tuesday, etc. For instance I choose Jan 1, 2004 till Feb 1, 2004 as a parameter entry. It gives me the total hours...
  5. jhermiz2

    bad print outs...

    I've noticed anytime we print to a certain printer in Crystal it comes out very bad. It is not readable text. The numbers come out right, but the text itself is VERY bad...It looks like another language almost... The drivers are installed on the client. What could be causing this? Jon
  6. jhermiz2

    this message...is no good!

    Everytime I open this one report I have I get "The Saved Data Will Be Discarded Since One or more formulas failed to compile." But I compiled all my formulas with NO errors... I need to get rid of this message. Jon
  7. jhermiz2

    Suppressing dynamically based on user reqs.

    My boss wants to have a summary report showing just totals and a detailed report showing some details. I created the details report and rather than creating another report can I create code to suppress the five fields that are in one of the sections and just show the totals? I would want the...
  8. jhermiz2

    very simple parameter ?

    I created a parameter called "FunctionalGroup" to allow managers to limit the records returned by a functional department from our company. Works fine if the user selects a value for this parameter.... But I want it so that if NO selections are made to show ALL functional groups. Do I need to...
  9. jhermiz2

    weird problem...

    I have a report showing labor during the week. It just takes the daily days in hours and shows the totals for each department. I have noticed one problem with two employees (father and son) both the same last name. The report does not seperate these two individuals, but it does seperate...
  10. jhermiz2

    new aspeer...having a problem here!

    I tried this... <html> <body> <% '---Dim the variables Dim Conn Dim rs Set Conn = Server.CreateObject(&quot;ADODB.Connection&quot;) Set rs = Server.CreateObject(&quot;ADODB.Recordset&quot;) Conn.Open &quot;Driver={SQL Server};&quot; & _ &quot;Server=HERCULES;&quot; & _...
  11. jhermiz2

    need new page...

    Ok 4 subreports... Problem is after a record in the subreport I want to make sure I go to a new page... So I thought I had it right but one particular record from one subreport does not go on a new page... Anyone with ideas on why ?
  12. jhermiz2

    Suppressing a label

    How do I suppress a label based on a field being null / not null. I have a label that says: &quot;Description:&quot; [FIELD] If FIELD is null I want to suppress it. I tried right clicking on &quot;Description&quot; label and selecting &quot;Format text&quot; Then on the &quot;Common&quot...
  13. jhermiz2

    select printer?

    When I design a report in Crystal it saves that printer that it was designed in. When I use my viewer in my app to print the report and I click the print button it does not allow me to change my printer. So being logical...i changed my default printer and clicked the print button again...only...

Part and Inventory Search

Back
Top