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...

My thanks to both of you who replied. After putting away my report and leaving it for a while I was able to go back and finally get it to work. I had already done that once or twice before but this time I figured out what I was doing wrong. For those of you who might be interested in this post...

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...

That worked! Thanks a lot!

That did it! Thanks!!

@targetdate formula is as follows: //Before processing - What date records do we want to keep WhileReadingRecords; //Define Holiday Array containing dates //Define Target date as the current date. //Define 2 number variables Add and Added used to cycle within the array DateVar...

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

Sorry to be so long in getting back. I tried what you said but couldn't get it to work. I want the message "no records today" to appear after my column headings where detail lines would normally go if there were records. I tried applying your instructions creating a detail-a and a detail-b. The...

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...

Thanks to everyone for their suggestions. I'm not sure if the person who wants to hide the data will want to go to all the trouble. I'll suggest the veryhidden but I bet they will choose to keep 2 spreadsheets and manually keep them synched.

Thanks Dirk Yes I would like to prevent the column from being read. Any ideas?

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 created a formula field called dept with the following code: If IsNull({CR_View_for_Steve.Department}) then "no department specified" else {CR_View_for_Steve.Department} When you go into the data tab in chart expert the grouping layout doesn't show the formula @dept. If I try using...

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...

Thanks...I figured out the answer to my first question. I was basing the chart on the group value but I had selected it both in the advanced section and the grouping section of the chart. I'm still trying to figure out the answer to my second question.

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...

Thanks for the help. I had tried that already and it wasn't making any difference. I did manage to figure it out however. I had a sort option that sorted the field in ascending order. When I changed it to none it arranged the groups the way I wanted. Thanks again