Recent content by RWahlert

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

I'm trying to create a sum of all the values returned in a column, i.e. I want to add up all the values of the column quantity. For some, no pun intended, reason this is driving me to fits. This is my select statement: select E.ItemCode, E.Dscription, E.Price, A.U_CardCode, A.U_DocNum...

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