Search results for query: *

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...

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...

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?

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?

In SQl 2000 I am trying to combine 3 fileds all type float, in a view i.e.( dbo.dbo_charges.charge_id + dbo.dbo_charges.user_id + dbo.dbo_charges.task_id AS new_id ) this adds these values together, I want to concatenate these together in one field (test_id)

Crystal 8.5 DWL Server DB. I need to produce a report that will allow the user to input some values that will be used in calculating a total. The simplest way of explaining it is I have two db and the user value that make up the total. The user value is a guess for a accrual value...

Hi I need to extract the date portion of a nvarchar field with the data in the field entered as 'Integrated -0 1/03/06" any ideas? Thanks

Working with CR 8.5 Trying to create a simple (so i thought) report that will lay out like a at a glance calendar. It will lay out like a calendar on show entries made in a access based scheduling program. Any starting suggstions or sample reports would be greatly appreciated.