Search results for query: *

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.

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

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

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

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.

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.

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

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

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

hello All! i have written a stored Procedure, i got 7 breakdown Options. for Example A, B, C, D, E, F, G, Now let say i got a table having calulted data in fields tablename (A, b, c, d, e, f, g, CalulatedAccounts, CalcultedSum, TotalProfit) now let say i am returing my data...

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 ?

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

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

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

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

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

hi there. i want to create a stored procedure, which will drop a table A 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...

Thanks A lot. that was very helpful.

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,

thanks for your reply. i want to calculate the accural over the weekend but there are 4 different Scenarios. i will give u some examples to explian. "Code" BusinessDay actual(accrual) results (i want) Thurs 2,739.72 2,739.72 Fri...