Search results for query: *

CR : 1.5.3.417 SAP/BW : 701 0004 Not sure if this is the right forum. I have a CR report that has a SAP/BW Query as its datasource. The dataconnection used is SAP/BW MDX Query. The connection seems to be successful but when trying to generate the report I get an "INVALID ARGUMENT" error...

Hilfy, thanks for the response

BOXi.R2 Enterprise Need to create list of active accounts on Enterprise. Somewhat familiar with query builder, but do not know element names in the SI database. Where do I look? Thanks for any suggestions.

Hi Is the data always formatted like "L41-0080H1/H1...." ?? If so, you could create a formula and use LEFT(fieldname,13)... good luck

ctrait, You have saved reports to the Enterprise right? Just making sure you have scheduled reports on the Enterprise, the process is very similar. After you have saved the report to the Enterprise, logoff Crystal Reports, logon the Enterprise CMC, go to the appropriate folder and click on the...

The group count thing was just a suggestion, as usual I misinterpreted the request. Reporting on null sets would require a bit more logic.

oxygen101, ******************************** *****I need to show this- Total 1-2 Days 43 3-7 Days 6 8-15 Days 1 Under 1 Day 64 Pending Resolution 33 Total 147 ******************************** You could create a group for {views.days-open}...

ukwd, you might try this in the selection arguement: ToText{[birthdate}) startswith ?bdparm where ?bdparm is a string parameter, enter the value as 3/12 for March 12. you should check your default date format to validate the pattern.

pwgrim00 In design mode, select your chart, do a right clik, select chart expert, select "color highlite" and from there you can create your own arguements. What version of Crystal Reports are you using? This option is available in Xi, not sure about earlier versions.

ukwd, you should be able to define a date parameter, be sure to check the "allow ranges" option. then in the report selection expert, the arguement would be something like this "{BirthDate} in ?DateRange. this would allow you to define any size range you need. {BirthDate} is a date field right?

Thanks Ian, Appreciate the response and the suggestion.

CRXi SQL Svr DB I am trying to insert a PDF into a Crystal report so that I can print the CR and the PDF. I can insert the PDF and view the Crystal report and the PDF on-line but when printing the report I cannot get the PDF to print. The Crystal report is basically a task manual and the PDF...

if the three column totals for the ID group should always be equal and you are displaying the data in the ID group footer you could do this: create a formula (COLTOT) that adds the totals of the three columns, then in the section expert for GroupFooter1 select the color tab, select the...

Greetings... CRXiR2 SqlServer Adding tooltips text to fields and would like to bold, underline, etc... the text but can't find a way. Suggestions appreciated.

when you are in the Section Expert and select the multiple column option it adds a "layout" tab which allows you to customize the format.

Futang44 I have not used the option that much to give you a valid answer. But what I would do if you have to concatenate fields (first name, last name) is create a formula that does the concatenation and use the formula in the detail. solmskid

Futang44 In the Section Expert, for the Detail Section is an option to use "Multiple Columns". Check it out. solmskid

Crystal Report Xi Business Objects Enterprise Xi Created Cross Tab report in CR, column labels are verticle When executing same report on Enterprise, column labels are horizontal Whats happening and how do I correct it? Thanks

Thanks for the reply -LB I found out after the post that we are dealing with current year data only. The field (FLDA) in question contains a numeric value that represents the julian day of the current year. I improvised and ended up with a workable solution: ConvDate = (Date(2007,01,01) + FLDA)...

VER: Crystal XI DB: SQL Server Situation: Field contains contains julian day, just need to convert gregorian. Thanks for any help.