Search results for query: *

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?

hiya if I run my report without any form of select it returns 2,565 records. if I take the same report and use the select expert to return records where op_id = "PPM" it returns 30 records. if I then take the same report again, but change the select so that the report returns...

ello all is there an equivilent to fieldname in (1, 2, 3) (i.e. shorthand version of fieldname=1 or fieldname=2 or fieldname=3) that can be used in an sf querystring I'm passing to a report? And is there any resource that tells me what can and can't be accepted in a passed sf? I've already...

hiya all if I set up a report to use a database other than our usual one (CorpDB) when I try to view the report through a browser it asks me for a username and password to log onto the database. I've checked the data connections on my computer and both CorpDB and the other DB are set up...

ello all is it possible for a report to access a view on a different server? if so, how is it done? Thanks

ello all whenever one of our clients trys to print a report viewed in a browser the printer defaults to a printer other than the default one that every other application on her computer defaults to. Can anyone think why this might be? Thanks