Search results for query: *

What formula are you using, which function are you using to call the date?

dugald: You should be able to use the Crystal Reports COM object to integrate with Java. Seagate probably has about half a page of documentation on it so it won't be easy. Crystal can usually get to Oracle with no problem. Check the Seagate website for more details Kathryn

My advice is to invest now and build your own tool for scheduling and use your server or database for security. Seagate Info is really hard to customize. If you want to validate parameters or do any GUI stuff before the report is called, Info will be frustrating. On the other hand, if you...

Will you be using Crystal Reports to view/print data in the warehouse? If so, there are many things the DBA can do to make reporting easier, faster and more stable. Be careful of overnormalization. If your report developers want descriptions stored where a code will do, trust them. Build...

Check your VB code and make sure you're setting ALL the export options. You have to tell it it's a "disk file" as well as that you want the format to be Word. I had this problem last week myself so if that doesn't fix it, repost. I have all the stuff Seagate put me through to get it...

Ah, I see, that would be a bigger problem. Crystal has several preset date groupings but I don't remember if biweekly is one of them. If so, that would work, otherwise you would have to build your own table. K

The way I handle this sort of thing is to create a formula field. The code would be something like this: If isnull({dateField}) then todate("01/01/2001") else {dateField} This is a way of forcing a default in code without changing any databases. K

Well, it seems pretty strange. One thing you can try which may help you debug this is to set up some new formulas. One which is just trim({cpfind.RECNO}) and one that is tonumber({cpfind.RECNO}). Place these formulas on the report near the original formula and see what shows up. Also, just...

So, is it not picking up any of the numbers? All of the results are "bogus"? One thing you can try is using single quotes ('2','3' e.g.). I think the tonumber(x) suggestions is a good one too. Kathryn

You can pass data from sub reports to main reports, but it is tricky. You have to use formulas and set variables within the crystal code. I wish I had a solid example to give you. I know if you dig enough, you can find examples from the Seagate documentation. Also, there are much more...

Have you saved the reports as .rpt files? Does that work? In what ways do the other formats "not work". I've encountered a lot of problems with supression logic in exports, including Word, which is very annoying. Usually, the most reliable "save as" format is an .rpt, but...

Can any of the parameters get to the database? In other words, if you called a report that wasn't a sub report and that report called a stored proc, would the parameter work? If not, there may be an issue on the database end. Some databases need to be tweaked in order to pass parameters from...

Make sure you have no nulls in your recordset. The OLEDB can be very picky about nulls and may read the whole column as invalid. Also, make sure there are no stray characters or spaces. Then, verify the database. It's been a while since I worked with this, but I did hammer out the bugs, let...

The Seagate web site has some really good examples of VB apps. The names are somewhat cryptic, but they have reasonable explanations. You will need to decide several things right off the bat. How are you going to connect to your data? How are you going to handle security on the database...

I think this is a setting in Excel and there's nothing the report can do about it. However, you may be able to write an Excel macro to open the report and immediately reformat the column. Depending on what else you want to do once you get it to Excel, you might want to pass it as a string...

Dear Gennady: You have discovered very quickly what it takes many people a long time to discover. It is always better to use Crystal primarily as a display tool and let the database do the hard work. However, a few stored procedures and some very basic SQL can make all the difference in the...

How are you calling the export? Do you set the export options in code or with Crystals GUI? Does the export work from crystal if you don't go through VB? I've made this work to some extent, never had it stop responding. However, the supression logic is sometimes lost.

This is exactly what I'm doing on my current project. The secret seems to be setting the data source as a ".ttx" file. Try "ttx" in your searching for better results. Seagate has sent me several examples. Note, the documentation is pretty bad when it come to CR ver 8.0...

This may not be very helpful, but check out the help files for "passing values to sub-reports". I've had this problem too and I can't remember the details of the solution. Kathryn

Are you using an ODBC connection to the text files? How do you create indexes on the text files at all? I know you can use the fields from the text file(s) as links within Crystal, but I'm pretty sure that's a one-to-one situation. I've been able to connect to text files using the DAO data...