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 strongm 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. EdwinBB

    Help! Parameters prompts twice.

    Hi Guys, Newbie here. I am working on a report using oracle package/stored procedures with parameters inside WHERE clause of the procedure. But when I use the proc as my datasource, layout the report and run it, it worked fine. Not until i changed the property of one of any parameters from...
  2. EdwinBB

    CR XI Asks for parameters twice

    Here's a snipped of my Store Proc and assumed that i declared the REF CUR in another package and working fine. Except that it asked me of paramater values twice. What do you think? Thanks for ur interest and for ur reply. CREATE OR REPLACE PROCEDURE xxlootcfa_main_proc( rfq_cursor IN...
  3. EdwinBB

    CR XI Asks for parameters twice

    Hi Guys, Crystal Report XI Oracle 9.2 I have few parameters inside my Stored Procedure. SO when I attached it in my Crystal Report, it populated all parameters (with Static LOV)in Paramters Fields. So when I ran it, it worked fine. But when I modified the property of those parameters to have...
  4. EdwinBB

    Parameters

    It's me again! Crystal Rep XI Oracle 9i I have five parameters say, Invoice_No_FRom, INvoice_No_To, INvoice_date_from and Invoice_No_to and INVOICE_TYPE. I will be using all these parameters for my Selection Expert section but then, how can i make my formula work so that if they entered NULL...
  5. EdwinBB

    Stored Proc

    Hey Guys, Crystal Rep XI Oracle 9i My question is, what is the best way to use Store Proc. My experience is. If I include the procedure inside and the Package along with the definition of REF CUR, i can't see the stored prod in the list of procesdures that i can use as datasource in Crystal...
  6. EdwinBB

    Stored Proc and Table slows the report?

    SOrry. Here it is. CR XI, Oracle 9.02 and BOEnterprise XI. THanks for ur reply.
  7. EdwinBB

    Multiple Store Procedure

    Thanks for your immediate reply. SOrry, I forgot tell u about the tools I am using. Here it is, Im using CR XI and Oracle 9.02. And these reports will be published on BOE XI. What are the performance issues? I have this scenario when i tried to UPDATE the procedure and my CR just crashes...
  8. EdwinBB

    Multiple Store Procedure

    Hi Guys, Is it possible to have multiple data source in a report. Say, one Stored Procedure and one table/view? Or is it possible to have 5 stored Procedure in one report? Thanks in advance. Ed
  9. EdwinBB

    Stored Proc and Table slows the report?

    Hey Guys, I am working on a report using stored procedure. It works fine but when i added a table as a source table for my parameters, it slows down the report or worst it just hang. Any suggestions or work around on this? Ed

Part and Inventory Search

Back
Top