Recent content by bradlee27514

Thanks all, got the syntax and used datediff: where datediff(day,table.date,getdate()) between 0 and 3

I have a query pulling some data in a SQL command something like select table.invoicenumber, table.invoicedate from table What I want to do is restrict the records in the SQL command based on the invoicedate field, something like where table.invoicedate =< currentdate and...

select sop10100.soptype, sop10100.sopnumbe, sop10100.orignumb, sop10100. reqshipdate, sop10100.custnmbr, sop10100.custname, sop10100.cstponbr, sop10100.city, sop10100.state, sop10100.miscamnt, sop10100.docamnt, sop10100.creatddt, sop10200.sopnumbe, sop10200.itemnmbr...

Thanks so much, think I got it!

Thanks. Where in my SQL command do I put that? A lot of the things I try are yielding Syntax errors. It's a SQL Server 2005 database for our Microsoft Dynamics Great Plains.

It is confusing I'm sorry. I should have been more clear. Certain customers will always be in one group, while the rest of the customers will either be in a "single" or "multiple" group. The logic would be this if ( {Command.custnmbr} startswith 'swc' or...

I see what you're saying, unfortunately my grouping logic will be more complicated. there will be 3 groups group 1 will be a group of customers regardless of the count group 2 will be the rest of the customers with a count of 1 group 3 will be the rest of the customers with a count > 1 I need...

How would I do that? If you mean using a formula or running total in CR, then that does not appear to work. That formula/running total is not available for selection in the grouping interface. If the count was calculated before the data got to CR (e.g. in the SQL command) then it would be...

I have this query: select sop10100.soptype, sop10100.sopnumbe, sop10100.orignumb, sop10100. reqshipdate, sop10100.custnmbr, sop10100.custname, sop10100.cstponbr, sop10100.city, sop10100.state, sop10100.miscamnt, sop10100.docamnt, sop10100.creatddt, sop10200.sopnumbe...

thank you so much guys!

I can't seem to figure this out with the available date functions. I want to take a date (e.g. currentdate) and have Crystal return what week of the year (e.g. 43) it is. Any ideas?

I am attempting something that I think should be rather simple. I think I can do it inside the report but perhaps I need to do something in my SQL command. Any help is appreciated. My command is pretty simple: select gl00100.actindx, gl00100.actnumbr_1, gl00100.actdescr...

thank ya'll so much

oh wait, you are saying all of that would go in the select expert box right? my thinking was create a formula for start date and one for enddate and then use logic from there.

im not pulling the date from a db, i want to manipulate currentdate, basically want a formula for startdate and one for enddate, then just want to use them in the select expert