Search results for query: *

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

Hi George, Sure. My time DB table looks like this: LookUpType TID DisplayValue 1 135 5:10 PM 1 136 5:15 PM 1 137 5:20 PM 1 138 5:25 PM 1 129 5:30 PM My date DB table looks like this: VID apptdate...

Hi George, You were right about the Minutes, and not the seconds. But as you can see I'm combining a date conversion with a time conversion and that's okay and the code you provided me works great but only when you use the GetDate() as a date. I can split the date and time into separate...

Hi, I'm working with an SQL 2000 DB to extract an appoitment date/time and trying to format it so that I can insert it into an HL7 message. Here is the command that I am using to extract the date and time fields...

Hi everyone, This is what I found to work for my issue. What I did was to use Microsoft Access and use the import table function to copy all the data tables from the MySQL database. I then used the export function within Microsoft Access to move them over to the SQL server. This process was...

Simon and Jason, You both bring up extremely good points to look at. As I'm not a Linux programmer and the person who setup this database is no longer with our organization and I'm having to do this on my own, as I'm sure you've both been in situations such as this. One of the things I...