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!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by timbaktuu

  1. timbaktuu

    Help with Custom Shipping label ?

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

    Formula grouping?

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

    Formula grouping?

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

    linking tables?

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

    linking tables?

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

    linking tables?

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

    excluding saturday/sunday from daily report

    Thanks Ian & LB.
  8. timbaktuu

    multi value param mapping ssrs ?

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

    excluding saturday/sunday from daily report

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

    How to suppress duplicate fields (not records) ?

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

    "All" paramaeter for the report

    Thank you LB :)
  12. timbaktuu

    "All" paramaeter for the report

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

    Display month range hh:mm:ss on report?

    Thank you Brian.
  14. timbaktuu

    Display month range hh:mm:ss on report?

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

    Display month range hh:mm:ss on report?

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

Part and Inventory Search

Back
Top