Search results for query: *

So, just for the sake of wrapping this up, here's the final SQL I used. This joins 2 regular tables with the results of a Common Table Expression which "flattened" the multiple rows from a 3rd table containing transaction log data. --Sample tables & data for testing DECLARE @TBL1 TABLE (...

Thanks drlex! That's exactly what I needed. I think I tried all of those elements at one time or another (creating a row #, CTE, inner joins, etc). But I just hadn't figured out how to put it all together. As with most things, the solution isn't even all that complicated once you see it in front...

Sorry for the delayed response but I was out of the office for a while and I'm still playing "catch-up". I added the code Jonfer suggested and it certainly returns the 4 rows with the data I need. But I'm still having trouble figuring out how to "flatten" those into just 2 rows - one for each...

Well, I played around with it some and I certainly got stuck. That link and some additional searches gave me lots of ideas to try but I haven't been able to get any of them to work. I have something that will assign a RowNum to each row in the third table but I seem to be missing the point about...

Yes, in the table I'm actually processing Transdate contains real date values.

I have 3 tables with data structures as shown below: TBL-1 (contains some current data about tasks) TskID TskDescription AreaID 9345 ItemDescription-1 Area-1 4940 ItemDescription-2 Area-2 TBL-2 (contains descriptions of what area is responsible for a task) AreaID...

I was surfing the Business Objects Crystal forums and ran across the following: . . . Are there issues converting a report written in 8.5 to XI? When i did one of our reports, the details section and group headers and footers display in the wrong order. They look right in development mode, but...

Bump - Just wondering if anybody else has any idea?

Ahhh, now I get it. I created a new alias in the ODBC Administrator and the went into Crystal and reset the DB location updating it with the alias I had just created. Seems pretty mickey-mouse to have to do that but it did work. [mickey]

Well, I thought of something else this morning. I thought maybe the fact that I didn't close down Crystal in between removing the links and creating them again might have been the reason this didn't work. (Like maybe the DB connections were still in place and needed to be terminated.) So this...

Thanks Eric - the reports I was testing do all use ODBC connections. But could you elaborate a bit on this? I tried deleting the link as you said. Then I saved the report, and created the link again. But I got the same problem. Did you mean something else when you said "set up the links again"?

We're in the process of upgrading from Crystal 8.5 to version 11 (Developer edition). It's been installed on a couple of machines so far and the only problem we've encountered is with reports that need to connect to more than one database. We don't have a whole lot of reports like that but there...

Thanks Turkbear. Using a parm is a good idea and would work in some instances. But for others, the reports are being run in a batch mode by an automated scheduler. (In fact sometimes a given report may be run either way and on different machines which is one reason I became interested in keeping...

I'm working in a shop which has both Crystal 8.5 and Crystal 10 on various machines (soon to have 11 as well) and I'm wondering if anybody knows whether or not there's a way to determine the version that a particular report was run under and display that on the report itself. I'm looking for a...

Was the view created sometime after the report and you're now trying to incorporate it? If so, (in addition to making sure the "views" checkbox is checked) you probably just need to "verify" the database to the report. Select Database from the tool bar and the Verify Database from the dropdown list.

Thanks a bunch. I tried them and both solutions work equally well.

Is there a function (or combination of functions) that I can use in Crystal Reports 8.5 that will enable me to display the previous Saturday's date based on a value in a date/time field? For example, if my incomming records all have a date/time value of say, Wed. 7/20/2005 (but it could have...