Search results for query: *

I have a Top N sort of Group 2 that is a summation. I would like to take that top value and do a Top N Sort of Group 1. I would at least like to filter group 1 based off of the maximum sum from group 2. I have the following function that will not work: Maximum(Sum ({connect1.TalkTimeSeconds}...

I am filling a table from a Connection. You can see the connection below along with it's table in the background. The connection passes an SQL Select statement to a MS SQL Server via OLE DB. I would like to modify the query to use the to date in Table 2. I can see a parameter button at the...

I am setting the backgound color of column headers like the following: Select left(GridRowColumnValue("@StateReporting"),1) Case "1": color(50,230,50) Case "2": crAqua Case "3": color(255,150,150) That part works great. Next I pasted the same formula with the subtotals so the entire column...

I have a report that reads the filename of jpg images from a table. The graphic location formula then uses that field to point to an image. All images from a case are then displayed on the report, two images per page. The report worked fine for years showing all the pictures from whatever case...

I would like to setup a repository for commonly used functions and images. I'm told that you do not have to own Enterprise server to do so. What is involved in creating one if I just want users to access it via Active Directory?

I have a report that works great. The back color of each cell is determined by the value in the cell. But when I export it to Excel, some cells turn black! Any advice? Crystal Excel

I have a word document of policy and procedures. Each chapter is broken into sections with it's own footers. It seems easy enough to add page numbers for the overall document or to be able to create page numbers that start over in each section. However I want to do both. Is it possible? I want...

I have a report within MS Access that has a group. The group header has a text box that uses the following formula to show the average Hours:Minutes:Seconds =Format(Int(Sum([QDuration])/Count(*)/3600),"00") & ":" & Format((Sum([QDuration])/Count(*)/86400),"nn:ss") It works great. However I...

Group 1 : Employee Type (part time, full time, etc) Group 2 : Employee Number Group 3 : Pay Date For group 3 I have a summary that adds the hours an employee worked in a pay period. Now in group 2 I need another Summary that averages those sums so that I have an average number of hours each...

I wanted to keep two fields close together. The first field varied in width, so the natural solution was to drag the two fields inside of a text object. The problem is that the second field may have hard returns in it and even though it is set so that it "can grow" and so is the text object...

I am using MS Access 2010. I have a report with two groups. Group A is the LoginDate. Group B is the Agent. The details show the times the agent loged in and out. When running the report each detail section does limit itself to the Agent, but data from all dates is showing even though group A...

I have been creating Crystal Reports for probably 14 years. I've written them against different versions of Access and SQL Server. Only now did I run into something that I have never seen before. There was extra data showing up in my report that made no sense to me. I would query the...

I have a query that sums an amount field. The data type should be currency, but because my export to a text file must not include a dollar sign ($) I am forced to use a double. Anyway when I sum the amount in a query, Access adds .000001 to the value. To test, I added a group to my query...

I used to be able to view tables side by side, or one above the other. Now when viewing a table in datasheet view, all the tables are separate tabs, and you can only view one at a time. Is there a setting somewhere in Access Options that will allow me to do this again?

With Crystall XI, when I connect to a SQL Server Database using OLE DB (ADO), I can browse to the database then to the owner, then there is a tree for Tables and Stored Procedures. Usually, ther is also a tree for the views. On this particular databse, there is not! There are views in the...

We have some MS Access programs that have links to SQL Server tables as the back end. When a new record is created, the users would like certain date fields etc to have default values. I have gone into SQL Server and given the fields these default values, but when they create a record in...

Is there a way in a group selection formula to show a group only if a certain detail shows in the detail section? There may or may not be other details as well. I want all details to show, along with the sumations of the details, but I want the entire group not to show if at least one of the...

I have two survey's. Each had the same five quesions. I have created a chart that compares the number of yes answers for each question for the two survey's. Unfortuneatley, the same number of people were not queried the second time. In order to make a fair comparison, I need to show the...

I have a report with two Groups. The Footer of Group 2 shows the Sum of numbers from the detail section. I would now like to show the median of those totals and display it in the footer of Group 1. Is this possible?

I could swear I submitted this about 6 hours ago, but it's not in my list of threads I've started. Anyway, I have the following record selection formula in a subreport: {CA_NOTES_VW.CA_OBJECT_ID} = {?Pm-CA_OBJECT_VW.CA_OBJECT_ID} and ({CA_NOTES_VW.COMMENT_CODE} = 'BPRINT' or...