Search results for query: *

Hi, I have a client who wants a drill-down report with subreports, with the main report selecting data for one, many or all 'Regions' within the State (of which there are 9), then when they click on one of the Regions once the report has generated (Report groups

Hi, I know that you can't create a multi value paramter in the Crystal Command, but is there a way where you can pass the result of a parameter selection EG create those parameters in Crystal not in Command and create a result formula similar to Join{?param}',') to create a string to use in an...

Hi, So we are using Crystal 2016, and I need to write a report using Barcode 128B font. Only issue is, the Barcode fonts for display are not avaiable to select in the product. I used the Function BarcodeC128B which worked fine, but I still need to display the font as: Font...

Hi, So I am trying to work out if there is a way to pass a subreport value to the main report HEADER while the subreport is in the main report FOOTER. I know in theory you cant pass a value to a spot in the main report above the subreport, but I was hoping there was wealth of knowledge on here...

Hi, Ok, this is a bit of a curly question. We're working on a project to convert some reports from an old system to crystal Reports (using version 2016). The reports will sit in a Crystal Server (2013), and will be called by a 3rd party front end selecting the report through a URL to the...

Hi, I'm using Oracle Sql 11g to create a stored procedure which I am then using to create a crystal report. My problem is with passing the Date Parameter through the stored proc. As Oracle wants to treat the date as a datetime, I can't get the parameter to work. Parameters are declared as...

Hi everyone, I have come up against an issue that I can't work out with dynamic parameters. I have a parent parameter (Country), and a child parameter (City). Both parameter lists are created from the database summary table. My issue is I want to add an "ALL" option to the top of each list...

Hi, I'm going to start using Crystal Enterprise 2015, and Crystal Reports 2013 in a few weeks. I am used to using all versions of Crystal Reports/Enterprise up to and including CE and CR 2011 (XI). From what I've read there isn't much difference in Crystal Reports 2011 to 2013, but does the...

Hi, Using MS Excel 2010. I have an excel spreadsheet roster that I am trying to put some quick highlighting in to easily see if I'm missing a role for a particular day. Basically, I have one Row per day, and several columns of names along the top, so under each name I add a role. To the...

Hi, I have a Training Workbook that has one tab for the "Master" list, and one tab for each of 6 Divisions. What I want to do is make the Master Tab automatically populate with the rows of information from each of the Division tabs, to create the master list. Each of the division tabs will...

Hi, Using CR Ver 11.5 I dont think this is a Crystal Reports issue, but I'm just trying to rule it out before going back to my helpdesk (as they have no CR knowledge, and will just blame Crystal settings). My issue is, I have TWO separate databases, with two separate ODBC Connections, and if...

Hi Using Excel 14 - MS Office 2010 =SUMPRODUCT(--($G:$G=$E3),--($L:$L="WED")) This formula above, is counting the number of times the contents of Cell E3 (a name/phone number combo) occur in the cells of Column G, where the equivalent row in Column L contains "WED" Reference Cell E3 contains...

Hi :-D Using Crystal Reports XI =SUMPRODUCT(--($G:$G=$E3),--($L:$L="WED")) This formula above, is counting the number of times the contents of Cell E3 (a name/phone number combo) occur in the cells of Column G, where the equivalent row in Column L contains "WED" Reference Cell E3 contains the...

I am using Crystal Reports XI, and having trouble with display formatting for a line graph My Axes data is grouped using this formula: ***(NOTE - I'm Basically, looking at a whole years data, but ignoring the DATE part, and just looking at Time of Day to see how many calls came in, in the 1am...

Hi, I have recently started building Crystal Reports using an INGRES database unfortunately. I am having a LOT of trouble trying to even get the most basic SELECT statement to work. Can anyone tell me what form of SQL I should be using to make this work?? Or why it isnt working I am using...

Hi, I have a report that I run in Crystal Enterprise V10, as a Tab Separated Values output file. The problem I have, is that when I run it as a TSV, some of the data is replaced with blanks. This has only started happening recently, and I'm wondering if its to do with changing a formula. It...