Search results for query: *

I have a field that is alphanumeric. The majority of the fields are numbers. When I sort they do not sort in numerical order. I would like to add a leading zero to any field that is 3 characters so they will sort correctly. See below example Current sort 100 101 102 20 201 202 203 Would...

Crystal Reports 2016. I have a main report, with a sub report. All pulling data correctly. However when I try to use a shared number variable the amount is not correct. Group header 1 has the initial sub report (Items with border) and group header 2 contains the "while Printing Records share...

I have an excel report I put in the report library. When the user clicks on this report it refreshes and opens up fine. There is now a tab available to the end user, called "OPEN". Does anyone know how I can get rid of this tab?

I have an Excel Web Part and I would like to put on it somewhere the "Last Refresh Date". Dows anyone know where I can find such a field? Any assistance would be greatly appreciated.

I have an excel spreadsheet (2007) that I have published to a dashboard as a Web Part. When I click the report opens fine and looks fine. However, I can not REFRESH the report data. I get the following error: Unable to retrieve external data for the following connections: The database info...

Does anyone know of a formula that would break out a date range. For example: Current field is 04/01/10-04/15/10 I would like to see 04/01/10 04/02/10 04/03/10 04/04/10 04/05/10 Any help would be greatly appreciated.

Does anyone know if a "Column" report can be created in Crystal? I am using Crystal reports 2008 and would like to do something like the following: Compare three years worth of revenues using three seperate parameters if parameter 1 = 1 then put revenue in column 1 if parameter 2 = 2 then...

I have an excel document that connects to a SQL Server database. When I generate the excel document the connection automatically refreshes the information when the workbook opens. When I try to put this in an EXCEL WEB PART the connections fails with the following: The data sources may be...

I have a sub report that pulls revenue by event id, works fine. I bring the sub report into the main report link it by event id and all works fine. I share the numbervar so I can use this total in another calculation and here is where my problem occurs. if the total on the subreport is 0.00...

I have an excel chart and have used an image as the Data Series, instead of just the bars etc. When I publish this spreadsheet into Sharepoint, as a web part, the images disappear and the series shows up as bars. When I go to "Open in Excel" the images are back and the bars are gone. Any...

When publishing a report within Enterprise, is there a way to change the font color for the report name?

Has anyone heard of the following: I have one distribution list that I have reports scheduled to be sent to them weekly. Starting a few weeks ago, they stopped receiving them because I have seperated the email address' with a ";". (I have 15 other distribution lists where this works fine)...

I have a sub report that has a formula "WhilePrintingRecords; Shared NumberVar SQRFTShare:= Sum ({@Sqr Ft},{EV200_EVENT_MASTER.EV200_EVT_ID})" This works fine. In the main report I have a formula "WhilePrintingRecords; Shared numberVar SQRFTShare; SQRFTShare This works fine. My problem is...

Does anyone know if there is a limit of how many email address you can send to at once, when scheduling a report to be mailed? Thanks

I have a SQL DB, that I currently am reporting off. Come to find out that there is one piece missing. the monthly financial accruals never get put into my financial db, but are just kept on an excel spreadsheet. Has anyone ever reported from two db sources on one report? Or, using excel or...

I am trying to find a formula that would allow me to use one parameter OR another parameter in the same report. For example have two parameters such as Choose Date range "OR" Choose Report number. Any ideas would be greatly appreciated Thanks, Margie

Does anyone have documentation on how to add an additional domain within Business Objects Enterprise?