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: *

  • Users: HRHK
  • Order by date
  1. HRHK

    display date range

    Thanks k, got it working with formula you provided. ' Create parameter objects Dim myParams As ParameterFields = New ParameterFields Dim myParam As ParameterField = New ParameterField Dim myRangeValue As ParameterRangeValue = New ParameterRangeValue ' Set the ParameterFieldName to the name...
  2. HRHK

    display date range

    Created StartDate and EndDate parameter fields in Field explorer and it works. But the Enter Parameter dialog box pops up. How can the dialog box be avoided and instead use the param that I pass? Thanks.
  3. HRHK

    display date range

    I am using CR 9. How can I display parameters in textbox or formula? Thanks. I am doing following: Case "Customer" Dim crReportDocument As Customer crReportDocument = New Customer ApplyLogOnInfo(crReportDocument.Database)...
  4. HRHK

    display date range

    In CR, I have users select start date and end date and build query using this date range to populate a reporting table. What I like to do is display this start date and end date in report header. How can I do this? Thanks.
  5. HRHK

    how to suppress sub-report in another sub-report

    It hides the Text_PageHeader in the fax FaxCoverLetter which is good but I would also like to hide Text_PageHeader in following situation. for eg. if a customer (group by customer and customer_contact) has more than 1 page of report, then the Text_PageHeader re-appears in the next page. I would...
  6. HRHK

    group by and order by clause

    makes sense. Changed group by Item Desc and it works. Thanks k.
  7. HRHK

    group by and order by clause

    Order # is same as OrderID. I want to group by Order but sorted by description. I cannot find Report->Sort Order. It is CR 9. Thanks as always.
  8. HRHK

    group by and order by clause

    In CR, I have 3 groups. Group by Customer id, Contact id, Order id. Below Group by Order id, I want to display Order#, Item Desc. I would like to display by Item Desc in ascending order. Currently it is displayed by Order#. How can I do this? Thanks.
  9. HRHK

    how to suppress sub-report in another sub-report

    Thanks k as always. It worked out great!!
  10. HRHK

    how to suppress sub-report in another sub-report

    I got two sub reports Text_PageHeader and FaxCoverLetter in a report. Text_PageHeader is in Page Header section and FaxCoverLetter is in group Footer section. FaxCoverLetter will always be in new page. Currently Text_PageHeader sub-report appears in every page, but I want to suppress this...
  11. HRHK

    calculate age

    How do I correctly calculate age from data of birth in CR? I can do following in Access but CR doesn't recognize the format function. Thanks. DateDiff("yyyy",{my_age.birth_dte} , Now())+Int(format(Now(),"mmdd")<Format({my_age.birth_dte},"mmdd"))
  12. HRHK

    string concat problem

    I have problem with string concatenation that I need some help with. In the following SQL, I concatenate the contact first name and last name. I fill it in dataset and bind it to datagrid. The problem is if there's no contact name, it inserts a blank string (i.e. a space that I used in...
  13. HRHK

    black object b/w listview headers

    In Control Panel, the mouse setting has Normal select.
  14. HRHK

    black object b/w listview headers

    it didn't work, how can I check the mouse setting of your OS?
  15. HRHK

    black object b/w listview headers

    In listview control, when I hover mouse between the column headers, it displays black object (square). I tried changing the cursor property, and played with various properties, it didn't help. Any suggestions will be appreciated very much. Thanks.
  16. HRHK

    get summary from sub report to main report

    Got it working by passing login info to subreports. Dim crSections As Sections Dim crSection As Section Dim crReportObjects As ReportObjects Dim crReportObject As ReportObject Dim crSubreportObject As SubreportObject Dim crReportDocument As CrystalReport1 Dim...
  17. HRHK

    get summary from sub report to main report

    Thanks LB, got it working. I am using CR that comes with Visual Studio.Net 2001. Another small problem surfaced since I began using sub-report for this report. Login dialog prompting for userid, pwd, db, server shows up. I have the following routine that used to work when there was no...
  18. HRHK

    get summary from sub report to main report

    how can I get Amount summary from sub-report to group header in main report? Thanks.
  19. HRHK

    having problem displaying phone &amp; fax in page header

    Hello again, I added a subreport and put it in the detail section in the main report. Strangely, the subreport appears more than once in the main report. What could be the reason? Thanks.
  20. HRHK

    Add items in combo box

    Ran it w/o breakpoints, same result. The items are there, just seeing blank instead of "LName"/"FName". I changed the cb property dropdownstyle to dropdownlist, but it didn't help. HELP!

Part and Inventory Search

Back
Top