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 gmmastros 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. fisheromacse

    Cannot connect to any ODBC datasource with MS SQL Server data in crystal

    TOAD is a database tools program. https://www.toadworld.com/
  2. fisheromacse

    Using one parameter to select multiple values

    I do not have crystal in front of me right now, but you would use something like this in your selection criteria (sorry for any typos/errors): If YOURPARAMETER = '21' then locationtype in ('1','2','3','4') else locationtype = YOURPARAMETER
  3. fisheromacse

    Same field on two tables, merge into one field on report

    I think you could create a formula something like: {@FormulaName} If isnull({sales.FieldName})=TRUE then {returns.FieldName} else {sales.FieldName}
  4. fisheromacse

    How to broadcast data from a SQL server to an IP an Port

    I think the 'refresh' would be done on the end receiving the data, not on the SQL server. The SQL server would just provide the data via SSRS. something like this https://stackoverflow.com/questions/19807665/auto-refresh-for-every-5-mins or this...
  5. fisheromacse

    If AND then else?

    You should not have to make any changes come February. The month will not be 01 so the year will be year of the current date. It looks like the Report select formula you already have should almost work without any need for my previous post. If ({PR_EmployeeTaxHistory.CalendarMonth} = "01"...
  6. fisheromacse

    If AND then else?

    I think something like this should get you just the year or the year-1 which you could then use in selection criteria. I would use variables, but depending on your case use they might not be necessary. {@YearChange} whileprintingrecords; numbervar qtrsel; If...
  7. fisheromacse

    Parameter / Record Selection option to include or exclude NULL values

    I think this may help. For your Categories in the parameter, use the word 'Null'. Then in your select/formulas if the word 'Null' is selected perform the null check. Something similar to below but with your actual criteria/database Create a parameter --{?Param} values = Yard, Stock, Upper...
  8. fisheromacse

    Date Parameter for prior 3 month

    I think i would use the below (typed from memory and untested today) RecStartDate := dateserial(year(currentdate),month(currentdate)-3,1); RecEndDate := dateserial(year(currentdate),month(currentdate),1)-1;
  9. fisheromacse

    Pulling data out of a string

    Just a quick untested thought: {@PackSize} whileprintingrecords; stringvar origval := lowercase({tblProduct.Description_1}); numbervar lookupnum := instr(origval,"pk"); stringvar gotit; IF lookupnum > 3 then gotit := right(left(origval,lookupnum+1),4) else gotit := "1pk"; gotit
  10. fisheromacse

    I want to use Dreamweaver

    i have started using OpenElement http://www.openelement.com/ for website design, and while not as simple as Blue Griffin http://bluegriffon.org/, OpenElement does have better features for managing related pages
  11. fisheromacse

    Calculating Date Diff for timestamps in same field

    If sorting by event number then by date and doing a datediff using previous or next will not work, then I would try adding the table a second time and joining the table on the event number field. It would still require some formula logic to be written but seems quite possible.
  12. fisheromacse

    Export report - Group per Date(months) and display all months even will null values

    Are you able to join the same table to the report a second time and use the date field as your 'master list' of dates?
  13. fisheromacse

    Formula to remove bracketed text

    If you just want to remove the characters, I would probably use 'Replace' in a pair of formulas. {@ReplaceLeft} Replace({EstDescription.Description},"(",""); {@ReplaceRight} Replace({@ReplaceLeft},")",""); disregard the above....i reread the question and see that you want to remove the text...
  14. fisheromacse

    Passing multiple values from subreport to main report to be used in another subreport?!

    I think you could use a stringvar without the array...something like this...manually create a delimited list: Whileprintingrecords; Shared Stringvar AllLotNo; If (PreviousIsNull({F4111.ILLOTN}) or {F4111.ILLOTN} <> previous({F4111.ILLOTN})) then AllLotNo := '' else AlLLotNo := AllLotNo & ", " &...
  15. fisheromacse

    Passing multiple values from subreport to main report to be used in another subreport?!

    i think you can adapt Hilfy's answer in this post to meet your needs. http://www.tek-tips.com/viewthread.cfm?qid=1770377 to copy/paste with my thought........ Create a formula that will store the dates to an array - something like this: WhilePrintingRecords; Shared DateVar Array shipDates...
  16. fisheromacse

    Field Limting

    you will want to insert a group on the ticket number (the '{Table.TicketNo}' in Pete's reply is a placeholder which you will replace with the actual table/field names) Place your detail info in the group header and suppress the details section. It should show the first 'set' of info in the...
  17. fisheromacse

    Display Max Values in Report Header

    i am not sure i fully understand what you are trying to accomplish, but you may be able to place each value in it's own subsection and then use a formula (something like: "({Max of Command.STATUS_DECS_1})=TRUE" ) in the section expert to suppress the null value rows.
  18. fisheromacse

    Group supression

    i would try this (and it should work if the fields are in separate tables, as i expect they will be): insert a group on the patient create a summary of the allergy codes field (use a Count) create a sumamry of the allergies field (again, use a Count) in the section expert, suppress the...
  19. fisheromacse

    Group supression

    are the fields all in the same table?
  20. fisheromacse

    Last two weeks code

    i am probably not giving this the necessary amount of thought, but just off the top of my head, try the below instead of "DateAdd("d",-14,CurrentDate)" (Date ({CallLog.RecvdDate}) in [DateAdd("d",-14,CurrentDate) to currentdate])

Part and Inventory Search

Back
Top