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. Crystalboy1

    Subreports run without parameters...(Generating data)

    Yes i do link the sub and main report (by right clicking on subreport then subreport links).but by doing so they dont appear in the record selection of the subreport. as there is a stored procedure in the subreport.
  2. Crystalboy1

    Subreports run without parameters...(Generating data)

    @Ibass. No there is nothing in subreport->report->selection formula. and i think this is how it should be.
  3. Crystalboy1

    Subreports run without parameters...(Generating data)

    Another strange finding. The reports are published in an Application, (not crystal server). from where the users run there reports. to my surprise it runs just once from the application, only for the right report ID. neither it give the error "the value for 1 or more then 1 parameter is...
  4. Crystalboy1

    Subreports run without parameters...(Generating data)

    @Madawc: i already have tried this, i put in the parameter values to see what does it returns. but like i said,the stored procedure is triggered frist without the ReportID, and then with the reportID. i worked on crystal reports for almost 8 years. and never had this problem with subreports...
  5. Crystalboy1

    Subreports run without parameters...(Generating data)

    thanks for your reply. well like you said it does matter in crystal where do you put the subreports. so initally i put them in the report header. then i moved them to report Footer. but still it doesnt make any difference.
  6. Crystalboy1

    Sub Report Run without Parameters.

    PLZZZZ dont REPLY to this Thread. it was posted by mistake. i already have posted this thread in the Crystal Reports 2 data Access section. Plz reply there not here. thanks and sorry for in convinence.
  7. Crystalboy1

    Subreports run without parameters...(Generating data)

    hi all. While developing reports, I noticed a very strange problem. Let me explain what I am doing and how. I got a MainReport, which got 2 SubReport. The MianReport, I got 1 parameter Rundate, I execute a stored Procedure in the Command line to generate a Report ID. Example Code is...
  8. Crystalboy1

    Sub Report Run without Parameters.

    hi All, While developing reports, I noticed a very strange problem. Let me explain what I am doing and how. I got a MainReport, which got 2 SubReport. The MianReport, I got 1 parameter Rundate, I execute a stored Procedure in the COMMAD (database object) to generate a Report ID. Example...
  9. Crystalboy1

    picking descriptions of multiple value parameters

    hello All, I got a report (container report) which got 4 sub-reports. All the 4 subreports extracts data through Tsql Stored Procedures. in the paramters field, i got 1 which i can seelect multiples values for. i select multiple values paratmer in the container report, do a formula to using...
  10. Crystalboy1

    Grouping on 7 Parameter Fields

    ...calulted data in fields tablename (A, b, c, d, e, f, g, CalulatedAccounts, CalcultedSum, TotalProfit) now let say i am returing my data ************************************************ Example No 1 Now if i have selected A,D,G and the reset of paramenters that is B,C,E,F are NULL then i...
  11. Crystalboy1

    Replacing TSQL stored Procedure by Command Object

    yes Ian, the Stored Procedure is in the Live system. remember i want to replace a OLEDB(Ado) link Stored Procedure by a Command Object and my Aim is not to loose all the fields on the report ?
  12. Crystalboy1

    Replacing TSQL stored Procedure by Command Object

    hi there, I recently worte a few new very complecated and long reports for a new client. these reports were written on the test instance of the database. after the UAT i ask them should i map them to live database. they said no Need of it as when we publish reports in there system, the system...
  13. Crystalboy1

    dynamic insert in a table

    ok sorry. let me explain it a bit more to you. in simple words i want to do insertions of records in a table first, then will run the update on the same table to update a few fields. I am using Oracle 10 G. IF i do all this process in a procedure then usually in the last part of procedure, we...
  14. Crystalboy1

    dynamic insert in a table

    HI THERE, i got a bit table, where i will be putting annual calcuLated data for future use. now the problem is they want it all automated. i cannot create a function becuase at the end it will not return any data but will insert the calculated data into a table. saME way a procedure WILL NEED...
  15. Crystalboy1

    select statment please help

    I want to do a select statement to fill a table . the field in the tables are as follows CustomerID Amount band 1 Amount band 2 Amount band 3 Amount band 4 …..Amount band 12 the band selection criteria given below. • Period Band 1 - Up to 1 year • Period Band 2 - Over 1 but not over 2...
  16. Crystalboy1

    is it possible to schedule a create table job ?

    Yes there might be times when the table structure will change...
  17. Crystalboy1

    is it possible to schedule a create table job ?

    ...frist, then will create the table A again wid fresh data e,g create stored procedure ABC as begin execute immediate 'drop table A'; create table A as select * from longQuery.... ; end now i want to sechedule a job to exec this stored procedure ? is it possible if not, whats the...
  18. Crystalboy1

    NEED HELP WITH TO BUILT QUERY

    Thanks A lot. that was very helpful.
  19. Crystalboy1

    NEED HELP WITH TO BUILT QUERY

    No there are no rows in the table for Satarday and Sunday. Yes the figure will be that of the Last friday/Next Monday. Currently the amount is 2739.72 for all the rows but there is a column for it,so i will use that column name in calculation incase it changes in future,
  20. Crystalboy1

    NEED HELP WITH TO BUILT QUERY

    ...actual(accrual) results (i want) Thurs 2,739.72 2,739.72 Fri 2,739.72 8,219.18 * sat Sun Mon 2,739.72 "Code" Explaintion of the above is that the we have multipiled the...

Part and Inventory Search

Back
Top