Jump to report option giving error

Question

Post reply

Jump to report option giving error

malavika.ramanathan

SSCrazy

Points: 2790
More actions
April 27, 2010 at 1:47 am

#223932

Hi All,
I have a report which calls a subreport. i have given the jump to report option in the navigation tab.
now, my prob is , the parameters from the main report are not passed to the subreport.
m not able to set the parameters to be non queried as i dont have an option on my right to assign a value to the parameter in parameter properties window.
please help

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Dan.Humphries SSChampion Points: 12125 More actions · Answer 1

In the navigation tab you should be able to select the parameters you want to be passed have you defined those?

Dan

If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 2

I get only the parameter list on the left. but the matching expression on the right side is not found in the navigation tab.

Thanks for reply.

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 3

Hi,

Can you just check and make sure that your subreport has some paramter and the and the dataset is expecting that parameter.To do this do to the dataset of the subreport and execute it.

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 4

Hi Mithun,

Thanks a lot for your reply. Yes i had missed out the parameter datasets.

Now it is seen. But the prob is only the FIRST record from the parent report is passed to the subreport.

l mean if you select two customers A and B in the main report and click on any of them to see the details ,you can SEE ONLY DETAILS OF A no matter what you select to view details.

what may be wrong?

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 5

Hi Ramanathan,

If my understanding is correct, In your main report you have two columns say A and B , you want to jump to the Subreport by clicking the value in column A.

If this is the case, I hope in the detail section of the column A you right clicked and went to the property,then in the navigation tab you gave the Jump to report option and in the parameter option you did the mapping like , for the Parameter name you selected the Parameter Name of the Sub report and for the value you selected ColumnAField!.value

Now the subreport dataset will retrieve the result corresponding to the value of column A on which you clicked.

Before running the Main report just check whether the Sub report dataset is expecting any more parameter(by executing the Dataset alone). If it is expecting any more parameter pass it as required(from the main report or from the sub report itself).

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 6

hi,

I have done the same way you mentioned. the no of parameters in both the reports are equal. and in the subreport all the parameters will be non-queried.

if i run the subreport it is working for all the users.

so i am not able to trace out the prob.

one more thing, when we click on the user name in the main report and when it moves to the subreport, i am seeing the parameters of subreport.

can i avoid this by making them HIDDEN or INTERNAL?

will this affect the working of my report?

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 7

Hi,

Those parameters (for which you are passing value from main report) can be made hidden forsure. In case of other parameters,it is upto the requirement ,if you want to allow the user to select the values dont make it hidden. If at all making it hidden,dont forget to give some default value(with = sign incase of integer value)

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 8

Oh ok . that will make my report look much better. 🙂

but still this single parameter passing prob is not solved...

could you please help me?

i will send you screen shots if you want....

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 9

Yes please.

Send the screen shots of :

1) From main report, the field where you are giving the navigation property

1) From main report ,the navigation window were you do the mapping.

2) From sub reoprt ,in the report parameter window,with the mapped parameter selected.

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 10

I have problem attaching files here. i cant access this site fully.

any alternative suggesstions are welcome.

Thanks in adv.

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 11

I am getting conversion error in the detail report.

i tried to pass rid as a string but it did not work.

what else may be the reason?

Only in master report we will pass multivalue. in detail it will be only one record.

only4mithunc SSCrazy Eights Points: 8434 More actions · Answer 12

Hi Ramanathan,

Can you try running the child repot alone (for a value which could be passed from the main report)? If still getting the conversion error check the declaration type of that parameter (in the report parameter section of the sub report ) and the type expected by the dataset of the sub report.

Can you take the screen shots which I mentioned before , try to paste it in paint and attach it, it might help me to try more to solve your issue.

Happy to help you my level best to solve the issue.

Thanks & Regards,
MC

malavika.ramanathan SSCrazy Points: 2790 More actions · Answer 13

Hi Mithun,

Thanks a lot for your help. I tried to paste the scrn shot and send you as attachment, but i dont have attachment option here as i am using this site from office.

Anyway after some trial and error, i could finally resolve it.

there were many changes required including those of datatypes.

One of the main issues were, i was passing Parameters!rid.value to the child report.

It should have been Fields!rid.Value.

Now its working. Thanks .

I have one more issue which i will be posting as a new topic. You valuable suggestions are appreciated.

Thanks,

Malavika