Intermittent field display

This is either a bug, or I am crazy.

I have developed a report that pulls its data from an SSAS cube. The report is grouped on Fields!FacilityName. On each "page" of the report, I have information for the displayed facility.

At the top of each page in my report I have a textbox whose value is =Fields!FacilityName. Further down on the report I have another text box whose value is set exactly the same. When I preview the report, I always have a value in the upper box, but only sometimes have a value in the lower box. If I change the value in the lower box to just a text string, it will always display, but when I put in the actual field reference it does not. It always doesn't display for the same facility names. Remember, the upper textbox on the form always displays 100% of the time.

I have a Dundas chart in the middle of the page on the report between these textboxes, but another field that pulls parameters and even a matrix all render correctly below that chart.

They both have the same parent according to the properties. I have even copied and pasted the working textbox further down the screen, with no improvement. When I changed the value of the textbox to "=cstr(len(Fields!FacilityName))", on the pages when it wants to be blank, it reads 0, and on other pages it shows a larger number. But the other textbox on the screen will always properly show the FacilityName.

I have also tried changing the name of the textbox, settings output to YES instead of Auto. If I slide the non-working textbox up to the top of the page and the working textbox down to the bottom area of the page, the bevavior switches.

Does anybody know of rendering issues with textboxes showing the same infomation?

Are you running at least SSRS2005 SP1 (on the server and for BI Dev.Studio)?

-- Robert

|||My server is running Microsoft SQL Server Reporting Services Version 9.00.2047.00, and I am using VS 2005 with the most recent service pack on my development PC. Both exibit the behavior I describe.
Could it be something odd in the XML of the report that I just cannot see in the IDE?
|||We are running 9.00.2047.00 on the server, and my VS 2005 is up to date. Maybe there is something buried in the XML of the RDL that I just cannot see in the IDE that is causing the problem.|||I also have a ticket in with Dundas since when I remove the chart off the report, the textbox renders correctly. Perhaps the chart is breaking the recordset in some way.

Intermittant Connection Errors

I have a Merge-Pull subscription setup between two SQL 2005 databases. While watching the status messages display for the subscription, I am constantly seeing the following message being displayed:

"The merge process could not connect to the Publisher '{server}:{database}'. Check to ensure that the server is running."

It will display for anywhere between 15 seconds to a few minutes, then it will display the standard "Waiting 60 seconds..." message which is what I'm used to seeing when all is working well.

There doesn't seem to be any network issues that I can identify. I ran a quick script to run ping continuously against the publisher server and verified that the server was constantly "pingable", even when the above message was displayed (which, by the way, was being displayed by using SSMS while connected to the publisher).

Does anyone know what would cause this message to appear all the time - for extended amounts of time, with occasional glimpses of a non-error status?

It's a wild guess but failing to login / authenticate ?|||I thought of that but am not sure that it applies. The reason being that I can leave the subscription/synchronization status window open in SSMS and it will toggle back and forth (seemingly randomly over time) between the message I mentioned above and some type of valid message.|||What about Timeouts (Connection or Query)? I have seen similar issues in Web Sync. If the amount of data changed since the last sync operation then I have experienced Timeouts while the sync is initialized. Not exactly as you describe but another parameter worth checking.

Rab
|||

I'm not sure what the issue was but it seems to have resolved itself - at least for the time being. If it happens again, I'll be looking for more answers :-)

Thanks for everyone's help.

|||I have this problem as well. It works sometimes and then fails with this error message which leads me to believe it isn't a login problem. I'm still new to replication so I could be wrong, but I think once I get this message, replication is broken and requires someone to intervene to reinitialize. Has anyone figured out what is going on?

Intermittant Connection Errors

I have a Merge-Pull subscription setup between two SQL 2005 databases. While watching the status messages display for the subscription, I am constantly seeing the following message being displayed:

"The merge process could not connect to the Publisher '{server}:{database}'. Check to ensure that the server is running."

It will display for anywhere between 15 seconds to a few minutes, then it will display the standard "Waiting 60 seconds..." message which is what I'm used to seeing when all is working well.

There doesn't seem to be any network issues that I can identify. I ran a quick script to run ping continuously against the publisher server and verified that the server was constantly "pingable", even when the above message was displayed (which, by the way, was being displayed by using SSMS while connected to the publisher).

Does anyone know what would cause this message to appear all the time - for extended amounts of time, with occasional glimpses of a non-error status?

It's a wild guess but failing to login / authenticate ?|||I thought of that but am not sure that it applies. The reason being that I can leave the subscription/synchronization status window open in SSMS and it will toggle back and forth (seemingly randomly over time) between the message I mentioned above and some type of valid message.|||What about Timeouts (Connection or Query)? I have seen similar issues in Web Sync. If the amount of data changed since the last sync operation then I have experienced Timeouts while the sync is initialized. Not exactly as you describe but another parameter worth checking.

Rab|||

I'm not sure what the issue was but it seems to have resolved itself - at least for the time being. If it happens again, I'll be looking for more answers :-)

Thanks for everyone's help.

|||I have this problem as well. It works sometimes and then fails with this error message which leads me to believe it isn't a login problem. I'm still new to replication so I could be wrong, but I think once I get this message, replication is broken and requires someone to intervene to reinitialize. Has anyone figured out what is going on?sql

Interesting Average problem

I have a table that has a numeric field and the footer of the field has to
display the AVG of the field.
Some of the field values are null, and those should be left out of the
calculation.
Doing a AVG(Field!Name.Value) of course take them into account as well.
Any ideas?
Thanks.Shrink, shrink, shrink, in the end it works if the field is null, different
story if it is zero.
"Chris Botha" <chris_s_botha@.AT_h.o.t.m.a.i.l.com> wrote in message
news:ujqmWjUZEHA.1480@.TK2MSFTNGP10.phx.gbl...
> I have a table that has a numeric field and the footer of the field has to
> display the AVG of the field.
> Some of the field values are null, and those should be left out of the
> calculation.
> Doing a AVG(Field!Name.Value) of course take them into account as well.
> Any ideas?
> Thanks.
>

Interactive sort, forcing a row to remain at the end still cant get it to work

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort, forcing a row to remain at the end

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Otherwise doesnt anyone know how to palce a row from the detail section into the footer?

Many thanks

Dave

This approach should work fine. Maybe the item value contains blanks. You may want to try to just add another detail textbox that shows the result of =(Trim(Fields!Item.Value) <> "Total").

Once you get the expected results, modify the sort expression for the interactive sort accordingly.

-- Robert

|||

Hi All

I'm Climbing the walls here, does anyone know how to do an interactive sort but keep one of the returned rows pinned at the end of the result set?

I've tried =(Trim(Fields!Item.Value) <> "Total") & Fields!Item.Value but the Total ends ups either at the top or bottom of the result set.

E.g

Results

d

e

a

b

c

Sort would return

a

b

d

e

c

with c remaining at the bottom

i get the above when ascending sort which is fine but descending i get

c

a

b

d

e

Thanks in advance

Dave

|||Anyone?

Interactive sort

Hi,

Im trying to do an interactive sort , one of the rows returned from my datasource called 'Total' i wish to display at the bottom always. is there a way i can do this?

I've tried the below on the column header but the total is either at the bottom or the top how can i check the ordering if Ascending or Descending? Then i cld swop the 1 and the 2 around.

=iif(Fields!Item.Value <> "Total", 1 ,2) & Fields!Item.Value

Many thanks

Dave

*Bump*, anyone?