Scheduling reports w/ parameters 1

[cisscott]

Hi again guys. I am trying to set up a couple reports to run on a daily schedule. Problem is, each day, the parameter changes for the report to match that days' event code. For instance on June 6 I will need to run report JO0606 and June 7 it will be JO0607. Is there a way to run the report automically with a new parameter each time? Thanks !

 

[synapsevampire]

Create a formula to generate the code instead of using a parameter:

//@dayprompt
"JO"+totext(currentdate,"MMdd")

In the Report->Edit Selection Formual->Record use:

{table.field} = @dayprompt

If the JO is something that is computed, do that as well.

-k

 

[cisscott]

Ok, synapsevampire. Thanks for that post, it opened a little door for me. I'm just stuck on one thing in getting this working. I currently use CR 9 and CE. The report I am editing is imported from a set of CR 8.0 custom reports. I set it up to generate the data using a formula, which works fine it seems. However, the parameters that ask for "year" and "event" when the report is run are still in there. and I cannot delete them. I know they have to be deleted from any formulas they are used in first, but I have combed all formulas, the section expert, and I cannot see anywhere I can delete them. They have the little checkmark that indicates they are used in something. Any idea how I can figure out how to get them out of there? Thanks !

 

[Nuffsaid]

Hi,

Change the data type of the parameters, this will cause any formulas that use then to error out.

Nuffsaid.

 

[cisscott]

It will not allow me to change the data type either. That option is greyed out. I've looked for a way to do it manually, but, still stuck. Thanks.

 

[bessebo]

I would just create a stored procedure that would collect the data and would also create the prompt based on the date you run it. This is the easiest way that I know of and this would be the way that I would handle it.

Regards,
Bessebo

 

[bobisto]

Maybe parameters are used in some field formatting formula or something like that. You can check that or just delete fields and insert them again.
If you never need that report for date that isn’t the current date then don't use parameters, in which I don't believe.

 

[SuzanneColson]

I have run into this problem with parameters. Trying to find where they are, etc. I create an export file of the Report Definition and search for the parameter within that document. Go to File, Export and choose Report Definition for the format and send to a disk file.

Hope this helps.

Suzanne

 

[rptnut]

I have used Suzannes's method to find field references.

As or the date parameter, we ran into this also - we want to be able to schedule a report everyday with yesterday's date and ba able to schedule the same report and pass a date. So we use stored procedures and schedule with a dummy date of 1/1/2000. The proc interprets this as yesterday. Otherwise it uses the date that is passed in.

 

[cisscott]

THeres so much good info in this thread ! I ended up finding the problem, the variables were located in the stored procedure and the SP was passing the values into the report as another variable so it was a little hard to track. I got hold of the guy who made the report and he straightened me out on how it was all set up. Heres another question. This same report has an OLE object in it, that is most likley a bitmap image. I need to edit it, and I cannot find it anywhere. Is there a place that shows the path to an OLE object that has been inserted?