Recent content by AlexB1234

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...