Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. RWahlert

    Passing parameter to sub-report the uses a SQL command.

    Thank you. Your suggestion did the trick.
  2. RWahlert

    Passing parameter to sub-report the uses a SQL command.

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

    Passing parameter to sub-report the uses a SQL command.

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

    Shared numbervar subreport info showing twice on main report

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

    Fields Missing in database expoert

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

    Summing

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

    Summing

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

    Comparing part of a text string

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

    Adding nvarchar values

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

    Adding nvarchar values

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

    Cross Tab: substituting values if 0

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

    Cross Tab: substituting values if 0

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

    Cross Tab: substituting values if 0

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

    Cross Tab: substituting values if 0

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

    Cross Tab: substituting values if 0

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

    Variable Data from subreports not calculating properly

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

    Cross Tab: substituting values if 0

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

    Calculating difference in cross tab columns

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

    Cross tab aging

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

    Can export to XLS but NOT to CSV

    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.

Part and Inventory Search

Back
Top