Search results for query: *

I'm not sure if I described my subject correctly but here is what I'm trying to do. I am using Crystal Reports 2011 and I want to create a dynamic report where the user is prompted to enter a parameter that will be used for record selection. I would like to give options for the parameter to...

I used to have Crystal Reports version 8.5 and I had several reports for yesterdays work. The reports checked to see if a report date was a work week day and if the date was in a array of manually entered holidays it would go to the previous date and check again until it found a work week day...

I posted a message over 3 weeks ago and haven't had a single reply. Usually someone posts a reply with an answer or at least a question about what I'm trying to do so I'm thinking that my question was to confusing for anyone to respond. If that's the case, I apologize. Here's my attempt at...

I am using Crystal Reports 9 to create a monthly bar chart report. The chart needs to show 6 months of data, the current month and the previous 5 months for individuals in our group. Each individual will have their own chart. The data shown should be the average score the individual achieved for...

I'm running a daily report to show filtered records that were closed on the previous workday. The report works except when there aren't any records to be displayed. When that happens the @targetdate field is blank and doesn't showup on my Page Header. Any ideas? Thanks

I run a report everyday and sometimes there are no records because there isn't any that match my criteria. What I would like to do is display the message "no records today" when there are none. I tried a couple of things using suppression but haven't managed to get it to work. Any help would be...

I need to secure a column of sensitive data in an excel spreadsheet where the only persons with the proper password or access level should be able to view the column. I've looked at protecting the sheet, workbook, format-security and haven't found the right combination. Can anyone help with...

I'm using CR9 to create a drill down report that displays a pie chart showing tickets by department with a corresponding legend. However there are some tickets where the department wasn't selected. Those tickets are displayed in the legend without any department title. I would like to show in...

I have a drill down report in CR9. After the user drills down one or more layers I'd like to have a command button, text, or something that tells the user to click on it to return to the previous layer. I know they can click on the X on the opened tab but I'd like to make it as simple for them...

I'm using CR9 to show help desk calls by department. The data is displayed as a pie chart. I'd like to be able to drill down into a department and display a pie chart showing different categories of calls. Then drill down into a category to display detail records. The problem I'm having is the...

I'm using CR 9 to create a Top N report. Group 1 is by user. Group 2 is based on a formula called subcategory1. The formula for subcategory1 is: If IsNull({CR_View_for_Steve.SUBCATEGORY1}) then "SubCategory1 not specified" else {CR_View_for_Steve.SUBCATEGORY1} When the report prints...

I hope someone can help me with this as my knowledge of access is very limited. I want to write a query that will prompt the user to select a folder (navigation box would be great) and execute a query that will create a record in a temporary table for every file found. Each record will have...

First of all I'm not sure if this is the proper group to ask my question so if it's not my apologies in advance. What I'm trying to do is create a database for a single user to display product information (product name, price, etc and product image) on a form. The method I want to use is to...

First of all my apologies for being so dense. I've been spinning my wheels trying to get this to work for sometime and looking at previous posts and examples just isn't getting it to work for me. For example I tried method 3 in a link to four ways to move a record from a cobo box selection on...

I'm trying to use Open Office 2.0 for the first time. In the text application I created a table that positioned itself not where I wanted. I can't seem to figure out how to move the table easily. In MS Word all you had to do was put the table in a text box and click and drag to where you...

I have an Orders form that allows me to enter new customers and in a sub form enter their order details. The problem with this is I have to re-enter information if they are a repeat customer (first name, last name, billing address, etc). I decided what I needed was a command button that would...

I've looked at some posts and some books but haven't found a solution thus far. What I have is a table with a field called link containing a web address. It is defined as a hyperlink field. I have an unbound main form called frmBillOverview and a subform called sfrmBills. The subform's record...

I'm using access2000. I have a form frmPayBills with a date field DatePaid and when you click on the field to change the date the format changes. How can I correct this? The forms record source is: SELECT [tblBillDetails].[BillDetailsID], [tblBillDetails].[BillID], [tblBillDetails].[DatePaid]...

I'm using Access 2000 and I have a form called BillsOverview. On that form is a subform called Bills which is setup as a datasheet view and displays BillDescription and DaysRemaining. The other columns are hidden including a column with a color code. The valid codes are RED, YELLOW, and GREEN. I...

I'm working on a Bill reminder database in access 2000. I have an unbound form with a listbox displaying all my bills. When I select a bill in the listbox it displays the due date, amount, etc. on the current form. I have a command button to open another form to "pay the bill". When this form...