Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: chrisgeek
  • Content: Threads
  • Order by date
  1. chrisgeek

    Question on Basic Syntax Supression formula

    Hi I have a question on Basic Syntax supression formula. Currently on Crystal XI with SQL 2005. The formula is Global iCount as number WhilePrintingRecords If {mainprocedure;1.entry1} = 100 then iCount = iCount + 1 Formula = False ELSE Formula = True End if This formula...
  2. chrisgeek

    Date Variable Question

    My issue here is I don't truly understand how variables work. I get that you create one and give it some data and it uses that in the query. My issue is with a datetime variable SQL is storing it as 2010-08-01 00:00:00 and when I give it that data in crystal or sql everything runs fine...
  3. chrisgeek

    Need to create a formula that compares values from details

    Hello, I am writing a report and need to create some statistics. The report is showing findings that can be anywhere from "0/10" - "10/10" and can be returned in any frequency or order. For example The results might be 10/10, 10/10, 0/10, 5/10, 10/10. I would like to be able to say if the...
  4. chrisgeek

    display crystal reports grouped data horizontally

    How can I change my grouped data display from vertical to horizontal? Example: group 1 is the abbreviation and in that group is the name and value of that field. I'd like to display the names and values horizontally. This replaces an excel spreadsheet so I'd like the formatting to be similar...
  5. chrisgeek

    counting 2 different subreports

    This is a convoluted solution to a temoprary issue so I don't want to use a stored procedure for it although I may have to. I have 2 different sub reports the first which gives me how many people are in attendance and the second showing me the ones who are in a certain room. I used a shared...
  6. chrisgeek

    Is there a way to show a summary of the report logic?

    I think I have seen this once but can't find it so I'm looking for some help. What I would like to see if possible would be a printout of the various items that go into producing the report like selection criteria, supression criteria, display string fields etc... this is so when I have to...
  7. chrisgeek

    Changed datasource location but query is still using the old one

    SQL 2000 with Crystal 10. The report consists of two views that are inner joined. The databases are a production and a test which are mirror images. The only difference is the db name. I am attempting to change the data source on a report but it's giving me an error with a description of...
  8. chrisgeek

    Can I have Access open a Report on open

    I have a form/query/report all together and I'm wondering if I can have Access open this report automatically on open. I can't seem to figure out the VBA that will do this. Thanks in advance, Chris
  9. chrisgeek

    if then else not working as desired

    I'm using an IF THEN ELSE statement to display a string. the field type is varchar and can be null. My Statements are: IF ISNULL ({storedprocedure.fieldname})Then "None" ELSE IF TRIM({storedprocedure.fieldname})= "" Then "NONE" Else IF {storedprocedure.fieldname} = "Contact" THEN "Contact"...
  10. chrisgeek

    Need supression formula for section based on shared variable value

    I have a report that returns a list of people and then the subreport returns data when they have a specific order. I have created a variable that counts the non-blank subreports. The data I want to suppress is located in details section A and the counting formula I want to base the...
  11. chrisgeek

    Need to return a maximum number of records while accepting duplicates

    I'm working on a subreport and I need to limit the number of records that I return. I need to return the 4 most recent entries to the 'values' field. I have already filtered it down to 5 potential items which could be found in any order when the record returns. I think what I need to do is...
  12. chrisgeek

    How can I Count Subreports

    I need a count for a census. I have the subreport located in a group header which is supressed when blank. I am calculating my general data already but need to count the sub reports so that I can determine what percentage of people have data returned by the subreport. Any help you can provide...
  13. chrisgeek

    problem converting boolean to string

    I am working with a report that I need to sort by items that have not been charged. In this case the "is charged" field is a boolean with an answer of Yes or left null. The select expert doesn't work with false as the field is null. When I try to use Cstr it tells me the formula must result...

Part and Inventory Search

Back
Top