Recent content by thorntong

Good Morning All, I am trying to see if I can make a direct SQL call using an OPENDATASOURCE call to a DSN that has been setup on my SQL 2005 server. And I am having trouble with the syntax using this type of call. I am trying to access the OD_RECEIPTS table within a ODBC System Name of...

Hi Everyone, I am trying to figure out how I can increment a counting column while using a UNION statement. I have created a separate table to store the current value. Here is my query: SELECT PatID, VID, RunDate, null AS 'Status' FROM dbo.VT_Blueprint_BP UNION SELECT PatID...

Thank you LB!!! When I tried first tried the group concept, I had overlooked that I could just 'suppress' the group fields (my fault) and I then ran into an issue with the group records statement as I had to ensure that I was matching the fields in the statement with the ones from the 'Group...

Thanks LB! I tried the grouping thing, but the problem with grouping within Crystal Reports is that it interprets data from a top down view. And it my case, this approach does not work as I'm trying to put multiples pieces of data on a single line and each piece is unique. So I guess my only...

Good Morning, I'm using Crystal XI and I'm having problems with a mailing label report that I cannot seem to prevent duplicate patient addresses from being displayed. The reason that I'm getting duplicate data is because a patient can have multiple doctor visits within a 2 year span. I thought...

Hi Everyone, I'm using Crystal XI and I'm having a problem with a report that has an embedded OLE object (Excel Spreadsheet) in it. The report runs perfectly fine and everything, except when you try and print it. The Excel Spreadsheet is being displayed as one huge black box. Has anyone seen...

Thank you everyone. Your resource suggestions are have been extremely helpful!! Glenn

Thank you LB! This worked great! Glenn

Hey LB, What I meant by 'link' was that I wanted to make sure that page 1 (front) was connected to page 2 (back). And my reference to 'page' was that I had a second worksheet that I wanted to add to the second page. Thank you, Glenn

Hi Everyone, I am in need of some guidance in regards to creating a multi page report using OLE objects. I am using CR XI and I am creating a billing sheet for one of our departments. I created the actual billing grid sheet using MS Excel. The report runs against our patient DB and pulls in...

Thank you Jason! The information you've provided is very helpful and enlightening!! Glenn

Hi Everyone, I am looking to learn ASP.NET and I was wondering if anyone knew of any online training courses that were very good and you really got a lot out of the class. I would greatly appreciate any assistance/guidance that you may have. Kind Regards, Glenn

Hi everyone, I found another link that may answer this problem: https://forums.sdn.sap.com/message.jspa?messageID=5767771 Glenn

Hi Everyone, Thank you for responding to this post, but if you're running a report that is automated to export to a CSV file (format: Character Separated), I only need a single header. I do not want to have to manually touch this file in order to to get the header line in there. Does anyone...

Hi, I was just looking for an answer for your exact same question. I'm stuck. Glenn