Search results for query: *

Thank you. Your suggestion did the trick.

How are you linking the two parameters? I tried doing that in the record selection formula but I was still presented with the parameter twice and the value was not passed from one to the other. Could you provide a screen shot of how you did this? Thanks. Ralph

I have a report that contains one sub-report. Both the main report and sub-report are using SQL commands. The two reports use the same query in their respective commands. The main report points to a production server and database and the sub-report points to a test server and database. I do this...

It appears to me that you do not need the second formula, as the sub-report should return the value you want. Is the subreport in the details or in a group footer or header? Try taking out the second formula and see what happens.

I had a few reports created that had linked tables using some user defined fields. For some reason, when I ran the reports today I had lost the linking between tables. Whn I tried to relink the talbes the user defined fields I had used where not availalbe in the database expert. I could see...

This gives me a great place to work from. Thanks!!!

...join [@sh_shr1] b on e.DocEntry = b.U_BaseDoc and e.linenum = b.U_Baserow inner join [@sh_oshr] a on b.U_DocNum = a.U_DocNum where E.DocEntry = 4 I want to add up the values in the column u_qtyship or even better, get the sume of b.u_qtyship * e.price Any advise would be greatly appreciated.

I have two tables. One contains zip codes, county names, and salesTaxCode. The second table contains a County,State field, a sales tax percent field, and a salesTaxCode field. I want to strip out the county name from the County,State field. There is a comma seperating the County and State...

Thanks for the help. I got it all working. Ralph

I'm working on a stored procedure that will increment a sored value by 1 when ever a new customer or vendor is created. My customer and vendor numbers are of the format C001234 and V001234 respectively. I want to increment the stored value after a new customer or vendor is created. In other...

Yes, I agree. Plan "B" is looking pretty good to me. I know what I have to do for this. Thanks for all your input and patience. Ralph

LB Sometimes I need a hit in the head with a seldge hammer to see the light. Yes I do have other rowfields, three others in fact for a total of four. The inner most being the cycle. Do I have to create a variable for each rowfield? Is that what I am missing? Thanks for your patience. Ralph

There are other row values between these rows on the actual report. I was trying to give an example of what I am seeing for rows with the same value, i.e. Q. I have row values of Quarterly (Q), Monthly, 28 Days, and Bi-Weekly. I am only concerned about row values of Quarterly. The other...

LB: I've tried both ways, with the same repsults. I have figured out what is happening, but don't know why it's happening. If the cycle is quarterly for a row, and it's the last row of quarterly records on the page then that row works correctly. If there is a second, or third row that is...

LB: Thanks for the reply! This is great stuff and I'm making forward progress. I am running into an issue where the variable is not resetting and I am getting odd results. This is my formula in the supress field: whileprintingrecords; numbervar Cycle; if gridrowcolumnvalue("Cycle") =...

Would you be able to show the formulas where you are passing the data back to the main report from the subreport? Your sample output is not clear to me.

I'm working on a cross tab report that shows the average number of members for a union on a monthly basis. Some groups of the union are only counted quarterly and for the months where they are not counted my report shows 0. I would like to display the value from the months where there is a...

Howdy: I'm working on a report that will display the deferred revenue across many months, usually 1 to 2 years. Each month a small portion of deferred revenue is recognized and subtracted from the total deferred revenue. Example: The original sales transaction is for $12,000. Each month...

I'm trying to creat an aging report based on the due date of the invoice. I would like to use a cross tab report and the aging functions of Crystal. I have formuals created (Example: DueDate in Aged0to30Days)for each of the aging periods I want, and have placed them in the columns and have...

Why are you running a subreport? This may be why you cannot export to the CSV format. You should be able to return all the data you need without the suberport. Does your table contain both invoice and payment data? You should look into doing everything in one report.