Search results for query: *

Just throwing out some ideas...if the report is part of an application you could write the settings to the user's registry, or to a file that you read before running the report, or to a table in the database. Good luck.

It sounds like you need to open the connection to the database, or specify connection information, i.e. user_id, password, server, etc. I don't ususally connect through Crystal so I don't know the exact syntax, but I think there's a .LogOnInfo property that you can user to specify that. I...

Don't do much Oracle development, but I think I've got a simple problem. I'm trying to test whether the value in a varchar field is numeric with the following user defined function. The problem is I don't know how to trap for an Oracle error inside the function. Anyone? CREATE OR REPLACE...

I've got an app where I do essentially the same thing. Iniitally I got alot of query errors from Crystal. They went away after I created the DS as an XML DS, based the report off that and only filled the DS dynamically. I think crystal blows up if there's the slightest difference in field...

I've got a .NET application that includes crystal reports. The problem I have on 1 machine is that when the user drills down and I open another crystal report in a new window (target = _blank) I get an empty window. Naturally, it works fine on all the other machines. It's IE 6.0 with SP1 but...

I'm trying to do it programmatically. I think I need to pass the linking parameters but I don't know how to do that. Any ideas?

In Crystal for Visual Studio .NET the ReportDocument object has a .SetDataSource property that allows you to pass a recordset. There's also a Reportdocment.Database.Tables(0).SetDataSource for passing a recordset to an individual table. Hope that helps.

Trying to export an on-demand subreport, i.e. a user clicks the link that displays the sub-report, when I execute .Export() the main report, not the subreport, exports! If I call .Export on the subreportobject I get "Error: Missing parameter field current value". Any ideas anyone?

If you CAN I've never seen it done. Why not do it in your application after running your report? In psuedo code something like.... Sub Button_Click() Report1.Show SQL = "Update table1 set blahblah = 'abc';" Connection.execute SQL End sub

In an ASP.NET app that I have I can do the following to print a report: Dim Rep as new CrystalReport1 'Open the report first . . 'This is the name of the printer as it is defined on the server Rep.PrintOptions.PrinterName = "Hp_laserjet1" Rep.PrintToPrinter(1, False, 1, 999)

It sounds like you need to filter the data to limit the number of records you're returning. Maybe add some parameter fields where a user can enter a date range or range of customers??

I don't do alot of SQL from within Crystal but if I recall correctly you can open and edit the SQl window in crystal. If that's the case you can just type the Union query you need, e.g. Select Field1, Field2 From table1 Union Select Field1, Field2 From table2;

For the life of me I can't remember how to set the page orientation in a .NET Crystal Report in the designer...aaarg!

If it changes the whole report could you change it back when the subreport finishes? Just a thought.

I've done this two different ways with CrystalReports in ASP.NET: 1) set the selection formula in the report dynamically and 2) generate the SQL data dynamically. You may only need to do one depending on your requirements. Here's some code: 'In ASP the following code should be inserted into...

I believe you need to put it in the group footer so it will reset with each group. It has to go in the footer so that it will count everything. Also in Crystal .net you can create a Summary field and specify that it resets with a particular group (you indicate the group) on the property page.

Just deployed an ASP.NET application and everything except Crystal Reports works fine. Naturally it works fine on the development machine and even on another test machine; it's just production that's hosed! Anyone ever get the following error when you try to open the Crystal web report viewer...

You might want to check your indexes to make sure that all of the fields in your joins, as well as Where/Group By clauses are covered.

You could put a viewer on each tab. If you have alot of tabs that might not be efficient, though. If that's the case you might try reusing a viewer by simply changing the ReportSource property.

I've got an ASP.NET application that uses a half dozen crystal reports. It's in VB not C#, but you should be able to follow it since the basic premise requires little code. The way I did it is... Create a report(s) in the project. Then add a webform with the crystalreportviewer control. In...