thank you so much for writing me! i appreciate it. i was hoping that it can be done without Dundas :-). oh, well... thanks again.

i would write a function in the Code section of my report something like ShowMyParameters:

public Shared Function ShowMyParameters(byval productType as Parameter) as string

Dim s as String = ""

'got product?

if productType.label.tostring()...

sure :-). you can either hard-code the value in 'default section' of parameter dialog for each one or point it to a dataset if it'll be dynamic 🙂

that would be writing asp.net web form, reference your SSRS asmx (=web services) where you can do whatever you wish on a client part. however, you cannot make the text...

you need to display the 22 rows, on your Report1, right?

your Report1 must have the following parameters:

Category

Subcategory

Year1, Year2, Year3, Year4

then, you pass these values to Report1 from your Matrix Report:

Category...

you can create your own parameter and assign this value as a default value.

then, you can display it anywhere you wish on your report :-).

HI Niraj and thank you,

i am doing it already with SSRS drill-throw - easily done.

i also want to show something up above:

MyMasterReport>>MyDetailReport1>>MyDetailReport2>>

so user will click on one of them...

i dont think so. if you open chart properties, you will see that for yourself, there no way to do it dynamically.

i dont think so, but if your chart sometimes has more than 10 slices, maybe, it'll be easier to choose a different style, like bar chart, for readability?

you want to create your own template/style in report config file with the fonts/colors you desired.

you noticed when you create a report using the Report Wizard, it lets you pick...

why not just create a data-driven subscription of this Report?

you can also hard-code your parameter values if you know they will not change. for instance "yes", "no".

i would try to assign myself the same permissions (being browser with ability to manage subsriptions) and see if you can do it yourself first :-). that's where i would...

you can do GROUP BY on filtered records, you just won't have all groups :-), right?

let's say, you have 3 ranges. try to to group by first. then, try...

since reports are not the web forms :-), you would be much better off navigate to another page with details. easy to program, easy to maintain :-), less hair pulling.

or,...