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!

Search results for query: *

  • Users: nathj
  • Order by date
  1. nathj

    IsNull always returns True

    I should have said above that I meant to add the required details to my forst post, but forgot, and I could not find the edit function. So just for reference: I am running a Visual FoxPro 9 app and VFP database. The output tables are converted to fox2x as thats what Crystal will use. I am...
  2. nathj

    IsNull always returns True

    Hi, Thanks for stopping by. I am trying to suppress a details section that contains a sub report if the sub report data is empty. Because of the nature of the report I have to use sub reports. The problem is, I have since discovered, that count() returns NULL when there is only one record...
  3. nathj

    IsNull always returns True

    Hi, I have a report that contains numerous sub-reports, some of which may not have any data to display. According to the Crystal KB I am supposed to set up a variable that determines if there are records and then suppress the relevant section based on that variable. All seems fine. However...
  4. nathj

    If IsNull Always Returns Alternate Text

    Hi, I have similar problem when using IsNull in Crystal If IsNull(Count({tmpChild.FFCHILD})) OR Count({tmpChild.FFCHILD}) = 0 then SuppressChild:= TRUE Else SuppressChild:= FALSE; The value in tmpchild.FFChild is 20.00. However, IsNull(Count({tmpChild.FFCHILD})) returns True as does...
  5. nathj

    Please help. Using XMLAdapter class in VFP9

    Hi dbMark, Thanks for your help. I wasn't aware of the the getelementsbytagname() option. I will probably use this in my application. If I develop a generic routine then I will certainly let you know about it. Thanks once again Nathan
  6. nathj

    Please help. Using XMLAdapter class in VFP9

    Hi, I am fairly new to the use of XML in FoxPro having only just got my hands on VFP9. I am now developing an application that will take an XML file convert to a VFP data set so that I can update the underlying data teir of the main application. I will include the XML, the XSD and the code I...
  7. nathj

    convert dbf to xml

    WE use, in VFP^ the following three procedures to get DBF to XML and back again. ********************************************************************** * Function : ConvertTableToXml * Parameter: TblName ********************************************************************** FUNCTION...
  8. nathj

    IIS - MySQL - ASP .Net

    Hi, I work for a software company that is currently deploying an online system that uses ASP.NET, MySQL and IIS. I have the latest version of the .net framework, the latest version of IIS and the most recent version of Microsoft ODBC.Net. Within the system I can edit and delete existing...
  9. nathj

    Subreports out order

    Madawc, Each subreport is in its own details section. There are 15 subreports and 15 details sections. lbass, The asset ID is in the data for each details section and that is used in the subreport linking along with the client id and asset category. However, the subreports are still...
  10. nathj

    Subreports out order

    I have tested the report by ordering the data in the FoxPro tables in a number of ways and this makes no difference, for some reason Crystal wants to put details section g at the end no matter what. Are there some settings that I may not know of that could sort this out? Cheers NathJ
  11. nathj

    Subreports out order

    The problem is that it should display details b, g, o but infact it is displaying details b, o, g. this is the problemn that needs solving. I also added a dummy details p with a subreport named ZZZZZZ and this displayed as b, o, p, g. It seems that g always appears last. I hope htat clears...
  12. nathj

    Subreports out order

    Hi there, I'm not using any shared variables in this report. What would be the benefit of moving the subreports around? They are added to the report in the correct in order it is just that the report doesn't display them in the correct order. Thanks NathJ
  13. nathj

    Subreports out order

    I should have said that in testoing the al;phabetic order I added a temporary subreport to a new details section; details p ZZZZZZ this then appeared: Property (details b) Summary (details o) ZZZZZZ (details p) Unit Trusts (details g) Thanks very much
  14. nathj

    Subreports out order

    Thanks for this but I am not sure what you mean . The report sections are as follows Group Header 1-a Group Header 1-b Group Header 1-c and the grouping here is client # details a - Cash details b - Property details c - Protection details d - Pensions details e - Bonds details f - ISAs details...
  15. nathj

    Subreports out order

    There are 15 subreports in 15 details sections; details a-o. If the client on the report has property and unit trusts in their portfolio then it should display: Property Unit trusts Summary However it is displaying; Property Summary Unit Trusts. The subreports are only displayed if there is...
  16. nathj

    Subreports out order

    Hi there, I am using Crystal reports 8.5 using data generated in VFP6. I really hope someone can help me out here as this problem is driving me nuts. I have a crystal report file with 15 subreports each in its own details section. The last subreport and therefore last details section is the...
  17. nathj

    vfp's between function in .Net

    Thanks alot. thats so obvious now I know, I feel a bit daft for asking. cheers
  18. nathj

    vfp's between function in .Net

    I am slowly moving from VFP to .net. In foxPro you can do the following func numbertest parameters nNum if between(nnum, 1, 16) then ? "number is between 1 and 16" else ? "number is not between 1 and 16" endif return endfunc I was just wondering what the comparitve function is in .Net...
  19. nathj

    Manipulating data and Objects

    Sweep, Thats fantastic. Now I have the Id out I can do all sorts of wonderful things. Thank you very much Nathan
  20. nathj

    Manipulating data and Objects

    Sweep, thanks for the reply. the final line of code is a UDF and may or may not be required. EAddress stores all electronic address information, the sort of thing that is not tied to any physical location. Every client is connected to this collection and can have any number of any type of...

Part and Inventory Search

Back
Top