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!

  • Congratulations Westi 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. pto160

    Crystal Reports 2008 Shared Variables

    I have a shared variable that is a formula. It does not reference a database field in the formula. I heard that they added a new feature to Crystals Reports 2008 that allows the user to use saved data for parameters. Will this allow the user to use a shared variable in record selection with...
  2. pto160

    Add Shared Variable as User Input Parameter

    No, I am using Crystal Report X1. I probably will call Business Objects to see if is possible to use record selection shared variables with saved data. So using a stored procedure requires me to use sequel commands? I think this is the best option as using the suppression technique is not...
  3. pto160

    Add Shared Variable as User Input Parameter

    I appreciate you looking into this. I sat down with a Crystal Reports developer for 4 hours and we tried the section expert and the report was not processing properly. It would display results that were not equal to the parameter. The solution maybe is to write back to the database and since the...
  4. pto160

    Add Shared Variable as User Input Parameter

    Monthly forecast is a numbervar. Monthly Forecast Formula is: NumberVar Comparsion:= {@Sum Of Qty Shipped}; Shared numberVar Forecast_Days_Stock; NumberVar ReturnVar; if Comparsion <> 0 then ReturnVar:=(Forecast_Days_Stock / Sum ({@Qty Shipped Avg}) * 30) else ReturnVar:=-1; ReturnVar The...
  5. pto160

    Add Shared Variable as User Input Parameter

    The formula is as follows: DateVar ReturnDate; if {@Monthly Forecast}=-1 then ReturnDate:= Date (2099,12 ,31 ); if {@Monthly Forecast} <> -1 then (Shared dateTimeVar Shared_Out_of_Stock_Date :=CurrentDateTime + {@Monthly Forecast} ; ReturnDate:=Date( CurrentDateTime + {@Monthly Forecast}))...
  6. pto160

    Add Shared Variable as User Input Parameter

    I should have issued instructions to download the file. Sorry about that. If you want to save the file. Click the link<Free User<Advanced Download Settings<Download<Save File The download is available under Free User. The File type does not show anything until it is saved on your computer...
  7. pto160

    Add Shared Variable as User Input Parameter

    The parameter is anything equal to or less than 7/31/09 is an example. The out of stock date parameter is entered by the user.
  8. pto160

    Add Shared Variable as User Input Parameter

    I have tried everything under the sun to add this calculated shared date var as a user input parameter without any success. Do I have to use a sequel command or stored procedure to make this work? I think this could be beyond the capability of Crystal Reports since Crystals does not write...
  9. pto160

    Add Shared Variable as User Input Parameter

    Thanks. The shared date Variable is ReturnDate. The subreport and main report is Out of Stock Date, which I link using the subreport links. How do I create the parameter in the subreport equal or less than the user parameter date. I have tried to create the parameter under formulas: Shared...
  10. pto160

    Add Shared Variable as User Input Parameter

    I have a shared variable DateVar called ReturnDate in a subreport called Shipped Qty. This is an inventory forecasting report and the return date is the Out of Stock date. I would like to add this as a user input parameter. So someone puts in 7/31/09 and the report would show all items that have...

Part and Inventory Search

Back
Top