Recent content by src2

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