Re-Running Query

Presumably, an RDL data set is only queried once before generating a report. And presumably, this is true even if the data set feeds a list control. However, I'd like to know if I can cause a data set to be queried repeatedly from a list control. I need to do this, because the data set contains aggregate functions that would be impacted by each "pass" the list control would make.

Is it possible to make a data set queried repeatedly in this fashion?

What list control, what environment, what event of the control are you looking to handle here?

IAC "presumably" you want to change a parameter to the report based on the currently-selected item or items in this list, right?

You re-send the parameters and (usually) call ReportRefresh()... but it is hard to say exactly without, um, presuming too much about your scenario <s>.

>L<

Request only the required parameters

Hello,
I have a rdl document with 1 DataSource and many dataSets (all MDX
type). For each dataSet I have one or more parameters (any of them
optional).
This rdl is clean in design terms (in layout mode there aren't any
objects). The goal is to give this file to other user(client) and he
will decide what data he want to see.
The problem that I have, simulating what the end user will do, is
after choosing some columns of data, when previewing, the Visual
Studio asks for all parameters of the rdl, even if I'm only asking to
see data of a particular dataset.
Is there a way to request only the required parameters for the data
that I want to see?
I already thought to divide this rdl document in many documents (one
for each dataset) but the client doesn't want that.
Thanks,
Sidhartagive each parameter a default value in report
"Sidharta" wrote:
> Hello,
> I have a rdl document with 1 DataSource and many dataSets (all MDX
> type). For each dataSet I have one or more parameters (any of them
> optional).
> This rdl is clean in design terms (in layout mode there aren't any
> objects). The goal is to give this file to other user(client) and he
> will decide what data he want to see.
> The problem that I have, simulating what the end user will do, is
> after choosing some columns of data, when previewing, the Visual
> Studio asks for all parameters of the rdl, even if I'm only asking to
> see data of a particular dataset.
> Is there a way to request only the required parameters for the data
> that I want to see?
> I already thought to divide this rdl document in many documents (one
> for each dataset) but the client doesn't want that.
> Thanks,
> Sidharta
>

Reprot description not getting updated.

I publish an RDL to report server using web service, then later i have a
modified RDL which has the the report description changed. I republish with
"Overwrite" on my existing reprot using webservice. The description is not
getting updated in report manager.
If i edit the new report form report manager and look at the rdl it show the
new description but it will always dispalys the old description in the
description textbox.
Any idea how i could force it to update?Try manually deleting the description via the report manager interface and
then re-deploy.
Colin
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>I publish an RDL to report server using web service, then later i have a
> modified RDL which has the the report description changed. I republish
> with
> "Overwrite" on my existing reprot using webservice. The description is not
> getting updated in report manager.
> If i edit the new report form report manager and look at the rdl it show
> the
> new description but it will always dispalys the old description in the
> description textbox.
> Any idea how i could force it to update?|||Users cannot access report manager. They have to do this through our custom
interface that uses webservice to update reports.
"Microsoft" wrote:
> Try manually deleting the description via the report manager interface and
> then re-deploy.
> Colin
>
> "vRam" <vRam@.discussions.microsoft.com> wrote in message
> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
> >I publish an RDL to report server using web service, then later i have a
> > modified RDL which has the the report description changed. I republish
> > with
> > "Overwrite" on my existing reprot using webservice. The description is not
> > getting updated in report manager.
> >
> > If i edit the new report form report manager and look at the rdl it show
> > the
> > new description but it will always dispalys the old description in the
> > description textbox.
> >
> > Any idea how i could force it to update?
>
>|||Delete and redeploy is the only way. I assume through the web service you
can delete it as part of the deploy process.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"vRam" <vRam@.discussions.microsoft.com> wrote in message
news:9E62EE10-0652-4E70-BFD5-54FB410AAE70@.microsoft.com...
> Users cannot access report manager. They have to do this through our
> custom
> interface that uses webservice to update reports.
>
> "Microsoft" wrote:
>> Try manually deleting the description via the report manager interface
>> and
>> then re-deploy.
>> Colin
>>
>> "vRam" <vRam@.discussions.microsoft.com> wrote in message
>> news:B79E915B-B4D3-41F2-B8F2-C8D800BD5BCE@.microsoft.com...
>> >I publish an RDL to report server using web service, then later i have a
>> > modified RDL which has the the report description changed. I republish
>> > with
>> > "Overwrite" on my existing reprot using webservice. The description is
>> > not
>> > getting updated in report manager.
>> >
>> > If i edit the new report form report manager and look at the rdl it
>> > show
>> > the
>> > new description but it will always dispalys the old description in the
>> > description textbox.
>> >
>> > Any idea how i could force it to update?
>>

ReportWizard.vsz

Is there a way to modify the reportwizard.vsz file to use a specific report.rdl file instead of the report.rdl file found in

C:\Program Files\Microsoft SQL Server\80\Tools\Report Designer\ProjectItems\ReportProject

Basically I want to add multiple wizards and point each of them to a different report.rdl file. Any help is appreciated.

Thanks --devin

Sorry, this is not possible. The path to Report.rdl is hardcoded into the wizard.

-Albert

|||Figured. Thanks for your help.