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...
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...
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.
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...
Looks like the date conversion formula is always failing the IsDate test. The first date displayed is the first formula you gave my which does extract the date as a string. the second date is the formula to convert to date and the third is the acutal field entry.
i.e
String Formula Date...
k,
a little more help on conveting it to a date type. My formula is
whileprintingrecords;
Stringvar MyDt:={MyTable.Field}";
stringvar MyStrDate:=trim(mid(MyDt, instrrev(MyDt," ")));
cdate(MyStrDate)
It give the error Bad Date Type.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.