Recent content by jmiskey

Denny, That sounds pretty cool! If I can capture that code, it could save me a ton of work! Do you know of any good write-ups on how to do what you proposed? In the meantime, I will scour the web to see what I can find out about it.

mrdenny, The problem is, I currently have no query! All the table linking, grouping, and calculations, are currently done within Crystal Reports. To try to re-write as SQL is probably going to be a monster, and may be beyond my level of SQL writing expertise! Geoff, I will look into MS SQL...

I get the feeling that what I want to do is probably far too complex for that. We are talking about joining 8 different tables, with multiple join fields, multiple levels of grouping, numerous calculations, criteria, and returning dozens of fields (in the 5 different record type formats...

I have never heard of BCP before (other than Business Continuity Plan). Can you link multiple tables? Can you do grouping? Can you use/set criteria? Is it easy to use?

I have a SQL database, where I need to join 8 different tables (and perform different levels of grouping) and export a delimited text file. It is basically an extract used to merge into a participant statement at an external printing vendor. For each person, a set of records will be exported...

Is there a way to export or print the Formulas Fields and other Crystal Report Specifications for a Crystal Report? I am using CR10. I have a complex report with many calculated values that I need to reproduce in another program. Thanks.

Thanks Ridyen. I don't think there are a lot of fields on the export, so that workaround may work.

I need to create a data export file using Crystal Report that exports a file in Fixed Width (Space Delimited) Text format. Without doing a lot of "trial and error", is there any easy to designate how many spaces each field should take up? It appears that the default ruler in Crystal Reports is...

George, I am intrigued by this solution, but can't quite figure out how to make it work in my example. Can you use recursive calculations in a query? Basically, I am trying to create a subquery that will be part of a larger query.

select 'ABC', 'A' union all select 'MMM', 'S' union all select 'XYZ', 'A' union all select 'XYZ', 'B' union all select 'ABC', 'W' union all select 'XYZ', 'W' union all select 'DEF', 'C' It looks like in your code, you have to need to know all the companies and pay frequencies ahead of time, and...

Cool code, but I don't think I will be able to use it for the same reasons I can't use Alex's.

Essentially what I need to build has to be able to be dynamic and built on-the-fly every time a certain Crystal Report is run (the data query I am trying to create is part of the Data Source of my report). So I don't know how possible/feasible it is to have something that builds temporary...

That looks a bit complex, and those table drops do scare me. Anyway, it looks like it would run in to the same problems I mentioned to George six posts up, where the number of possible values is unknown (not pre-determined) and we do all the results to be "left-justified" (instead of having a...

Yes, I thought that might be the case. If I were doing on Microsoft Access, I would probably create a make-table query to create a temporary table that would create that Pay_ID field via some VBA code. However, I don't think that approach is too feasible here. It's hard to overcome poor...

Hmmm... That is something to ponder. I will have to re-consider my report to see if that is do-able. We had intended to show different fields, but may be able to change it.