Search results for query: *

Hello Everyone, Need help with shipping label. I need to create custom shipping label based on different customers. the label will be like UPS label printed on ZP printer. The fields can be Part no, Purchase order number, customer name, quantity, work order number, manufacturing date..all...

or the formula would be like this ?? @NewCount = If @new=1 then sum(@new) @oldcount=If @new=0 then Count(@New)

Hello Gurus, I need your advice. following crystal report need to have one 2 extra groupings. here is the structure. agent> Grouping by day>detail section(all details) Raul Smith Monday--> need to divide in new signup/old account ...

I am still not sure if I should delete all links except ID one? I am unable to see table in its true structure. only option is visual linking through IDs

Thanks Jmd for the reply. there is one ID number common to both and thats unique for sure. apart from that the tables were auto-linked on its own and has some 8 links together including (unique ID) Should I delete all links except ID one? I do not have access to backend of database and cant...

Hi all , I am working on some system generated reports. mostly data comes off the table since those are system generated reports. so it was ok, Now I am asked to make a report and do something that involves linking of tables. How can I make sure that the linking I am doing is right...

Thanks Ian & LB.

Hello all, I have 2 datasets in my report dataset 1 main result set comes from stored proc with @fromdate @ todate params has customer.name field. dataset 2 only to populate custome names in drodown list (simple select statement from customers) that has only one field customer.name using a...

Hello all, I have a daily report, that has following selection formula in record select: {table.Timestamp}= currentdate -1 and {table.Timestamp} in datetime(currentdate-1,time(9,0,0)) to datetime(currentdate-1,time(20,0,0)) If I run it on monday 2/14/2011 how can i default it back to...

Hi Everyone, How do I suppress duplicate fields (not records) in detail section: the data is as follows 9:00 Kathy 9:00 Kathryn 9:00 Lee 14:00 Matthew I want to show it like 9:00 Kathy Kathryn Lee 14:00 Matthew (Plz ignore the names formatting) I...

Thank you LB :)

Hi, I have a parameter {?Name} in my rpt. I have a record selection formula If {?Name} (If {? Name}<>'All' then {table.name} in {?Name} Else True) My client doesnt want to see some of the names when he selects "all" on the prompt screen. for instance data is harry, Adam, David kathy...

Thank you Brian.

thanks Ian and Brian, About 8 -9 data means. when its run on first of every month then it should show last month's each business day where data should be between 8 am to 9 am (table.timestamp).hope I am clear. Also I was making one weekly report and need to display last 5 working days...

hello everyone, I did this on report and it showed only 1/1/2011 - 1/31/2011 CStr(Minimum(LastFullMonth)) + "-"+ CStr(Maximum(LastFullMonth)) I want to show on report 1/1/2011 00:00:00 - 1/31/2011 00:00:00, how do i do that? i tried totext did not work. also I am running my rpt as (last...

Thank you LB. I removed the start date end date report parameters and used record selection formula for the same. A) for the daily every 15 min one, some how it did not show the data for last 15 min while there was data in the system. I m still checking if something is supressed, so far...

The monthly report should show the data for last month. IF I run it today then it should show 12/1/2010 00:00:00 to 1/1/2011 00:00:00 Also I have a daily report that if I run it today, should show 1/24/2011 00:00:00 to 1/25/2011 00:00:00. Please let me know. Thanks.

Thank you LB. That looks good. I will try that. For the monthly report, I think I may have to check again.

Thanks lb for ur reply. Sorry that 15 min thing does not apply to mmonthly report. It was a typo. I m unable to show the results right now. But the example would be for today between 7 to 8 pm, whenver anyone runs the report, it should be for the last 15 min. I hope I m clear this. Time...

Hello Everyone, I need to run the reports for specified interval. The parameter should look something like this after deploying: A)daily for interval 7:00 AM to 8:00 PM every 15 minutes B)Monthly for interval 12:00 PM to 11:45 AM every 15 minutes I have the start date and end date...