Search results for query: *

Cr10Dev Sql Server 08 I need to create a formula that displays daily attendance, attendance is taken for each class period. I only need to show they were absent if they missed 5 or more periods per day, then have a running total of their absences. Not sure where to start. Currently my...

Cr10 Dev SQL Server 2005 I have a report that sometimes will go to 5 pages and I need to have page six blank for duplex printing. This problem is when I have page N of M in the page footer. I have tried Remainder(PageNumber,2) <> 0 but still having issues. My sections are: PH 2a - 2b GH1a -...

CR10 Dev SQL Server 2005 I have a shared variable that I pass from the main report to a sub report. I have placed the formula in the main report group header 1a. Everything passes to my subreport fine which is in group header 1d, the trick I am having is I can not insert a max summary in my...

I just found the answer on Ken Hamady's site which is exactly what you guys posted. It is a string Parameter. Thanks, GJ

Cr10 Dev SQL 2005 I have a parameter where a user may select multiple values. My issue is when I try to display all the values on the report I am only getting the first one that was selected. The options I have selected are Allow multiple values and Discrete Value(s). Not sure why when 1 or...

I am wondering if anyone knows of a way to take a 32bit argb color and convert that into an RGB() color? Cr 10 Dev Sql Server 2005 Express Thanks, Gj

Thanks for the reply, what I am after is the author with the highest total, I re-wrote the query. Select count(oi.order#) as Total, a.fname, a.lname from author a join bookauthor ba on a.authorid = ba.authorid join books b on ba.isbn = b.isbn join orderitems oi on b.isbn = oi.isbn Group By...

I have a query I wrote in Oracle but I can not seem to get it to work in MS SQL 2005. I need to get the name of the author with the most orders. The query below gives me the name and the max count, but I only want to see the name. That is where I am hung up. (Select fname, Max(TotalB) as...

Cr10 Dev MS SQL 2005 I have an object that is set to grow, what I am wondering is if that object does grow can I tell another object to grow the same height? I am not sure if this is possible I have looked around and have not found anything so I thought I would check here. Thanks, GJ

This is from Crystal 10 Dev. help: Changing the chart's legend text On the Preview tab, click the text in your chart's legend to select it. Tip: Be sure to select the text and not the entire legend. Right-click the legend text and select Edit Axis Label from the shortcut menu. In the...

Thanks for the replies. GJ

I have ~ 300 records where I have the UNC path to files that relate to my records. What I am trying is to follow the path and retrieve and insert the datemodifiedlast into the same table as my records. Not sure on where to start. I know how to write the code to select my field, just unsure on...

[Current_User,Software,Crystal Decisions,10.0,Crystal Reports,Formula Workshop,Main,ToolBar-Bar3] The name was visibility, set it to a 1. GJ

In Cr10 Developer there is a registry setting for the save toolbar that has a visibility setting. 1 to show 0 to hide. Not sure about Enterprise but for developer it worked. GJ

It's possible that you have null values. Try this for your last line. If(IsNull({CnBio.CnBio_Age}) Or {CnBio.CnBio_Age} = '') Then 'Unknown' GJ

Create a parameter using your date field and then create a formula off of your date parameter to format your data the way you want it to display. GJ

Using version 9.0 pro pulling from DB2 All together I have 4 formulas. 1st formula gives me the ordinal date: ToText(year(today),0,"") & ToText(datediff("d",date(year(today),1,1),today),0,"") 2nd is just a value: NumberVar Key:= 5; Totext(key,0,"") 3rd is my 14 digit number...

I have 2 formulas that I am multiplying, 1st formula is 6 digits, and 2nd formula is 14 digits. My result shows up as 9.61e+019. I need the result to be the whole number. Any ideas. Thanks, Glenn

I have a query where I only want the previous weeks data. I have it working in Access but I can not get this to work in Excel. Using Office 2k, querying DB2 database. Any suggestions? Thanks, Gj ((Format([SHARE]![CLOSE_DATE],"wwyy"))=Format(DateAdd('ww',-1,Date()),"wwyy")))

I created a formula which worked out. Don't use word very much, so not familiar with it. Thanks for the advice, Gj