Search results for query: *

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

The field is datetime what I did was change the stored procedure to select table.field, CONVERT (Nvarchar, 10, 101) which should change the select to US style dates of MM/DD/YYYY and allow everything to flow smoothly. I can't test it as of now due to server maintenance but I think this is going...

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

Thank you very much for your assistance I couldn't have done it without you.

As always you are correct. Any hints on using the variables to summarize this. Working perfectly so far :)

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

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

Thanks for the reply that may work and I'll be trying that in a second. I'm trying to understand the way this works especially as it comes to declaring the variable. I created the reset formulas in GH_a which are whileprintingrecords; shared numbervar place := 0; whileprintingrecords...

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

Thanks for your help. That's exactly it!

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

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

That's it exactly. Thanks!

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

I created a formula as follows: IF ISNULL ({storedprocedure.fieldname}) THEN "None:" ELSE SELECT {storedprocedure.fieldname} Case "Contact": "Contact" Case "M": "Middle" Case "A": "First" CASE "C": "Last Row" Default: "None" This...

No it's just a SP and this is the primary table in the SP. I'm assuming that there is something wrong with the ISNULL or the "" statement. The history of this is I have an primary application/database (which I can't access) that displays "contact', "First" etc... It's interfaced to the...

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

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

Top N Required a summary value so I had to pass on that but I'll keep it in mind for later report. Thanks for the suggestion. I decided that I would create a group and then put the field in the group header so I would get the most recent of each group. Thanks, Chris

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