Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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