Declare and define parameters in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Dear All

I need to define and declare parameters and varaibles inside the report and
not inside the query. Where Should I Do So? and How.
For example I need to state thatL If [text1]=1 then X=2
where in used in the report and should not be asked for.
Hope I made myself clear.
Thank you all
 
Mohammad

I'm not sure I understand...

Since parameters are used to narrow/limit the amount of data displayed in a
report, why would you not want to do that limiting earlier in the process,
i.e., in the query?

Another approach to parameters (for queries and reports) is to create a form
that solicits the values to be used, then use references inside the
queries/reports to retrieve the values.
 
Dear Jeff Thank you for your reply

I admit that my first post was erroneous whicg lead to missunderstaning.
Please let me reask and go depeer.

I have a situation in report, I have 2 headers , one for studentds and the
other for their corresponding courses. Now i can make listing of student and
under it, the courses like that:
-John
Math
Physics
Chemistry
-James
Calculus
Geometry
Chemistry

Now I want to make the courses in same row (same header) of the student like
that

- John Math Physics Chemistry
-James Calculus Geometry Chemistry ...

This would be achieved because course textbox (that must be populated in the
detail section) will show first value only.

I worked around the problem by putting:
-unbounds textboxes in student header
-[textbox1] =1 in the detail (with running sum) to make serial number.
-I thought that if a code in the detail section declaring varialbe X="Math"
when [textbox1] =1 and Y="Physics" when [textbox1] =2 and do on...

I hope it is clear and hoping to help me with my situation
 
Back
Top