Search results for query: *

They leading digits can be different. Primarily based on whether it is an incoming our outgoing call. Outgoing calls record the 9 required to dial out. But I will try the code when I get back to my desk Monday.

I am using Crystal 2008. (I erroneously said 2013 before, but I use that elsewhere) The definition of @LastTen is: stringVar s := right({connect2.PartyID},10); left(s,3) + "-" + mid(s,4,3) + "-" + right(s,4) I believe the equivalent in mySQL is left(right(C2.PartyID,10),3) + "-" +...

Thank you for the response lbass. The report Groups individuals phones first and shows names of the phone owner for group 1. Then Group 2 groups by external phone numbers and sums the total time for the top 5 external numbers. The report filters for the last full month. What I am looking to do...

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

Thanks for those suggestions. I won't get a chance to get back to this until Monday or Tuesday. I'll let you know.

I've tried a few different things, but still get the error "No value given for one or more required parameters". The following will bring back data as well, but as soon as I replace the date with a ?, I get the error. DECLARE @FromDate datetime, @ToDate datetime set @FromDate = '1/1/2016'; set...

Thanks for the reply. After replacing the Date/Time values with a ? and hitting OK, I get the error "No value given for one or more required parameters". You said I may need to supply two date parameters, but none were ever asked for.

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

Ultimately I ended up exporting it to a spreadsheet to get the desired effect:

Again, it works fine to set the background color based on GridRowColumnValue if you are setting it from either the Column Header or the subtotal field. But the header that just says "Total" cannot reference the GridRowColumnValue of the column name it is under.

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

It's been years since I created this report, So I deleted the image and re-inserted and set the location formula up again. I got the same result and then realized the "Lock Position and Size" checkbox was not checked and the "can grow" checkbox was checked. I checked the first and unchecked the...

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?

Both. Mostly I was just curious about exporting cross-tabs to excel. I have selected the cells in excel and selected Conditional Formatting -> Color Scales and then selected a similar color scheme and that works fine.

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

Even if there were more auto macros that fired when at the start of each section etc, it could be done. But so far the only auto macros are: AutoExec (When you start Word or load a global template) AutoNew (Each time you create a new document) AutoOpen (Each time you open an existing document)...

Agreed Tony! I was surprised that there wasn't a way to permanently set these footers without having to change them when an additional page is created or removed. Since there is a way to reset the page numbers at the start of each section and there is a way to keep then sequential throughout the...

That link led to this one http://www.word.mvps.org/FAQs/Numbering/PageNumbering.htm Which allowed me to do codes like { = { PAGE } -12 } at the start of each section. Thanks

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