Report not refreshed

I have created an asp.net application in which i have a textbox and botton.T

he textbox value is passed as parameter to a report and the corresponding report is generated on button click.The problem is that once i add a report to any application the same report is displayed each time i.e. the report is not updating whenever there is a change in the database values.

Iam refreshing the datasource in the original report and change is reflected there in original report but in the dotnet application always the old report is maintained......

Can anybody help me out......

I had the same problem reportviewer1.reset nd I sovled it by added a line code before refreshing the report:

reportviewer1.reset

|||

I had the same problem and I sovled it by added a line of code before refreshing the report:

reportviewer1.reset

|||

Thanx Frankmeng for your suggestion but it is not working....

It is giving me build error.

Error 1 'Microsoft.Reporting.WebForms.ReportViewer' does not contain a definition for 'Reset'
Can u help me with this?

I would also like to know whether we can set the paging property of the report so that only desired number of records are displayed in a page and the user doesn't have to scroll up and down.

Thanx.

|||

Arun:

It is sovled by added a line of code in the Button click event.

reportviewer1.localreport.refresh()

|||Thanks a lot Arun its working...

Report Navigation and jump url

Hi all,

I have got a report with external hyperlink.

When I put this link in TextBox properties >> Navigation >> Jump URL of my gridView : http://www.micheldegremont.com it works.

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

And if I put http://www.micheldegremont.com?id=Fields!ID.Value my report create a hyperlink to http://www.micheldegremont.com?id=Fields!ID.Value and no http://www.micheldegremont.com?id=1

Thanks for you help.

Degremont wrote:

However, if I put "http://www.micheldegremont.com?id=" + Fields!ID.Value it doesn't work. I haven't not link in my report.

Instead use "http://www.micheldegremont.com?id=" & Fields!ID.Value

HTH|||

Now it works with ="http://www.micheldegremont.com?id=" & Fields!ID.Value but only on 1 report.

Howerver, I have the same XML

Report 1 (it's work)

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="AddressID">
<rd:DefaultName>AddressID</rd:DefaultName>
<ZIndex>1</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!AddressID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>

But on report 2 , it doesn't work

<TableRow>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="noteFraisID">
<rd:DefaultName>noteFraisID</rd:DefaultName>
<ZIndex>7</ZIndex>
<Action>
<Hyperlink>="http://www.micheldegremont.com?id=" &amp; Fields!ID.Value</Hyperlink>
</Action>
<CanGrow>true</CanGrow>
<Value>=Fields!noteFraisID.Value</Value>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
....

sql

Report Layout... TextBox Issue

I have two TextBoxes, they are next to each other and they touch.
According to their properties they are the same height, they are also the
same distance from the top.
Preview: they line up perfectly
After Deployment: one appears as though it is a slightly different height
Export To PDF: suddenly they're the same again
Why is this happening and how can I fix it?There are various properties on the text box you can set to specify where
it is located. If they have the same properties, that means they actually
want to be located in the same space. But the HTML viewer will position
them differently because it does not support overlay.
<Height></Height>
<Width></Width>
<Top></Top>
<Left></Left>
--
| Thread-Topic: Report Layout... TextBox Issue
| thread-index: AcS6nZhfn6F0qzGsTYehI9XjssWUhg==| X-WBNR-Posting-Host: 64.86.141.134
| From: "=?Utf-8?B?TUVSNzg=?=" <MER78@.discussions.microsoft.com>
| Subject: Report Layout... TextBox Issue
| Date: Mon, 25 Oct 2004 07:19:10 -0700
| Lines: 10
| Message-ID: <4592BB8A-993A-4A7A-98F1-2690E2E5658E@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
| Path: cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: cpmsftngxa10.phx.gbl microsoft.public.sqlserver.reportingsvcs:33048
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| I have two TextBoxes, they are next to each other and they touch.
|
| According to their properties they are the same height, they are also the
| same distance from the top.
|
| Preview: they line up perfectly
| After Deployment: one appears as though it is a slightly different height
| Export To PDF: suddenly they're the same again
|
| Why is this happening and how can I fix it?
||||I think I mis-worded my question... I've had endless problems with text boxes
that touch... at least according to their properties they don't overlap... it
looks ok in one format... in another boxes get pushed onto other lines etc...
especially in excel...
I've started using a table for text boxes that touch whenever I can...
though it took me awhile to notice that you can use a table without having it
connected to a data source... if you put all of your stuff in header rows.
""Brad Syputa - MS"" wrote:
> There are various properties on the text box you can set to specify where
> it is located. If they have the same properties, that means they actually
> want to be located in the same space. But the HTML viewer will position
> them differently because it does not support overlay.
> <Height></Height>
> <Width></Width>
> <Top></Top>
> <Left></Left>

Report item only found in the first page of the report Header

I have a textbox in a Page Header which refers to a ReportItem found in the
body of the report, Im using a not visible textbox in the body.
The first page its ok, but after it doesnt appear any data about values un
the report header textboxes
Could you help me please with specific information about how fix this problem?
Thanks in advance!
--
.So you have a textbox header that wont repeat on pages after the first
and you want it to repeat on subsequent pages? Is that correct? Each
textbox item has an option to repeat based on another textbox (or I
think Table Item) in the report.. Basically select the textbox header -
right click and select properties - then select the advanced button in
the lower left corner of the Properties dialog - on the General tab
their should be a "Repeat report item.." option (selected by default)
beneath this option is a drop-down to select the data region. Just
select the Data Region you wish the header to repeat on and you should
be fine.|||So you have a textbox header that wont repeat on pages after the first
and you want it to repeat on subsequent pages? Is that correct? Each
textbox item has an option to repeat based on another textbox (or I
think Table Item) in the report.. Basically select the textbox header -
right click and select properties - then select the advanced button in
the lower left corner of the Properties dialog - on the General tab
their should be a "Repeat report item.." option (selected by default)
beneath this option is a drop-down to select the data region. Just
select the Data Region you wish the header to repeat on and you should
be fine.|||ok, let me explain it better.
I have a dataset value form a textbox1 in BODY, and I make
=reportitem!textbox1.value put it in a Textbox in HEADER, with this, is
possible that data value can be see it in header.
At the first page , you can see tha value at the HEADER, but after this
number one page, it doesnt see the values anymore
Question. How can I do, for this values can appears in all the HEADER in
each page?
P.D. What data regions can I select?, it doesnt appear any data.
"papaboom" wrote:
> So you have a textbox header that wont repeat on pages after the first
> and you want it to repeat on subsequent pages? Is that correct? Each
> textbox item has an option to repeat based on another textbox (or I
> think Table Item) in the report.. Basically select the textbox header -
> right click and select properties - then select the advanced button in
> the lower left corner of the Properties dialog - on the General tab
> their should be a "Repeat report item.." option (selected by default)
> beneath this option is a drop-down to select the data region. Just
> select the Data Region you wish the header to repeat on and you should
> be fine.
>|||This worked for me...
From a post by Lev Semenets [MSFT]
Here is some info about adding parameters :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rshowto/htm/hrs_designer_v1_38du.asp
You need to create a parameter with no prompt (If the prompt is left blank,
and a default parameter value is specified, the default value is used, and
the input box for the parameter is not displayed when the user runs the
report), set default value to "From query" and select dataset and field for
default value.
"mario_quijada" wrote:
> I have a textbox in a Page Header which refers to a ReportItem found in the
> body of the report, Im using a not visible textbox in the body.
> The first page its ok, but after it doesnt appear any data about values un
> the report header textboxes
> Could you help me please with specific information about how fix this problem?
> Thanks in advance!
> --
> .

Report item expressions can only refer to other report items within the same grouping scope or a

I still don't get this. I want to reference another textbox. I've tried these expressions below and get the same error. For instance, I'm referencing this from textbox6. I've put the data in a group, doesn't work. How do I reference different reportitems? Thanks

=ReportItems!textbox15

=ReportItems!ThresholdIncome.value

=ReportItems!ThresholdIncome.value,"table1_Group1"

You should be able to reference textboxes in the same or a containing scope. This first expression would return you the textbox object. The second one should work if ThresholdIncome exists in the same or a containing scope. You can't explicitly specify the scope of a report item. Therefore the 3rd one wouldn't work. What error did you get with these expressions?|||

Fang - Thanks for your help. Error I'm getting is what is in the subject -

Report item expressions can only refer to other report items within the same grouping scope or a containing grouping scope.

So does that mean I need to add a group and the textboxes can only know about each other in that group, but not any other textboxes on the report? That is what I don't understand. If it's all the same xml, why don't the controls know about each other?

|||You can refer to textboxes in that group, and the ones in the containing scope of that group (i.e. outer groups all the way up to the report level). But you can't refer to textboxes in an inner group. The reason is that when the report is rendered (combining layout information with data), there will be multiple instances of the inner groups. For example, if the outer grouping is by country and the inner grouping is by state, you'll get multiple states for USA. We wouldn't know from which inner group instance you want to get the textbox value.

Report from right to left

Report from right to left
Hi.

Is there a way to define the report from right to left?
and I mean all the report and not just the textBox and stuff?

For example:
Right now, When I have a table that spread over the whole page, If I change the visibility of a column from the center to False - The table shrink to the left (and there is a spare room in the right side of the page).

I tried changing the lenguage to hebrew but no good.

Any ideas?

Roy,

I've had this same problem before, and I haven't seen a solution to keep the table at one fixed width when expanding and hiding columns. Have you thought of just hiding the text boxes in that column instead of the whole column. We also just found out that you can embed a table within a table. You may find a solution there. Have one main table with your headers then a sub table that you can hide and unhide columns. Just trying to help.

|||Hi patawa,
Thanks for the reply.

My problem is a little diffrent since I don't care that the table width will change.
The problem is thet the table is tied to the left of the screen and not to the right.

I don't care if the width will shrink but I want the right border to stay in his place and fot the left border to shrink right.

Any way, maybe I can use your isea of table inside table to try and simulate something like this...
Its worth a shot.

Thanks,
Roy.|||I'll try my luck again despite the fact that I'm probebly the only hebrew speaking user here :)

Thanks.