Recent content by daguas

That did it, Thanks so much.

Thanks for the reply imex. Its almost what I'm looking for. This only returns 1 row though. I need to get 1 row for each ProjectID based on the max(ApprovedDate) for each projectid. If that makes sense.

SQL 2005 Weak on SQL, need assistance on creating a query. I have a table that contains header information for monthly cost forecast information for numerous projects. Each month a new cost forecast for each project will be entered into this table and later approved to report on. A simplified...

Does anybody know what the new syntax for the openDocument Command URL is for BOE v12.1.0? I have tried updating the 11.5 URL command which was: http://<<server>>/businessobjects/enterprise115/InfoView/scripts/opendocument.aspx?iDocID=999999 to...

Crystal 2008, Datasourse SQL 2005; I have a crosstab report that is formatted to display columns that displays up 60 months of Colums vertically. This was done by setting a custom paper size. The report is rendered to .pdf and for a 60 month data set works great, but if the dataset is less...

Using SQL2005 I have an application that was adding zeros to a nvarchar field, we have corrected the applications behavior, but I need to delete these zeros in existing records. I can select the records to update using the following Select * From dbo.Contracts Where dbo.ContractNumber Like...

Good Idea, I knew you would have one. :-)

In Crystal XI: I have a text box noting that the user when viewing the preview can drill down to more detail, Can this text be contionally formatted to only show on Preview and not print or export??

I have a universe that includes a SQL table that has had soem fields added since the Universe was created. The Check Intgrityu function in Designer (11.5) will note that the table has changed, but unlike Crystal where it will ask if you want to "fix up the report" to include the new fields I...

Thank you all, thats what I figured, but was hoping there was a workaround somewhere so I could aviod redoing this report in 8.5. O well.

Thanks for the quick response. When I have tried that, it pops 2 errors, first "failed to open docuement", then "invalid report version" so I cannot open the 11.rpt file at all in 8.5.

I have a report that was written in Crystall 11, I need to run it in a program that can only use the Crystall 8.5 .dlls. Any Ideas?

Your the greatest lbass. thanks much.

in 8.5. I have setup a group on a date field that will be printed for each week. It displays the first day of that week in the Group header name, I need it to show the week ending date instead. Any ideas?

Thanks much, that worked great..