Iron Speed Technical Forums

Crystal Reports Class not registered error

Wed, 16 May 2012 21:29:47 GMT

Can someone please tell me how to resolve this error! Using ISD9.0.1, CR 10 Dev, I have reader installed. 3 table ISD application, very basic. Can not get a .rpt report to display after adding Report Display Button.

I am getting the following error!

Retrieving the COM class factory for component with CLSID {CF76A644-314B-404D-8D45-F08B51FF990B} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)). Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Retrieving the COM class factory for component with CLSID {CF76A644-314B-404D-8D45-F08B51FF990B} failed due to the following error: 80040154 Class not registered (Exception from HRESULT: 0x80040154 (REGDB_E_CLASSNOTREG)).

Source Error:

Line 216: public void CrystalReportButton_Click(object sender, System.EventArgs e) Line 217: {Line 218: CrystalDecisions.CrystalReports.Engine.ReportDocument crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument();Line 219: string fileName= @"..\Reports\Mileage Report.rpt";Line 220: try
Source File: c:\MyApp1\ttmileage\ShowTtmileageTable.aspx.cs Line: 218

Stack Trace:

CrystalDecisions.CrystalReports.Engine.ReportDocument..cctor() +19 CrystalDecisions.CrystalReports.Engine.ReportDocument.r() +55 CrystalDecisions.CrystalReports.Engine.ReportDocument..ctor() +221 MyApp1.UI.ShowTtmileageTable.CrystalReportButton_Click(Object sender, EventArgs e) in c:\MyApp1\ttmileage\ShowTtmileageTable.aspx.cs:218 System.EventHandler.Invoke(Object sender, EventArgs e) +0 System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument) +155 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3707

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.272

Thanks

Forum: Using Iron Speed Designer V9.X

Uable to add pages

Wed, 16 May 2012 21:09:03 GMT

All of the sudden Im unable to add pages to my ISD project the wizard finishes buth the new pages are not beign added this only happens to me in one project has any ever encounter an error like tath?

Thanks a lot

Forum: Running & Deployment Issues V8.X

Crystal Reports Logon Information

Wed, 16 May 2012 20:58:32 GMT

I'm struggling with amending the code for a crystal report button in my application.

I have changed the obvious connection information, however it throws an error when I try to get to the Crystal Report. This is where i'm at with the code.

CrystalDecisions.CrystalReports.Engine.Database db = crReportDocument.Database;

CrystalDecisions.CrystalReports.Engine.Tables tables = db.Tables;

CrystalDecisions.Shared.TableLogOnInfo tableLoginInfo = new CrystalDecisions.Shared.TableLogOnInfo();

////define connection information

CrystalDecisions.Shared.ConnectionInfo dbConnInfo = new CrystalDecisions.Shared.ConnectionInfo();

dbConnInfo.UserID = "USERNME";

dbConnInfo.Password = "PSSWDXX";

dbConnInfo.ServerName = "SERVER";

dbConnInfo.DatabaseName = "DATABASENAME";

////apply connection information to each table

foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables)

{

tableLoginInfo = table.LogOnInfo;

tableLoginInfo.ConnectionInfo = dbConnInfo;

table.ApplyLogOnInfo(tableLoginInfo);

}

Forum: Using Iron Speed Designer V9.X

Sticky Footer

Wed, 16 May 2012 18:45:08 GMT

Has anyone figured out how to add a sticky footer? I can do it in a standard master page but don't seem to be able to do so in IS9.

Ths,

Ken

Forum: Using Iron Speed Designer V9.X

GROUP BY

Wed, 16 May 2012 18:10:44 GMT

I have a page with a Table view that show records like this

State      Total_Field1     Total_Field2
CA          5                    1
CA          3                    4
NY          2                    3
etc..

How can I change this to a GROUP by State column?
What I am trying to get is this from the Data above

CA           8                   5
NY           2                   3

I Try to look into the Select Query but it doesn't allow me to alter it to create GROUP BY

Thanks for any feedback

Updated! I create a VIEW to get the Group by results and create page to get the values. It works, but I am still want to know if it is possible to do the Group by without View.

Forum: Using Iron Speed Designer V9.X

CS0103: The name does not exist in the current context

Wed, 16 May 2012 17:15:24 GMT

Hello all,

I have added an ASP.Net control (a label named lblName) to one of my tables, following this video tutorial. I added a simple label, clicked Build, and then went to the aspx.cs codebehind file to reference the control. I type the following in the LoadData() method: lblName.Text = "John"; and I get the following error when I build: CS0103: The name ' lblName' does not exist in the current context.

I have verified that the codebehind file is not being referenced by any other file and that the names are correct (case sensitive). I noticed that there is no .designer.cs but I figured that is because of how ISD operates.

Forum: Using Iron Speed Designer V8.X

How to Calculate Discount in ISD 9.x?

Wed, 16 May 2012 15:40:58 GMT

Hello There,

Is there any formula or method to calculate Discount in ISD 9.x ?

any helpful tutorial or video ?

Cheers

Forum: Using Iron Speed Designer V9.X

What does Ironspeed pick up of constraints, defaults etc?

Wed, 16 May 2012 09:04:26 GMT

Are there any documentation about what information Ironspeed should bick up from the database schemas, and how it acts on it?

In our case we have simple "Y"/"N" constraints that it doesn't not utilize.

Also it doesn't utilize a default .
(Except for knowing a mandotary field does not have to be populated).

This is Oracle.
Thanks

Forum: Using Iron Speed Designer V9.X

First visit to page with chart gets error

Wed, 16 May 2012 02:53:18 GMT

Anyone having this issue where the first visit to a page with a chart gets an error but subsequent visit displays correctly?

Forum: Using Iron Speed Designer V9.X

Unable to create database stored procedures

Tue, 15 May 2012 21:11:51 GMT

Hello all, I have inherited an Ironspeed application and I’ve been asked to make some changes (so I’m pretty new to the program).

I have my application working fine, but when I change a view in the database and then synchronize the schema, I get the error “Unable to createdatabase stored procedures.” I thought maybe it was my permissions, but Igenerated a new app from the same database and then edited the same view and synchronizedand it worked without error (same connection string). What could be in my app that is causing this error?

Forum: Using Iron Speed Designer V8.X

Problem in application

Tue, 15 May 2012 20:08:54 GMT

Ive get this error.... somebody knows what this can be???

Server Error in '/Portefolio' Application.

--------------------------------------------------------------------------------

Parser Error

Description: An error occurred during the parsing of a resource required to service this request. Please review the following specific parse error details and modify your source file appropriately.

Parser Error Message: Unknown server tag 'InsuranceortefolioTableControl'.

Source Error:

Line 64:

Line 65:

Line 66:

Line 67:

Line 68:

Source File: /portefolio/portefolio/ShowPortefolioTablePage.aspx Line: 66

--------------------------------------------------------------------------------

Forum: Using Iron Speed Designer V9.X

100% window height

Tue, 15 May 2012 19:35:28 GMT

I have a page in which I have a long table control (allowing it to scroll rather than have multiple pages for ease of use by my user).

I have added a scrollbar to the table control so that now the header/horizontal menu/title bar/parent record control / stays fixed on the top, while the internal scrollbar scrolls through the child table control. This works great.

The problem comes in with the height on the window and application in general. If I leave the table control height as default, it shows all rows. If I set a defined height (currently 600 pixels) for the table control, it fits well on some windows/monitors, and poorly on others.

Is there any way to set the height of an application or control to 100% similar to what you can do with width? I have 100% width working well through the CSS.

Thanks!

Forum: Using Iron Speed Designer V9.X

Really want to figure out "Add GeoLocating to your mobile IS application"

Tue, 15 May 2012 16:10:53 GMT

I stumbled upon something that could be very useful to my application, generously posted by PinBot here

Like many customizations, I first tried to replicate exactly what is in the example in a sample application and database, then when I get that to work I apply the proper customization to my real app. I made an MS SQL database with one table and one view and followed the instructions very carefully, but I keep getting this error after I insert the C# code in the example:

'SampleApp.UI.Controls.FindApartments.GetClosestPropertiesViewTableControl' does not contain a definition for 'Datasource' and no extension method 'Datasource' accepting a first argument of type 'SampleApp.UI.Controls.FindApartments.GetClosestPropertiesViewTableControl' could be found (are you missing a using directive or an assembly reference?)

From this code:

this.Datasource = (GetClosestPropertiesViewRecord[])(clearlist.ToArray(typeof(MobileGeolocating.Business.GetClosestPropertiesViewRecord)));

Also, I see that the stored procedure is altering an existing stored procedure, I changed it to a "CREATE PROCEDURE", but I haven't gotten past this error to know if that is an issue or not. I feel like I am so close in getting this to work, but
I'm not sure why this keeps tripping me up. Any help would be MUCH appreciated! Again, thanks PinBot for posting this, never even thought about trying this before your post.

Forum: Code Customizations V9.X

Adding a Crystal Reports Viewer

Tue, 15 May 2012 15:15:54 GMT

There is an old article on adding a Crystal Reports viewer to an IS app but it is so out of date that I can't figure out from it how to do this in IS 9. Does anyone have an example or a link to something that is up to date?

The idea is to get a real CR viewer and not just a pdf displayed in the browser.

Forum: Code Customizations V9.X

Encrypt/Decrypt Passwords

Mon, 14 May 2012 17:33:50 GMT

Akesh G. has a Video Demo entiltled Encrypting Passwords in Iron Speed Designer

The last section of his video states to add some code to SignIn.aspx.vb(see below).

This code does not work for SignIn.aspx.cs.

Can some please provide me with the correct code for C#?

Thanks in advance!

Code:

If Me.Password.Text.Length > 0 Then 
Me.Password.Text = BaseFormulaUtils.EncryptData(Me.Password.Text)
End If

Thanks

David

Forum: Using Iron Speed Designer V9.X