Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by bielet

  1. bielet

    CR Server XI and scheduling

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

    CR Server XI and scheduling

    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)...
  3. bielet

    "NA" for no entry

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

    ShiftDateTime and daylight saving

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

    Database Server vs. Crystal Reports Server

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

    ShiftDateTime and daylight saving

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

    ShiftDateTime and daylight saving

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

    &quot;NA&quot; for no entry

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

    &quot;NA&quot; for no entry

    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 =...
  10. bielet

    Remedy AR System and Crystal Reporting

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

    Remedy AR System and Crystal Reports XI

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

    Crystal Reports XI in ARS - parameters

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

    Remedy AR System and Crystal Reporting

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

    Remedy AR System and Crystal Reporting

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

Part and Inventory Search

Back
Top