Search results for query: *

Let me update you and tell you how I solved my problem. I might have gone around-the-world but it works and I'm stoked. I created a dynamic array that adds only unique values. At the end I added a redim preserve and made the array as big as I needed it (17). I then used a join and delimited...

I have a database that looks like below. Client ID Eff Date Code Type Code 1 01/01/2010 I 193.3 1 01/02/2010 I 200.5 1 10/13/2009 III 120.8 2 01/01/2010 I 193.3 3 01/02/2010 I 200.5 3...

I am using crystal reports 11 and I replaced the * with a comma just to check and it still does the same thing. When I export to CSV with no delimiter and seperated with a pipe | The first value shows in notepad but the rest are dropped. I am viewing the exported file in notepad. I then...

I have some formulas that are populating a string variable with detail data into one fat string. No matter how I seperate the values (*,/~) only the first value is exported in csv format. I am exporting my values | delimited....any ideas? Below are my formulas. 1) In the Group Header place...

I get it now! Thanks so much for your help (both of you). I'll let ya'll know if I'm successful.

I'm sorry I'm being thickheaded but I really want to wrap my mind around what ya'll are doing. kenhamady, you've lost me on your formula. What is the 1 or 0 for? Will the resulting string be 120100130379.8 if the code is a primary diag and 020100130279.8 if it's not? Will I put the...

Thanks SO much for your help, folks. kenhamady, if I'm reading correctly, it looks like you are concatenating the date and diag code and then getting the max of that string which is a great idea but I only need to display the diagnosis code that corresponds with the max effdate. The whole...

I am a pretty advanced report designer but this has me baffled and it's driving me CRAZY! I'm working on some data that uses a gabillion tables for everything. I have a report of all discharged patients during a time frame. I am grouping by patient number. I have a diagnosis table, a table...