Showing posts with label weird. Show all posts
Showing posts with label weird. Show all posts

Wednesday, March 28, 2012

ReportViewer and Firefox

Running into a weird problem and wanted to see if anyone else had run into it before. I developed a simple web application using the ReportViewer component with an rdlc report. When I run the project through the development web server in VS, everything looks ok in both Firefox and IE 7. I then deployed the app to a test IIS 6 machine. Looks ok in IE 7, but in Firefox (2.0.0.6, the same one I viewed the test with), the data is all compressed to the left and isn't really readable. Exporting the report (PDF or Excel) looks fine. Anyone have any ideas?

I've run into the same problem.

FireFox seems to have issues with all the nesting in the table structure. I've seen a post about adding a blank textbox in the header set to the width of the report as a fix, haven't had a chance to try it out yet......

Burl

|||

Well, the weird thing, like I said, is that the same application on the dev server in VS 2005 runs just fine in Firefox. It's just when it goes to a test "production" IIS 6 box that it starts acting weird.

|||

Found this post, have to try it out later....

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=83322&SiteID=1

Burl

|||

Setting the page header to can't shrink or grow seems to have worked for me. Still strange that it doesn't show problems in both instances.

|||

Hi!

Have you seen this link?:http://msdn2.microsoft.com/en-us/library/ms156511.aspx

Cheers,

Monday, March 26, 2012

ReportView renders reports weird...?

I'm using a ReportViewer control to render reports on my page. It does render the reports, but ever report scrolls below the iframe that it creates. It's difficult to explain, but basically, you can't scroll to the bottom of the report. That data is below the iframe's bottom border. The iframe is not mine, it's created by ResportViewer. I have a screenshot to illustratehere (http://www.appell.com/imges/srsscontrol.gif)

Here's my code (it's using a MasterPage):

<asp:Content ContentPlaceHolderID="cph_MainContent" runat="server" ID="cntDefault"> Choose from the available reports:   <asp:DropDownList ID="ddlReports" runat="server" OnSelectedIndexChanged="ShowReport" AutoPostBack="true"> <asp:ListItem Value="">Select a report</asp:ListItem> </asp:DropDownList> <div style="margin:8px 0px 0px 0px;clear:both;"> <rsweb:ReportViewer ID="reportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="600px" AsyncRendering="true" ProcessingMode="Remote" ShowToolBar="True" Width="700px"> <ServerReport ReportPath="" ReportServerUrl="http://sqlwebreports/ReportServ" DisplayName="report" Timeout="1000" /> </rsweb:ReportViewer> </div></asp:Content>

Any idea what's going wrong here? BTW, I have tried changing the InteractiveSize and it doesn't matter how short I make the report, it still scrolls below the bottom...

Thanks for the help!

Eddie

Take out the div tags. If you have it in a table tags, take those out. I had the same problem. The report was in a panel that was in a table. Took out the table tags and the report rendered fine.|||Thanks, but I tried that and I get the same exact result. This code:
<asp:Content ContentPlaceHolderID="cph_MainContent" runat="server" ID="cntDefault"> Choose from the available reports:   <asp:DropDownList ID="ddlReports" runat="server" OnSelectedIndexChanged="ShowReport" AutoPostBack="true"> <asp:ListItem Value="">Select a report</asp:ListItem> </asp:DropDownList> <rsweb:ReportViewer ID="reportViewer1" runat="server" Font-Names="Verdana" Font-Size="8pt" Height="600px" AsyncRendering="true" ProcessingMode="Remote" ShowToolBar="True" Width="700px"> <ServerReport ReportPath="" ReportServerUrl="http://sqlwebreports/ReportServ" DisplayName="report" Timeout="1000" /> </rsweb:ReportViewer></asp:Content>

Renders exactly the same as the other code - the report still scrolls out of sight...

Thanks for the reply!

eddie

|||If you haven't done this yet, take out the content place holder tags and just put the viewer in a panel. Also, ssl can give the viewer trouble|||

Yeah, turns out the control just can't be used with a MasterPage. I tried everything, and the only way I could get it to work was to take it out of a ContentPlaceHolder, which is required if using a MasterPage. So I just converted this page to a standard webform and it works fine. Too bad though...

Eddie

|||

Also, you can check what settings are there for "Style" of the Report Viewer. You can acccess the styling of the ReportViewer as follows:

1) Design View

2) Right click on the ReportViewer and you will see the Style tab in the popup. Click that.

3) Go to Layout section. There should be a "Content" section. For Overflow, choose "Use Scrollbars if needed".

I believe this should solve the problem.

Good luck...

bullpit

Wednesday, March 21, 2012

Reports wont show any result in another User Account

Hi,

i got a problem with all the reports which where created in by one user. This user has left our company. The weird think is that all the reports the user has created works/runs fine in that users account.

The problem is if i try to run exactly the same report in my user account it does not show any values, except of one that is total count of the data entries. I got the connection to the database, i created a test report with basic values, it works fine.

The reports wont run on any other user account. It just run fine in the account where it got created.

I assume the user must have setup something in his Crystal Reports, DB2 or anywhere else. Attributes and the rights are exactly the same. My account is in the same group like the other account. I do have exactly the same rights i also can modify the file and safe it but i cant see the result after i run the report. If i can't check the results it makes no sense to modify it. I have to login in that account to do the modifications or to test them.

I have a tool which runs report independetly. There i can see the result in any account. The reports does only not work in Crystal Reports.

Anyone has idea what could be wrong ? I have tried everything but i cant find out what the problem is.

It's really urgent i hope someone has a solution

TrayHard to say, have you checked the database connections under the "working id" and compared them with yours. Perhaps he set up a custom connection to the database that your connection does not have.
" Grasping at straws "sql

Friday, March 9, 2012

Reportng Services #Error in IIF

I have this very weird problem arising when I try to use the following
function in Reporting Services 2000:
IIf ( 4=4 , 0 , 4/0) - Displays #Error
IIf ( 4=4 , 0 , 4/1) - Displays 0
Can somone please explain why this occurs and any work around for it.
In the Actual scenario I'm doing something like this:
IIf ( x=0, 0, y/x)
When x is 0 it gives #Error
When it is not it displays the value of y/x
Thanks a lotHi,
Actually the reporting services evaluates all values irrespective of whether
that value is reached or not. Even i found this weird.
In your case, it tries to evaluate 4/0 which produces an error and hence the
result.
Bye
Sumit Pilankar
<gogulaa@.gmail.com> wrote in message
news:1133251786.777196.173580@.z14g2000cwz.googlegroups.com...
>I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||You are receiving this error because the 4/0 is an illegal math function.
Cannot divide by zero.
"gogulaa@.gmail.com" wrote:
> I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||The way we get around it is to create a function in the report and call that
passing the X and Y parameters.
Dale
<gogulaa@.gmail.com> wrote in message
news:1133251786.777196.173580@.z14g2000cwz.googlegroups.com...
>I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot
>|||Not the first time I've seen this with SQLRS and don't know why it
happens as your logic is sound.
Try something like
=IIF( x != 0, y/x, 0) or maybe
=IIF( x= 0, x, y/x) or even
=IIF( (x=0) = "True", 0, y/x)
and see if one of those helps.
Or for some adventure, try inserting this custom code under report
properties then just use the custom function populated with your x and
y values. "=DivideBy(y,x)" This has never failed me.
Public function DivideBy (exp1,exp2)
If exp2 = 0
DivideBy = 0
else
DivideBy = exp1/exp2
end if
end function
gogulaa@.gmail.com wrote:
> I have this very weird problem arising when I try to use the following
> function in Reporting Services 2000:
> IIf ( 4=4 , 0 , 4/0) - Displays #Error
> IIf ( 4=4 , 0 , 4/1) - Displays 0
> Can somone please explain why this occurs and any work around for it.
> In the Actual scenario I'm doing something like this:
> IIf ( x=0, 0, y/x)
> When x is 0 it gives #Error
> When it is not it displays the value of y/x
> Thanks a lot

Reportmodel data incorrect

Hi,

I have a very weird and frustrating problem at a customer. Since two months we are busy developing a report model, so users are able to create their own reports using the reportbuilder.

Suddenly the 1:n relations seem to be screwed! If I have a simple relation between entities, like a customer can have optional multiple invoices and a invoice has always one customer..

When in reportbuilder I select the customername, invoicenumber and #Invoices, then I expect there is only one invoice per invoicenumber. (When I select this in a query myself it is the truth...) But, the reportbuilder gives 2 as a result. This suddenly happens to all my 1:n roles.

It's not only in the #invoices fields, even when i select invoice amount this amount is being multiplied by 2.

I opened a backup of my project from one month ago, with the same relation in it and try to make the same report and it gave me the right results. But ofcourse I don't want to waste a month works, so I need to get this model working!

HELP!!!!

Thanks in advance

Julian

My fault... If i selected the relation entity and tested the results I would have seen each relation is mentioned twice.