.net - web Cyrstal report working fine on development machine but not on testing server -


i have .net 3.5 web application in open few crystal reports.

it works fine in development environment when copy code onto testing server doesn't display report blank page.

code of page below

html

 <%@ page language="vb" autoeventwireup="false" codebehind="crystalreport.aspx.vb"     inherits="woodland.crystalreport" %>  <%@ register assembly="crystaldecisions.web, version=12.0.2000.0, culture=neutral, publickeytoken=692fbea5521e1304"     namespace="crystaldecisions.web" tagprefix="cr" %> <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <title>report</title> </head> <body>     <form id="form1" runat="server">     <div>     </div>     <cr:crystalreportviewer id="rv1" runat="server" visible="true" autodatabind="false" />     </form>     <cr:crystalreportsource id="crystalreportsource1" runat="server">     </cr:crystalreportsource> </body> </html>

codebehind

imports crystaldecisions.web imports crystaldecisions.crystalreports.engine  partial public class crystalreport     inherits system.web.ui.page      protected sub page_load(byval sender object, byval e system.eventargs) handles me.load          try              dim cr new reportdocument             dim paramlist new list(of parameterbo)             paramlist = session("reportparams")             dim path string = server.mappath(configuration.configurationsettings.appsettings("crystalreportpath").tostring() & session("reportname").tostring())              cr.load(path)              each param parameterbo in paramlist                 if not param.parametervalue = ""                     cr.setparametervalue(param.parametername, "'" & param.parametervalue & "'")                 else                     cr.setparametervalue(param.parametername, "null")                  end if             next             cr.datasourceconnections.item(0).setconnection(configuration.configurationsettings.appsettings("server").tostring(), configuration.configurationsettings.appsettings("databasename").tostring(), configuration.configurationsettings.appsettings("username").tostring(), configuration.configurationsettings.appsettings("password").tostring())             me.rv1.reportsource = cr          catch ex exception          end try     end sub  end class

not sure how people can figure out problem pointers appreciated. can confirm have installed .net , crystal on testing server well

also have tried running report directly on testing server , working fine.

--net 3.5 --crystal report 2008

please advise

thanks

  1. my first guess database permissions issue. testing server have same database rights dev server?

  2. the blank report can mean crystal indeed pulling data succesfully, tables empty. datasource testing server being updated?


Comments

Post a Comment

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

i'm using abcpdf , i'm curious if can recursively call addimageurl() function assemble pdf document compile multiple urls? something like: int pagecount = 0; int theid = thedoc.addimageurl("http://stackoverflow.com/search?q=abcpdf+footer+page+x+out+of+", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetochain(theid); } pagecount = thedoc.pagecount; console.writeline("1 document page count:" + pagecount); //flatten document (int = 1; <= pagecount; i++) { thedoc.pagenumber = i; thedoc.flatten(); } //now try again theid = thedoc.addimageurl("http://stackoverflow.com/questions/1980890/pdf-report-generation", true, 0, true); //assemble document while (thedoc.chainable(theid)) { thedoc.page = thedoc.addpage(); theid = thedoc.addimagetoc
Read more

java - Android recognize cell phone with keyboard or not? -

in android app, want detect user's device if device has keyboard(like motorola milestone) , show corresponding user interface. guys know how that? ! regards justicepenny http://developer.android.com/reference/android/content/res/configuration.html public int keyboard the kind of keyboard attached device. 1 of: keyboard_nokeys, keyboard_qwerty, keyboard_12key. that's it!
Read more

iphone - How would you achieve a LED Scrolling effect? -

how achieve led scrolling effect example below? led sign - led ticker emulator iphone , ipad http://img.skitch.com/20101201-rsfh4p1bajb1wp94k466pdpiuj.preview.jpg sometimes remunerates comment in other posts :) have put code you, should implement font '8pin matrix' realistic feeling. uilabel *label; - (void)viewdidload { [super viewdidload]; label = [[uilabel alloc]initwithframe:cgrectmake(10, 50, 300, 20)]; label.font = [uifont fontwithname:@"courier-bold" size:16.0]; label.backgroundcolor = [uicolor blackcolor]; label.textcolor = [uicolor greencolor]; label.linebreakmode = uilinebreakmodecharacterwrap; // otherwise "…" label.text = @"this led text scrolled "; // blanks space between [self.view addsubview:label]; [nstimer scheduledtimerwithtimeinterval:0.12f target:self selector:@selector(scrolllabel) use
Read more