Search results for query: *

How can I install a parameter to prompt a user to type in a "password" in order to run the report? Is there an easier way?

I think I found my own answer, NO. http://support.businessobjects.com/library/kbase/articles/c2010131.asp Had to try.

Thadeus, Yes, maybe I am using a knife. I don't know anything about Access. At this time, I have a crystal report generating an excel output file (data only) that is emailed to me daily. I take the file and append it to a master excel spreadsheet. I would like crystal to output directly to...

Query tool to populate a DB to run from.

The "Allow Docking" option is not accepting the selection. I can turn the other two trees on and off, but the Field Tree is stuck off (check mark never appears).

The field tree has floated free! The other two are still docked but the field tree refuses. Help!

Crystal 9 How do I have a report output to a database (excel or access format) and have subsequent runs of the report append the same database file. The database file will be accessed by another report periodically to extract information.

Crystal 9 Formula Workshop Undocked the field tree, function tree and operator tree. Can right click function and operator to "Allow Docking" but no success on making "check" reappear for field tree. Seems stuck in floating mode.

Crystal 9 I need to monitor parts to stock and status of completion: Part No. OnHandQty ShipQty 1000-22 20 10 1000-22 20 1000-22 15 1022-05 30 10 1022-05...

Crystal 9 Having trouble setting up a View to create a table where I can store "running totals" for specific field data. I have a date received, part number and qty received (Date, Part, Qty). I must sort by date but I want to show a running total of qty recieved: Date...

Lyanch, "To get the "amt remaining" set up a subselect in your query that totals up all uses for the current partnumber up to (and including) the current date." BullsEye! That's what I am trying to do. I believe the "subselect in your query" means to include the...

Synapsevampire, Thanks for getting in on this one, your help on other issues I have raised has been most helpful! I am researching the View option. The report is for tracking availability of parts for outgoing sales orders. The on-hand qty starts as my current stock (yes, from my MRP). I...

Nagornyi, The running total is not to be displayed, it is to be used behine the scenes to furnish data to the updated QtyOnHand, which is one column. Lyanch, Have Crystal 9, add commands?, how can I "easily handle in a stored procedure"? Are you refering to use of array vaiables? My...

Nagornyi, Yes, 1000 parts tracking independently. Madawc, Speed is not important (overnight batch), could you show me more of how to setup this subreport idea? I've tried subreports and shared variables with no success. Thanks

Good idea, but I have 1000 part numbers.

Crystal Reports 9 I have a data source that contains monthly details of sales forecast for each product: Part No. Month SalesQty 7000-01 1-04 100 7000-01 2-04 250 etc SubTotal 2,500 I have a report that needs to include only the SubTotal amount...

Crystal Reports 9 I have a simple report that I want to add a running calculation for on hand inventory and order shortages: ShipDate Part No. ShipQty OnHandQty ShortQty 1-10-04 7000-01 10 15 0 1-10-04 8125-99 20 40...

Crystal Reports 9 Is there a way to have a line or graphic image conditionally suppressed? Thanks

I have a .mdb file that I keep appending tables to. How can I delete the tables I no longer need. I'm using Crystal Reports 9 to export a .rpt file to ODBC format into my existing .mdb file (using xtreme.mdb). Each time I have create a new table name. Thanks

How do I create a database file .mdb using crystal? I have access to data in ODBC, but I need to have it summarized into a table so I can use it in other crystal reports. I don't want to use subreports. I don't have Access. I can easily create a .rpt file for what I want, but I can't find a...