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 strongm 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: *

  • Users: ErnstNoto
  • Content: Threads
  • Order by date
  1. ErnstNoto

    Week number and Leap Year

    Hi! I've had some reports the last couple of years where I report on week numbers. This has been working just fine up until now. 2016 It is a Leap year and 2015 had 53 weeks is. The formula I've used in Crystal wont identify this: DATEPART("ww",{@Regdato}, crmonday) Anyone who has an idea on...
  2. ErnstNoto

    Timeline - created and update date

    Hi I have a data table which for example have the following fields. Id; Reg.date; Duedate; User ID; Case nbr; Update date 746056; 2015-02-10; 2015-03-12; IMA; E28896; 2015-03-13 746060; 2015-02-11; 2010-02-08; DK; C55411; 2015-03-13 746066; 2015-02-17...
  3. ErnstNoto

    Solvent Ratio

    Hi I have a solvent ratio report that sees every month separetly Nbr of delivered invoices each month Amount paid on these etc…. Presented like this: 2013 Month - Nbr_Inv - Recevied_Pricipal - Current_Pricipal - Paid_Principal - SolventRatio Janury - 428 - 500 - 200...
  4. ErnstNoto

    Splitting a field based on a delimiter

    I have a description field in my database which I would like to split into two separate Fields in my report. The information is always separated with a colon. I cant use the left/right function because the positions change. The field contains information on a merchant on the rigt side, and the...
  5. ErnstNoto

    Vertical Grouping

    Hi! When performing a grouping in Crystal, this grouping is performed vertival Headings Group1 Group2 etc.... Is there a practical/easy way of making a grouping horisontal: Headings - Group1, Group2, Group3, etc... amount Group1 Group2.... count Group1 Group2... etc... Anyone who has a...
  6. ErnstNoto

    Subreport blang if main report blank

    Hi! I am having a little problem with one of my reports. Mainly it works just fine, but if the main report dont get any result, wich may happen, it wont show any result from the sub-report even if there is a result to be shown. It seems as though crystal dont se any reason to refresh/run the...
  7. ErnstNoto

    Modulus 10

    Hi! I need to calculate modulus 10 in a crystal reports I know how to calculate this manually but I have a bit of a problem figuring out how to calculate the check digit and create the new number in crystal reports. Anyone who can help? Best Regards Ernst Best Regards Ernst Noto
  8. ErnstNoto

    Select

    Hi! I have a situation where I need to remove certain events based on a certain other events An example of on a situation/selection. The report is grouped on case numbers. I am only interested in Court claims after a certain event has occured. Might be useful to know that these events also are...
  9. ErnstNoto

    u2ltdate.dll

    Hi! Needed to reinstall my pc and after installing CR, for some reason, I am now missing a file called u2ltdate.dll which is needed to use numbertodate. I cant find this file anywhere. I can find a lot of treads about this problem and where the solution is described. Most common is "I...
  10. ErnstNoto

    Distinct Count

    Hi! I am having trouble with getting a correct summary with distinct counting. The issue revolves around counting how many times a social security number has been credit checked. The problem I am having is that if a socicial security number has been creditchecked 2 times in one day, this...

Part and Inventory Search

Back
Top