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

ParameterField1.CurrentValues.Add(DiscreteValue); ParameterFields.Add(ParameterField1); //tell the viewer to use the users parameter values stored in the ParameterFields array CrystalReportViewer1.ParameterFieldInfo = ParameterFields; After this bind the report to the crystal reports viewer...

I forgot to mention, everytime I run the Report i get an error message saying that an index must be between 1 and the size of the array, it says the error is in the group footer formula. Thanks again

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 forgot to mention I am reporting off of an ADO.net dataset, and placing data into strongly typed DataSet if this makes any difference.

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

Thanks for your help. I am using MS Access for my database and CR for .net 2002. I am unable to view my sql query in the database tab, is this because I am reporting off of ADO.net dataset? Thanks in advance.

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

These are seperate date fields and yes the possibility exists for there to be more than one date value for a given field. So I am assuming I have to use some type of formula to pull the data out I want and add it together, that also supports multiple records per part number group. This might...

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

I am currently grouping on part number, here is an example of the data I am getting. PartNumber Date1 Date2 Date3 Date4 P#4567 3/4/04 9/9/9999 4/4/04 9/9/9999 9/9/9999 4/6/04 9/9/9999 1/2/04 ...

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