Installation and SQL Express

12 posts, 0 answers
  1. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 30 May 2007 Link to this post

    Hi!

    I downloaded latest Telerik Reporting Trial and it seems installation does not finish properly because I dont have SQL Express installed locally. After installation in Visual Studio 2005 in Toolbox I see only ReportViewer, no other components. Maybe it's not SQL Express related, but I can't try anything.

    Also, why forcing local copy of SQL Express. I have SQL Express server on another computer, just enable entering this information in installer and everything else is the same - you connect to server with information I provide during installation and no local copy of SQL Express is needed (I really dont intend to install it localy since I set up a computer that serves as SQL and IIS server).

    Regards,

    Mario Blataric
  2. Chavdar
    Admin
    Chavdar avatar
    898 posts

    Posted 30 May 2007 Link to this post

    Hi Mario,

    The Report items are visible only when you have opened a Telerik Report in design view. To do this, select the [Report].cs file and from the context menu choose "View Designer". After the report is shown, open the Toolbox and look for the Telerik Reporting 1.0 tab.

    The local copy of SQL Express (or any other version of SQL Server 2005) is necessary in order to attach the sample database which is needed for the sample applications. Although you can connect to a remote SQL Server, the installer can't attach the sample database to it.

    Let us know if you need further assistance - we will be happy to help.

     
    Greetings,
    Chavdar
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  3. DevCraft banner
  4. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 31 May 2007 Link to this post

    Hi!

    I'm coming from Windows programming and FastReports (you should do your best to copy their designer and easy of use :)) for report engine and all this web reporting (I dont think Telerik only, I tried few already) is like a century back.

    Been reading posts here regarding adding data connection to reports and got a bit shocked with "dummy" datasets.
    I have a need to put several data tables in report (master - detail relation, didnt yet figure out how to do it with Telerik) with each having about 20 fields...dummy datasets seems like a really dummy sollution in my case.

    Never the less, I need to give a try to this, because there is a need for web reporting.
    I managed to set up my first report, but I get no data (I guess the reason for that is problem with datasource). In help, there is written that I should put SqlDataAdapter to designer (goes fine) and then connect report's Datasource to SqlAdaptar. That does not work - no SqlAdapters in list. So, I add DataSet and the I get schema to report - but no data, of course.
    In Preview I have message: "Object reference not set to an instance of an object" and in HTML Preview I see only header text. That's in design.
    In runtime I created page and put ReportPreview on it and button with code:
        Telerik.Reporting.Report report = new Report1();
        ReportViewer1.Report = report;
    But when I run the page I get the same error as above message "Object reference .... "
    Related to that....how do I print a report from a page that does not have ReportPreview? For example, I have button on one web page: "Print customers" and then I do what? Redirect request to page with ReportPreview, sending parameter so in that page I know which report to load?
    This is all new too me, still trying to find myself in this web programming.

    Some suggestions for designer:
       - guide lines, or even better dynamic guidelines like in FastReport or CodeGearDelphi (when you move object and that object gets in line with other object a line is drawn between matching sides, when you move it further, line is gone)
       - automatic header textboxes creation like in Crystal. When you put field from database, let designer create header text as well. Of course, this should be optional.
       - keyboard support - it seems I cant move objects with Ctrl + arrows, or resize them with Shit + arrows

    You really need to make a good data model, because this dummy datasets are not an option for me and datasets does not allow design time preview of data.

    Well, so much from me for now :)

    Regards,

    Mario B.
  5. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 31 May 2007 Link to this post

    Hi mariob,

    Thank you for your questions and feedback.

    Generally speaking, the only difference between using the Telerik Reports in a Windows Forms app and in an ASP.NET app is in the ReportViewer control you need to use. This is from Report's point of view - creating a report, customizing its appearance and connection to a data source is the same, regardless of the application.

    When it comes to "Print customers", things are a bit more complicated. First of all, the actual printing is performed on the client (browser) and the reports are rendered on the server. So when the user presses the print button, the browser posts back to the server, the report gets generated and returned to the client (browsers print only what they display so I assume you've rendered the report in HTML).

    Only then you should instruct the browser to print the HTML. A possible solution I can think of is to use a hidden IFRAME; then on "Print customers" set the IFRAME.src to an ASPX that will run the ReportProcessor (Telerik.Reporting.Processing.ReportProcessor class) to render the report in HTML and put it in the current page (you can use a LiteralControl as the HTML placeholder); on the client side (using a JavaScript or VBScript) handle the IFRAME.onload event and call the print() method for the IFRAME like this:

    this.contentWindow.print()

    where this is the IFRAME instance.

    Regarding the dummy data sources: actually, this thread was initiated by a developer that didn't want to connect to a real data source at design time but needed the Data Explorer support in order to create his/her reports easier. The dummy data source is a possible workaround that supplies the report designer with the needed schema. The bottom line is that you don't need any dummy data source at all.

    About the "Object reference not set to an instance of an object" error in the HTML Preview and at runtime -  the most possible reason I can guess is that you didn't connect any data source to your report. Please, check this and write back with more information.

    In the upcoming service pack (to be released by the end of this week) the problem with the missing data adapters from the list of the available data sources will be fixed and I hope you'll have no more problems with it.

    Your suggestion for the report designer are really good and we'll review them once again when planning the future versions.

     
    Regards,
    Svetoslav
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  6. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 01 Jun 2007 Link to this post

    Hi!

    As I said, web programming is quite new to me, so I appologize for any dumb question I may ask.

    "Print customers" once more. I didn't explain good enough. What I would want to accomplish is to have only one page (lets say Reports.aspx) with ReportViewer on it and then I would like to print reports from other pages (lets say Products.aspx or Customers.aspx) that dont have ReportViewer.
    So, lets say page Products.aspx has a grid displaying products and there is a button "Print products" which should call Report.aspx and load proper report.
    Now, do I have to accomplish that by sending paremeter in query string or or is there any other way?

    "Object reference ..." error. Since I couldn't select SqlAdapter in DataSource property, I right clicked on SqlAdapter and selected "Generate Dataset" and selected option "Add datasource to report". That added datasource to report and I was able to select that dataset and also was able to select DataMember. That enabled me to see data structure and to design report with datafields, but I didnt get data itself on preview.

    How about MasterDetail thing? That is accomplished with Subreports?

    Regards,

    Mario B.
  7. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 02 Jun 2007 Link to this post

    Hi mariob,

    Now I understood your requirement. You can examine the sample solutions we have provided with the Telerik Reporting installation, more specifically the Web Site project that does exactly what you're asking for. 

    One of the possible implementations is to use the query string to pass parameters from one ASPX page to another. The main disadvantage in this solution is that the query parameters are strings that you should process in some way.

    Another option is to use Page.Session and Page.Cache. Both allow you to store and retrieve arbitrary data on subsequent requests. The difference between both is that the Session is associated with the user session while the Cache not.

    Regarding the "Object reference ... " problem, please install the Service Pack 1 that we've released yesterday. It fixes a number of issues at design and runtime. This includes the problems with connection data adapters to the Report.DataSource and the previews too.

    At the moment the SubReports are the only way to create Master-Detail reports. There is a sample in the installation called MasterDetail that demonstrates a hierarchy of 3 reports.
     

    Sincerely yours,
    Svetoslav
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  8. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 04 Jun 2007 Link to this post

    Hi!

    I've installed SP1, but I don't see any difference. There still is no SqlAdapter in list when I click report's Datasource property in Property box.

    I've created a new report and tried from scratch, same thing - I add SqlAdapter1 to report, but I can't select it in Datasource property.

    What am I missing?

    Regards,

    Mario B.

    P.S. This conversation has nothing to do with title of thread any more. Should I create new thread or can you perhaps change title of this one?
  9. Svetoslav
    Admin
    Svetoslav avatar
    649 posts

    Posted 04 Jun 2007 Link to this post

    Hello mariob,

    TelerikReporting_Q1_2007_SP1_trial_setup.exe (file date - June 1, 2007)  installs the latest version of the Telerik Reporting 1.0 SP1, aka v1.1.

    In order to identify the exact reason for your problem we kindly ask you for your cooperation. Please verify that you're using the latest assemblies from the SP1. Here is a list of all files, installation locations and file versions:

    GAC:
        Telerik.Reporting - 1.1.0.0
        Telerik.Reporting.Data - 1.1.0.0
        Telerik.Reporting.Interfaces - 1.1.0.0
        Telerik.Reporting.Processing - 1.1.0.0
       
    [Visual Studio 8 install dir]\Common7\IDE\PrivateAssemblies (usually C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies):
        Telerik.Reporting.Design.dll - 1.1.0.0
        Telerik.Reporting.HtmlRendering.dll - 1.1.0.0
        Telerik.Reporting.ImageRendering.dll - 1.1.0.0
        Telerik.Reporting.VsPackage.dll - 1.0.0.0
        Telerik.ReportViewer.Design.dll - 1.1.0.0
        Telerik.ReportViewer.WinForms.dll - 1.1.0.0

    If you find any discrepancy in the file version and/or file location, please replace the incorrect file(s) with the same file from the Telerik Reporting V1.1 Bin folder (usually C:\Program Files\Telerik\Reporting\1.0\Bin).

     
    Greetings,
    Svetoslav
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  10. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 04 Jun 2007 Link to this post

    Hi!

    ALL files have 1.0.0.0 version, even those inTelerik Reporting Bin folder (I only have Reporting1.0, not Reporting1.1 in Telerik folder).

    I've repeated installation twice just to be sure (made uninstall before). I've even downloaded installation package again, but no change.

    No file has 1.1.0.0 version.
    Am I missing something?

    Mario B.
  11. Vassil Petev
    Admin
    Vassil Petev avatar
    1765 posts

    Posted 04 Jun 2007 Link to this post

    Hi mariob,

    We research the problem right away and will write back as soon as we have some information. It seems the site still has the older version for download. Stay tuned.
     

    All the best,
    Rob
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  12. Vassil Petev
    Admin
    Vassil Petev avatar
    1765 posts

    Posted 04 Jun 2007 Link to this post

    Hi mariob,

    Our fears were confirmed - for some reason our site did not update the old Q1 Trial version to the new SP1 version. This is the first time this happens and the problem will be researched in detail by our web team. The interesting part is that the source code and the documentation files are the proper ones, but the Trial and Dev files were not.

    We have uploaded the files again and triple-tested everything, to make sure that all is OK. Please, download SP1 again and reinstall the Telerik Reporting to take advantage of the latest release.

    Let us know if you still see v1.0.0.0 in the below file locations.
      

    All the best,
    Rob
    the Telerik team

    Instantly find answers to your questions at the new Telerik Support Center
  13. mariob
    mariob avatar
    15 posts
    Member since:
    May 2007

    Posted 04 Jun 2007 Link to this post

    Hi!

    It seems to be ok now. I can select SqlAdapter1 in Datasource property.
    I will continue with testing.

    Thank you,

    Mario B.
Back to Top
DevCraft banner