Change Subreport Name while running

Is there a way to change the subreport name while running a report.
Depending on the user that runs the main report i would like to present
another subreport.
The subreportname can't be changed by an expression.
I could place all subreports on it and then hide the ones that arn't needed
but i don't know if a subreport that has a visibility on 'hide' still runs.
That would slow down the main report if all the subreports are running.
Kind RegardsHello Harry,
There is no way to change the subreport on demand.
But, there is a way to work around it.
You could pass a parameter to the sub report and you could use this
parameter to decide whether to generate the data source or not.
If you did not generate the data, the render time for the sub report will
reduced.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Honestly yes,
I cant' find the place where i can bock datasets of being generated in the
report parameters ...
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:ju8%237sSHIHA.4200@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Harry,
You may use a stored procedure which could accept the parameter.
You could use the IF clause in the stored procedure to check the parameter
and dicide to return the empty dataset or not.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Change subreport colors

I have a report in which I alternate colors between white and whitesmoke.
Simple report that contains a table with a header and a body. The body is
set to =iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White") I then add
another row to my table, merge all cells into one and add a sub report to it.
Here I display more data by setting the parameter of the current customerID
that I am on. Is there a way to pull the current row color from by non
subreport row and apply it to the entire sub report? This way the main row
and sub report (no matter how may row of data it contains) will have the same
color.Hi,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to set colors according
to per row's settings (For example, if the current row background color is
whitesmoke, the want the whole subreport background to be whitesmoke also).
If I have misunderstood your concern, please feel free to point it out.
Yes, we could add another parameter in the subreport and then set this
parameter value to be iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
in main report. This parameter will pass the value to subReport,
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Just what I was looking for...Thanks!!!
"Michael Cheng [MSFT]" wrote:
> Hi,
> Welcome to use MSDN Managed Newsgroup!
> From your descriptions, I understood you would like to set colors according
> to per row's settings (For example, if the current row background color is
> whitesmoke, the want the whole subreport background to be whitesmoke also).
> If I have misunderstood your concern, please feel free to point it out.
> Yes, we could add another parameter in the subreport and then set this
> parameter value to be iif(RowNumber(Nothing) Mod 2, "WhiteSmoke", "White")
> in main report. This parameter will pass the value to subReport,
> Thank you for your patience and cooperation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Microsoft Online Partner Support
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
>|||Hi,
You are welcome! If you have any questions or concerns next time, don't
hesitate to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.