Search results for query: *

BO 6.5 SP2 Being a CR guru I cant for the life of me figure out how to Hide a group that has no data in it on a tab. I have a tab that encompasses ALL data, then I have sliced and diced in groups. The groups show the header in a tab with no data and I want to suppress these. In CR there...

BO 6.5 , fairly new to BO and may need to do an audit to verify what reports have been published to System Admin, user etc. 1. Can I look at the individual report and see what authorities it has been assigned to when it was published to Corp. Docs? I do not have direct access to the...

CR 8.5 I have multiple fields that I need to total for each month (about 10 additional date fields). Pending Contracts Contracts Approvd 1/2/2005 1/12/2005 1/14/2005 2/5/2005 2/2/2005 3/1/2005 Totals for month (need totals for...

Crystal V8 Table Name Activity Date/Time Ben update 2/7/2005 5:48pm Ben Change Name 2/7/2005 5:55pm Ben update 2/7/2005 6:02 pm Ben update 2/8/2005 12:04 pm Ben pct status 2/8/2005 12:10 pm I need to...

I am a little "green" and using a very vanilla reporting tool through a web application so I do not have direct access to the database but can query it. I have a column based on a subquery that returns a value, I need to create another column in the result set that counts only if that subquery...

I am very very rusty at Access and have created a table based on an excel spreadsheet. The spreadsheet will be updated periodically and I want to have the database automatically update with limited or no user interaction. Years ago I recall creating a macro to do this but not sure how. My...

I have a facility as a group Then I show all the hours for the day I need to count the appointments for each hour for the day, but I only want to count a client once for the day that may have multiple appointments that day Example: I have 2 clients for the time range below Client A has an...

I am using CR8 Have a field that is a string in military time (no seconds). I need to get the difference for the timein and the timeout then get the difference from the last time out to the next timein. I have looked through the posts and getting more confused. Please help if you can In...

Any input on where to start to find a solution for graphs that are not showing through CR10Runtime.exe files but data has been verified that should show up in the graphs. As a matter of fact in another section of the report the same data is on the report. Terri Terri

Any input on where to start to find a solution for graphs that are not showing through CR10Runtime.exe files but data has been verified that should show up in the graphs. As a matter of fact in another section of the report the same data is on the report. Terri

CR 9 I have to create a cross tab (manual Cross tab not an option because the columns are dynamic) column Survey questions 1 2 3 row Sales person % of yes for each question Returned to me is the Count of yes, count of yes and no, count of no... problem , I can...

I have a data that I want to show the change on a chart daily. I want to chart on each change for each day. The X axis is too busy for each printed day, and I need to show the change for each day but only print one date per week. Creating a group for week give the chart a different...

Having trouble getting this report title to only print the Campaign name when the salesperson is null, it still puts in the Salesperson:" if not isnull({?@SALESPERSON}) then ("Salesperson: "+{?@SALESPERSON}) + "Campaign: " + {@Report Title Line 3 Formula} else...

I have created a form with a related subform and it works well for the creation of a record within it related table. However, the records contained in the subform (related child table) are displayed later, the subform records are not returned in the order that they were entered (based on date...

I have turned the tool tips off for my Crystal Reports(9), and thats fine within CR but if I am viewing the report through a .net application the tool tips are still showing, how do I get rid of this? Terri

I have one group in a report and I only want two group items to show on one page... how would I formatt the report ? CR 9 Terri

I have 3 subreports embedded in a one page report with Pie Charts. While I have managed to closely make all 3 pies the same size the legends vary in size, is there any way to control this so they all look the same? Terri

I want to display a percentage of the grand total in the TOTAL column but not for the individual column headings column Heading APR MAY JUNE Total % row "Ad Name" 10 10 15 35 35% Total columns 80 10 10 100...

Is there a way to save a crosstab and its formatting to be used for other reports? Terri

I have a number field that I need to convert to minutes and seconds my field 127 need to convert to 2:07 I have tried many things, surely there is a simple answer?? Terri