changing the RDL at run time

Does the RS need RDL once the report is deployed. I need to change the RDL at
run time.Although there is no rdl file on the webserver, when you deploy it the rdl
gets stored in the database. The database is where RS retrieves the report.
If you change the rdl at runtime you have to deploy the report before it can
be viewed. This is possible but keep in mind, you would need to uniquely
name the report for the current user you are modifying the rdl for otherwise
if two people try to view the same report they will see whichever was the
latest you modified and deployed. Most people that do this are using web
services to accomplish this. Although doable it is non-trivial. I would make
sure that there is not some other way around your problem before going this
route.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vcs" <vcs@.discussions.microsoft.com> wrote in message
news:00D56442-ABC3-48E9-9BE7-285198BA14C2@.microsoft.com...
> Does the RS need RDL once the report is deployed. I need to change the RDL
at
> run time.

changing RDL of a snapshot?

As I understand it, once you snapshot a report, any changes to the RDL of the
report will not affect the snapshot. Let's say (using a purely hypothetical
situation ;-) that I misspelled the text of a column header. Has anyone
looked into messing with the stuff in the ChunkData table to go change a
piece of text in the RDL of the snapshotted report? Obviously this would be a
completely unsupported action as far as Microsoft is concerned... and I would
obviously proceed at my own risk.
Can anyone give me any hints about what format the ChunkData.Content column
is in so that I could read and modify a few bytes?You are right - this is an unsupported action.
BTW: you won't find *any* RDL XML in snapshots. Snapshots are output-format
independent, already processed reports. The risk is extremely high to get it
wrong when messing with them (in particular for compressed snapshots on
SP1). If you get it wrong, the snapshot is no longer usable and will result
in a fatal error "unexpected error during processing".
Keep in mind that you are on your own once you modify anything directly in
the report server databases.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"FurmanGG" <FurmanGG@.discussions.microsoft.com> wrote in message
news:BFBF8E3A-054F-473A-829B-5AB1798CCA04@.microsoft.com...
> As I understand it, once you snapshot a report, any changes to the RDL of
the
> report will not affect the snapshot. Let's say (using a purely
hypothetical
> situation ;-) that I misspelled the text of a column header. Has anyone
> looked into messing with the stuff in the ChunkData table to go change a
> piece of text in the RDL of the snapshotted report? Obviously this would
be a
> completely unsupported action as far as Microsoft is concerned... and I
would
> obviously proceed at my own risk.
> Can anyone give me any hints about what format the ChunkData.Content
column
> is in so that I could read and modify a few bytes?

Changing labels inside the rdl on runtime

Hi
Is it possible to change labels inside a report before rendering it? I need
to localize some labels before the report is shown in my
WinForms-Application. I do not want to have one report for each language.
Sometimes I need to change some more things in the report not only labels.
So, how can I get access to all the controls (lists, textboxes, subreports
etc.) of my report?
Thanks
MichaelThe approach I took was a custom assembly with a resource file. I park the
language identifier in a property then use an accessor method in the
assembly to fetch the string from the correct resource file. You can pass
in the ReportItems object into a custom assembly or code behind. If the
report has a page with no rows I've had trouble with this and wasn't able to
figure it out.
Thanks,
Steve MunLeeuw
"Michael Reukauff" <mreukauff@.gmx.net> wrote in message
news:O$Tk2LdpGHA.4996@.TK2MSFTNGP05.phx.gbl...
> Hi
> Is it possible to change labels inside a report before rendering it? I
> need to localize some labels before the report is shown in my
> WinForms-Application. I do not want to have one report for each language.
> Sometimes I need to change some more things in the report not only labels.
> So, how can I get access to all the controls (lists, textboxes, subreports
> etc.) of my report?
> Thanks
> Michael
>