Search results for query: *

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.

Thanks for the response. There are just two potential issues: 1. We may not know all the payroll frequencies codes ahead of time. For example, we have some companies that have multiple bi-weekly pay frequencies, so their codes are "B1" and "B2". Ideally, we would like to write the query...

From my experience with Microsoft Access, I know you can create Cross-Tab queries if you have at least 3 fields. However, I am trying to create a Cross-Tab Query in SQL Server when I only have 2 fields. Here is sample of what I have: ID Pay_Freq ABC A MMM S XYZ A XYZ B ABC W...

George, That actually is exactly what I did, mostly because I am using Subqueries because the code I posted is just a small piece of larger code I am building where I am linking 4 tables together. I was just curious if there was a way to it within one query, for those instances in which I am...

Thanks. It also appears that I cannot use the Calculations in WHERE clauses, i.e. in my example above I cannot use WHERE (ELECTIONS - DEPOSITS)>0 Seems like a nuisance to have to keep typing in the same calculations time and again, but it is what it is...

Can I base calculations on other calculations within my Select statement, or do I need to base each calculation on the underlying components? For example, I have this query SELECT A.SOCIAL_SECURITY_NUM, (A.TOTAL_ELECTIONS + A. TOTALOTHERADHOC + A.TOTAL_ROLLOVER) AS ELECTIONS...