Search results for query: *

Hello All, I have a report in which I have to formulas. One formula is within the details section: Global DateVar array Names; WhileReadingRecords; Redim Preserve Names[UBound(Names) + 1]; Names[UBound(Names)] := Date({Timeline.TransitionDate}); and it just adds a date value to the array for...

I have the following three formulas, I am trying to accomplish the following with them. The Names array is holding dates pulled from the Db, I want the DB record associated with the date that is closest to todays date. I am getting the date difference in seconds between these two dates and...

I am using the bundled version of CR for .NET 2002. I have a report that is using three tables from my database, and it runs very slow. I am thinking that the SQL statement for my report is grabbing much more data than it needs to from the database. I am trying to view the SQL query in order...

I have a recursive database design between two tables package table and parts table. These are setup as follows: Part(PartID(PK),PartNumber) Package(PackageID(PK),ParentID,ChildID) The partID is linked to the parentID(FK to Part table) and I am using aliases to be able to get info like the...

I have a recursive database design between two tables package table and parts table. These are setup as follows: Part(PartID(PK),PartNumber) Package(PackageID(PK),ParentID,ChildID) The partID is linked to the parentID(FK to Part table) and I am using aliases to be able to get info like the...

I have a crystal report which I am displaying using a web form viewer within an asp.net application. My report is based on a sort of recursive database design so my report is using aliases of many tables. I am wondering how to speed up this report, I looked into caching but that really doesn't...

I have two tables setup in an access database that will allow recursive nesting. One table is called Parts, and essentially, everything is a part, then the second table is called packages and it contains three fields. PackageID, ParentID(PartID of parent part from Part table), and...

I have a report that is using two tables Parts and Packages. The Packages table has a field in it called ParentID, which references PartID from the parts table. So everything in my db is a part but using the packages table parts can contain other parts. My problem is trying to retrieve an...

I am reporting off of an access database using CR bundled with VS.net. There are two tables in my database i.e. Parts table and Package table that essentially have two links between them, and there are two fields in the package table i.e. Parent and Child. THis design allows infinite amounts...

Hello all, I am using the packaged CR for .NET and I am generating a report for which I need a formula I am having trouble creating. I have a table in my DB that records events (dates) for a certain part. When I execute the report I am getting seperate records on my report for each match it...