Recent content by chrisgeek

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