Recent content by KidFix

aha! that did the job. You were dead right, the sp param was there all the time its just I thought there was only one item in the drop down Thanks very much

Thanks Reebo, what is the exact syntax I need to enter? I've tried both of these with no success (there are two paraneters to be passed to the subreport): {?@P_Date} = {?Pm-@ConvertFromDate} AND {?@P_Date2} = {?Pm-@ConvertToDate}; {?@P_Date} = {?Pm-@ConvertFromDate}; {?@P_Date2} =...

Hello all my report contains a sub report that uses a stored procedure. For the stored procedure to run it requires two parameters. How can I set it up so that my main report is passing values to these parameters automatically and the subreport isn't promting for values of these parameters on...

the report uses a stored procedure that requires two date parameters to be inputted so if nothing is passed to the report on opening it automatically prompts the user to input the dates, this isn't what I want it to do however, I want to pass the report the two dates in the query string so the...

ello how can I pass a date time into a report prompt? I've already tried: prompt0=01/01/2004 00:00:00 and prompt0=DATETIME(2004,01,01,00,00,00) with no success. Any help would be greatly appreciated

worked a treat! thanks very much

Hi all how can I get the value of a variable in a subreport from my main report? Hopefully this'll be an easy question to answer! If it isn't possible is there any other way I can pass a value back to my main report from a subreport? Thanks peeps!

thanks reebo the report is being filtered not by a parameter but by an sf where (i.e. reportname.rpt?sf={fieldname}=val AND {fieldname2}= etc.) this isn't really a suitable solution for me as it'd take a lot of work to implement, there can be anything up to seven fields being filtered on in...

Thanks for replying I'll try and explain the situation further. The report is for a timesheets application. In my view are three fields (there are more but for simplicity we'll only consider three) PeriodHrs, DayDate and ProjectType. Say this is the data contained in the view: PeriodHrs...

Hi all is there a way I can return two sets of data from the same view within one report? I need to pass in a sf where clause to a report and make a calculation based on one set of data only filtering on the date range passed in by the sf whilst displaying data filtered on the entire sf where...

worked a treat, thanks v much!

ello is there a way I can find the number of records returned in a report for use in a formula? I tried using the special field Record Number but I don't seem to be able to use the value of this field in a formula, all I can find is RecordNumber which returns the number of the current record...

that is if I'm passing the where clause into the report in a query string in the form of report.rpt?sf={op_id} blah blah, how do I select null values of op_id? thanks again, and sorry for the multiple posts!

Thanks for the replies how would I select null records in my sf where?

how would I select null records in my sf where?