Recent content by fisheromacse

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

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

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

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

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"...

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

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

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;

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

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

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.

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?

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

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 & ", " &...

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