Search results for query: *

Hi, If i place the below statement in macro where i am building my query....what should happen... busobj.ActiveDocument.DataProviders.Item("Query 1 with lead").Columns(1).CustomSort ("Descending") I don't see any change, i want the data to be sorted in descending order and should be...

Hi, I am looking for the Unicode value for (221A) that exists in MS Word. I am not able to pass this value to Char() function....like .... =Char(221A) in BO. It gives an error. The value 221A stands for the symbol square root(mathematical operator ). I need this value for display in...

Hello Friends, Actually i am stuck with a problem like this.......in generating a report. I get values(0 or 1) for flag column. I need to place checkbox for flag column. When value is 0 check box unchecked and when value is 1 check box checked. I am trying with two .bmp files but no...

Hi, Strange thing happened.....when i tried to open a report in BO. Application stopped responding. When i restarted BO the menu bar and all the other tool bars were missing..... Problem is i could restore all the toolbars except Menu bar......(NOTE : I am able to use ALT+F etc to...

Hi All, I have a BO document that has two reports. At present two set of page numbers are printed for two reports. Can we merge these page numbering of these two reports when printed? Any ideas? Sudhakar

Hi All, REquirement is to concat userresponse data with related object from database. Is looks like this. =UserResponse("Query 1 with efashion" ,"SKU") + (If IsNull(<SKU desc>) Then " " Else <SKU desc>) The header row gets suppressed or no data is displayed when for an sku no sku desc...

Hi All, I have a crosstab report that has two columns A and B. I want A to be displayed only once. So I remove duplicates. But a blank column is displayed. How can I suppress this blank column? Thanks, Sudhakar

Hi, Is the text orientation possible in BO reports. If it is possible, how can we do it? Thanks in advance.

Hi, I am applying a sort on an object but when I run the report, the records are not sorted as required. I am using BO 6.1b. Any ideas? Thanks in advance Sudhakar

Hi All, I have a Web application that uses Webi API to invoke BO reports. It is deployed in Websphere on one machine. My BO server is running on another machine. How can we make this remote application talk to remote BO server? Or to put it simply, should the web application and BO server be...

Hi All, I am retrieving a BO report (.rep) using Webi API from a JSP page. This report has a prompt. But the method getHTMLView is not retrieving any HTML view of the report after filling the prompt. But if the report is designed without any prompts, the method is returning the HTML. Any...

Hi, I have around 200 reports. I have to publish them in different systems (say: devlopment system, testing system, staging etc). At all the places database instance is different. How can change database instance(in report) while publish them to all the reports(i think we can change database...

Hi all, How can we display the group names seperated by commas(,) in the report footer. For example, we have a report that is grouped by country name. In the report footer i need to display all the country names as &quot;Total for Country1, Country2,...&quot; Please suggest any ideas.

Hi All, A report contains two subreports that are linked with the main report with a field on the main report. All the reports use Oracle functions. Now when this report is called from a browser, the main report is coming up but when loading the first subreport, &quot;Crystal Reports Print...

Hi All, Can we write a CSP script that can &quot;Verify Database&quot; of the requested report? I am using CE 8.0 for web reporting. Using CSP can we get some properties that are available in Report Designer? For Eg: Can we say Report1.VerifyDatabase in a CSP page. Any ideas? Thanks in advance.

Hi All, How can we create a running total from a formula? For eg: I have a formula say 'aSum' as Sum(field, cond). Can we create a running total of aSum? Any ideas?

Hi All, I have a report that uses a subreport in one column. How can we suppress the enitre row if the subreport is empty? Any ideas?

Hi All, Can we write a record selection formula in the main report based on the data in the subreport? For Eg:I have a main report that displays some details. Amount is displayed using a subreport in one of the columns. Now can we have a record selection formula that gets the details say...

Hi All, How can we display a grand total of a formula field? For Eg, I have a formula in the group footer that displays a running total for that group. I need to sum up all the totals in the group footer to display a grand total. Any ideas?

Hi All, Does CR 8.5 support pipelined functions in Oracle? I am using a pipelined function in a report, the designer closes the database connection everytime I run the report. Any ideas?