Recent content by glyph1

I solved this by doing the following: 1) Creating a stored procedure instead of linking in crystal reports. 2) In the stored procedure I created a simple select statement that selects the ContractNumber. 3) In a sub query I selected the ContractNumber and linked the ContractHistory.ContractID...

CR Version: Visual Studio.Net 2005 Crystal Reports I am having a speed problem while using the subreport linking in crystal reports. I have three tables: Document - DocumentID, ContractID Contract - ContractID, ContractNumber ContractHistory - HistoryID, DocumentID, ContractID In my report I...

Just following up to my original post, I created a stored procedure using a while loop to achieve this. CREATE Procedure get_contracts @ContractID int AS BEGIN DECLARE @NextID int DECLARE @ContractTable TABLE -- Temporary Table (ContractID INT, NextContractID INT, ContractNumber...

Thank you very much George for your quick response. Basically I am looking to Select every ContractNumber that is linked to a starting point: a @parameter. I wanted to create something that is similar to a linked list. something like this link...

Database: MSDE SQL Server 2000 Table Contract ContractID PK* ContractNumber Status NextContractID FK* I am looking to select [ContractNumber] based on an input parameter and return all (non-null) of the linked [ContractNumber]s based on the [NextContractID] / [ContractID] relationship. I...

Using: Visual Studio.NET Crystal Reports, ASP.NET, C# The following code takes my parameters into the report, exports to a pdf on the client side and redirects the client to the PDF file. I need to load the pdf without leaving a file on the client or server. My basis for comparison is the way...

Thank you Shaun, I confirmed that it was a hardware issue and am having it repaired under warranty. I appreciate the help!

I'm not sure if this is a hardware or software problem but I am having a strange problem with my Toshiba A105 Laptop with a DVD+R / CD/CD-R rom drive. It will load DVD's (retail and DVD+R) fine as well as data CD's and CD-R. However the CD reader will not read the Audio CD. I was wondering if...

Hello, I am having a strange problem with my Toshiba A105 Laptop with a DVD+R / CD/CD-R rom drive. It will load DVD's (retail and DVD+R) fine as well as data CD's and CD-R. However the CD reader will not read the Audio CD. I find this to be rather strange, and I would assume it to be a failing...

Thank you again George! This was a great explanation, and it actually tied up a lot of loose ends for me about joins and derived tables. I really appreciate the help, I hope you have a great day!

Thank you so much George it works perfectly. If you don't mind I would love to hear the explanation.

Using MSDE MS SQL Server 2000 I have a table named Visitor that has two primary keys (int), Visitor_ID and VisitorVersion_ID. I am trying to return unique Visitor_ID's that have the most recent version, or in other words the Maximum VisitorVersion_ID value. My current query: SELECT...

My current formula: Day ({Visitor.SecurityDate}) & " " & uppercase(totext({Visitor.SecurityDate},"MMMM")) & " " & Year ({Visitor.SecurityDate}) Produces an undesirable result: 1.00 SEPTEMBER 2,007.00 Probably an error on my part, I did turn off the decimal places and thousand seperator for the...

Hello! I just had a (hopefully) simple question. Crystal Reports defaults the date to be lowercase and I need uppercase. I selected the format object and customize options and the formula, but I'm unsure how to distinguish the month as a string and convert it to uppercase. Any help would be...

Although this post might not be helpful to others I appreciate your feedback and the solution was simple, I had to use a subreport to get the job done. I hadn't used them before and I'm fairly new to crystal reports so I really appreciate you taking the time to respond. I have been using the...