Search results for query: *

For 1) that's something to think about. It's just quite an effort to create all the business views and modify the reports to use the LOVs as there are quite many reports with different parameters. For 2) Your solution isn't bullet proof. Even if I select the "Format" first and after that the...

Hi, Using Crystal Reports Server XI, running on Win2003 Server, CMS database on a separate server (SQL Server 2000). Reporting against an SQL Server 2000 database using OLE DB. I had some major issues getting this to work. Ended up using the Java version of InfoView (.NET was very unstable)...

For the original requirement the report is working fine. Now I have an additional requirement for this report: I would like to present the results also graphically i.e. show the average for each Goal_Type per quarter. So I would group by Create_Date and Issue_ID. However, because the report is...

Getting close but not quite there yet. <quoting the EU Directive> From 2002 onwards, the summer-time period shall begin, in every Member State, at 1.00 a.m., Greenwich Mean Time, on the last Sunday in March. From 2002 onwards, the summer-time period shall end, in every Member State, at 1.00...

Generally it is advisable to do as much processing as possible at server side (i.e. with Crystal it is usually the database server). But with CR Server, is there any difference (performance-wise) whether you use database functions or crystal functions? In either way, the processing is at "server...

Hmm, seems that any string will do (i.e. can be "DST" but can be as well e.g. "joe" and produce the same output. And it's off by one hour around the time that the transition to daylight savings should take place. Any advice? Br, Ville

Using Crystal Reports XI, MS SQL Server 2000 I have a column in database that stores epoch time (seconds since 1.1.1970 00:00:00 GMT). I how ever need to report that as local Finnish time and take into account the Daylight Saving Time. So is this correct: ShiftDateTime(<date/time column>...

Hey yea, it's working! Thanks a million synapsevampire! (Something i wouldn't have figured out my self, at least not very quickly..) -Ville

Using Crystal Reports XI, MS SQL Server 2000 I have two tables with one-to-many relationship: Issue and Processing. For each Issue there can be 1 or 2 entries in the Processing table, i.e "Resolved" and "Workaround". There is always an entry for "Resolved" (Goal_Type = 'Resolved', Goal_Time =...

Trying to join more than two forms: "To join three forms, you must first join two forms and then join the resulting form to the third, creating a hierarchy of joins. Joining multiple forms in a hierarchical order makes it easier to provide a consistent workflow. If there is a need to combine...

Already asked this in the Action Request System forum, but maybe this forum is busier :) The question: Is it possible to pass parameters to Crystal Reports when running a report through Remedy User? If yes, how do i accomplish this? Using: Remedy 6.0 Crystal Reports XI

Is it possible to pass parameters to Crystal Reports when running a report through Remedy User? If yes, how do i accomplish this? -Ville

Thanks for the tips gortuk and MVisconte! For the driver thing, we're (i think) using ODBC driver provided with Remedy User, not with Crystal. So far i've had no trouble querying the tables.. And yep, they want to run the reports from Remedy User, so direct connection to DB isn't an option. If...

Banged my head to the wall with this one, just a reminder for all you trying to accomplish the similar: "Crystal Reports allows users to generate reports from multiple tables by joining the tables together. AR System ODBC Driver does not support this capability; however, you can achieve the...