Recent content by CuteGeek

Can you send me the statement? If I am understanding you correctly it seems that you would be able to take those individual statements and put them in Temp tables(#) then pull in your fields through a main select statement. cutegeek

Error Message: The report parameter ‘prmPI’ has a DefaultValue or a ValidValue that depends on the report parameter “prmPI”. Forward dependencies are not valid. I have created a dataset that shows the below query: this is working. SELECT 0 AS ID, 'All' AS name UNION SELECT DISTINCT per.ID...

Thanks you guys:) I was taking the long way around trying to write a stored procedure:) I figured it out yesterday evening. Have a good one...and thanks again

Hello, I have a report that I need to only select the below records. How do I do this when there is nothing in the database that make them distinct. Group 1 14987 Acount Number Company 14987 100 14987 300 14987 200 14987 100 Group 1 23444 Acount...

Hey Everyone, This post help me to resolve my issue...Love this site... Thanks CuteGeek [gorgeous]

Hey boys and Girls...Happy New Year I started in the IT department 6 years ago on the helpdesk. Since I was dabbling in everything from the network, database, and programming I found what was best for me and kept my attention. I am now a Crystal Report Developer and work with sql just as...

I have two reports that are using the same tables and fields. The difference is in the where statement that will pull different data for the graphs. What I would like to have is at the begining of the two reports are graphs. I guess I am looking for a way to page break after the first report...

Happy New Year!!! Thank you guys I will try what has been suggested. Will let you know if this helps.... Thanks again CuteGeek

Thank you for responding.... dfESaledate is a date field and yes I want this report to pull every Tuesday of the month.... Sale Date for this month Dec is Jan. 07 after Jan. 07 than the new sale date is Feb. 05. I need the report to automatically change according to the sale date and current...

Hello Everyone, I have a rather deep question:) Having a getdate in the where statement to pull data of all files associated with the month of saledate. Field is dfeSaledate (pulls date of every 1st Tuesday of the month) Example: November 18th Saledate December 3rd (1st Tuesday of...

Hello, If you want to get the first or last record in a group no matter if it has numbers or alpha you can do this in the Details format section. Example: File Number for one file that has many records. Choose Suppress, no-drill down, x+2 Type: not onfirstrecord and {tblFCMain.sFCFileNumber}...

Example: {FirstName} + {LastName} You have to put a space before and after +