"View Report" button.

Would someone be able to tell me if this is a bug or not. When I have two
parameters (both text boxes) and change the first one and click on the "View
Report" button to refresh the data with the new parameter values it blanks
the report out and I do not see "processing report" like I normally do. On
the second click it processes the report.
When I change a parameter in the second text box and click "View Report", it
processes the first click.
Seems like a bug of sorts. Anyone encounter this before? I'm more than
happy to provide the RDL.
Best Regards,
Benjamin PierceThis sometimes happens if parameter 2 has values based on a query and the
value of that query is dependent on the value of parameter 1 (hierarchical
parameters).
What happens is that when you choose a value for P1, we try to go back and
get values for P2. Now before we get those values the user clicks view
report. Since you've requested a to view a report with only one parameter
specified, we send back a page asking for the second parameter value.
However due to browser refresh, it doesn't look like anything happened. Now
you provide a value for parameter 2, you get the report rendered.
You can make this stop happening by providing a default value for parameter
2.
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Benjamin Pierce" <bpierce@.opentext.com> wrote in message
news:ujptP0AcEHA.384@.TK2MSFTNGP10.phx.gbl...
> Hello,
> Would someone be able to tell me if this is a bug or not. When I have two
> parameters (both text boxes) and change the first one and click on the
> "View
> Report" button to refresh the data with the new parameter values it blanks
> the report out and I do not see "processing report" like I normally do.
> On
> the second click it processes the report.
> When I change a parameter in the second text box and click "View Report",
> it
> processes the first click.
> Seems like a bug of sorts. Anyone encounter this before? I'm more than
> happy to provide the RDL.
>
> Benjamin Pierce
>

"sql data source" updating

hello all,

I ran into a problem using the "sql data source updating " method. i'm using a form view with about 20 parameters that are bind to controls in the form view and 5 other parameters that i'm setting the value to in the "sql data source updating" method. Every thing updates find execept for the last 5 parameters that i'm setting the values to in the "sql data source updating" method. My store procedure(sp) updates and insert mulitple tables. For some UNKOWN reason the tables that uses the parameteres in the "sql data source updating " are inserting multple records when only 1 record should be inserted. Have anyone have this problem?

Hi,

Please check if the insert command in the stored procedure has been called several times. Also, is there any triggers fired after the insertion?

If that still doesn't work, please let us see the stored procedure and code for Updating event handler.

Also, if you're inserting a record into the database, I suppose you need to handle the SqlDataSource.Inserting event.

"short circuit"/stop auto generating report after clicking report

In Report Manager, using a parameterless report or a report with parameters
that have default values, if one clicks on the report link in a folder, the
report automatically begins generating and then the data is viewable.
Is there any way to prevent the report from being (automatically) generated
so as to require the user to have to click the standard "View Report" button?
A solution might be in the "code"/RDL or perhaps the
"web.config"/RSWebApplication.config. Either is OK. Or anything else.On Jun 27, 1:28 pm, John <J...@.discussions.microsoft.com> wrote:
> In Report Manager, using a parameterless report or a report with parameters
> that have default values, if one clicks on the report link in a folder, the
> report automatically begins generating and then the data is viewable.
> Is there any way to prevent the report from being (automatically) generated
> so as to require the user to have to click the standard "View Report" button?
> A solution might be in the "code"/RDL or perhaps the
> "web.config"/RSWebApplication.config. Either is OK. Or anything else.
The easiest way to accomplish this is, in cases where report
parameters are used, to not have a default set for at least one of the
parameters. Sorry that I could not be of greater assistance.
Regards,
Enrique Martinez
Sr. Software Consultant

"Global" Report Parameters

Hi,
I have a report with 3 different datasets. How can I add a parameter to
this report which works or is valid for all the 3 datasets?
ThanksYou should be able to simply add a parameter to the report. These variables
can be accessed by any dataset.
HTH,
Brian
"florian" <florian.stammer@.gmail.com> wrote in message
news:1160661960.136268.105290@.h48g2000cwc.googlegroups.com...
> Hi,
> I have a report with 3 different datasets. How can I add a parameter to
> this report which works or is valid for all the 3 datasets?
> Thanks
>|||I think what you are missing is the concept that there are query parameters
and report parameters. RS creates a report parameter for each query
parameter for you and maps them. You can change this mapping by clicking on
the ... in the dataset, parameter tab. You can map to an expression or to a
report parameter. In the layout tab menu report-> report parameters you can
remove, rename, add parameters.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"florian" <florian.stammer@.gmail.com> wrote in message
news:1160661960.136268.105290@.h48g2000cwc.googlegroups.com...
> Hi,
> I have a report with 3 different datasets. How can I add a parameter to
> this report which works or is valid for all the 3 datasets?
> Thanks
>