Search results for query: *

I am working on a query that has the following fields T1.FirstName, T1.LastName, T1.SSN, T1.Date, T1.Address, T1.City, T1.ST, T1.ZIP, T2.Rep sample data T1.FirstName, T1.LastName, T1.SSN, T1.Date, T1.Address, T1.City, T1.ST, T1.ZIP, T2.Rep John,Doe,500-22-1234,2010-12-10,123 N...

I am trying to clean up a report that displays information about a network resource (resources) and a subreport (tasks) with a basic to-do list. The two reports are linked together by ResourceID. Sample Report (how it looks now): Primary Domain Controller [Group Header] -Install updates...

I am trying to create a report that will skip the header, if there is no data in the detail section. I've looked and haven't found anything yet.

This is really simple, but I can't figure it out. I am trying to concatenate to fields in an Access 2007 report. Both are text fields (size 255) This is what I have entered: =[Field1] & " " & [Field2] Every time I go to Print Preview it shows #Error Update: I can put [Field1] in an empty...

I would like to display a watermark on a report (to grab the attention of the reader) if one box is checked. Note, I don't want the box to appear anywhere on the report, this is easy. But I want the image (preferably a watermark) to appear behind the text to catch the readers eye. It appears I...

I am using Access 2007: I have a report that I have turned the "keep together" set to yes on the Group Header and on the Detail section. But my report still is randomly putting the detail onto the next page with most of the page with the Group Header being blank. Help!!

I am still working on this project (http://www.tek-tips.com/viewthread.cfm?qid=1482865&page=1) This is the row {Table1.Field4} I was trying to parse earlier and separate each field (Thanks to lbass I was able to get it) Formula Field: @PIX_Code Right(Left({Table1.Field4},13),12) Now I am...

I am looking for a RegEx or the CR equivalent of RegEx to parse a PIX syslog. I looked in the help file and couldn't find anything that looked promising. I am using SQL Server 2000 as my backend database.

I have a formula with several conditions that I would like to format the text color if only a couple of the conditions are met. How can this be done in the formula workshop, note i cannot use the highlighting expert because i am concatenating two fields together and adding explanatory text, so...

Hello, my reports are not working after installing SP2 upgrade for CRXI Developer. The reports would dynamically list all available dates. Now it appears to be listing the dates of all records. The report itself has not changed, just installing SP2. Has anyone ran into a similar problem?

How can I by default select Yesterday's records for a report using the Select Expert?

How can I return the date in the report paramater as "2006" instead of "2,006.00" I am using this code to return the date: Year({?@Beginning_Date}) I have tried Cstr, ToText, ToNumber with no success.

How can I convert the @Beginning_Date (Report Parameter) to a MonthName I tried the following: "Document Name: " & chr(34) & "Test" & chr(34) & " Document Note: " & chr(34) & MonthName({@Beginning_Date},True) & ", " & Year({?@Beginning_Date}) & chr(34) that wont work because...

How can I format a Dynamic List so only the date shows as a date instead of a date & time?

Hello all: I am using CR Server XI, I have a report that will not dynamically list dates when a user goes to preview the report. What am I missing. Thanks

How can I return the time from a date/time field? I tried DateSerial(MYDB.DateTime) That didnt work, any ideas?

What formula do I use in Record | Select Expert to show dates less than the current date and time? {Hist.RecDate} <= DateTime X I tried Now(), Now, CurrentTime none of them worked. {Hist.RecDate} <= DateTime(Now) Didnt give me an error but it returned no records. Thanks

How can I show a record that the date/time is between two dates/times? For example a database showing when an item should be shipped. CurrentDate = 7/13/2006 StartDT = 7/10/2006 (Order can ship as early as now) EndDT = 7/20/2006 (Order must ship immediately) How can I pull up orders that can...

Hi all: Is there a way I can monitor changes to a SQL Server Database? I have an applications SQL DB that has over 600+ tables. I am just looking for one change, so I can create a backup. I want to monitor all tables at once, since I am not sure which one is the one I need. Is this possible...

Hi all: Is there a way I can monitor changes to a SQL Server Database? I have an applications SQL DB that has over 600+ tables. I am just looking for one change, so I can create a backup. I want to monitor all tables at once, since I am not sure which one is the one I need. Is this possible...