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!

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

Search results for query: *

  1. jrkrish

    BECP exam

    No Durga.. I haven't appeared for the exam yet.. Just got back to BO role!! I guess it is time for me now to take the test! Krish
  2. jrkrish

    Filtering the dates of dimension member

    Hi Gurus, I need your help. I am new to using MDX in MSAS. I am creating a report which should display the values for the latest snapshot date dimension (only!), when thhe report is opened. I am able to display the dates in sorted order but not able to filter only one date, i.e latest date in...
  3. jrkrish

    Only display the current month

    Sorry if I have misled you. But as I mentioned in my previous thread, I am using OLAPI tool for the report not the CR.
  4. jrkrish

    Only display the current month

    Thanks Madwac and Syna for your suggestions. Actually both of the suggestions are not working. Let me explain in detail for the better understanding of the problem. OLAP cube is MSAS and reporting tool BO OLAP XI(OLAPI). I have a shared dimension in the snapshot date and members will be one date...
  5. jrkrish

    Only display the current month

    snapshot dates (as of date is the member) is one of the shared dimension in the MSAS. When we use that in the CAR report, I want ONLY the most recent "as of date" to display when I open the report. How should I do that? Is there a formula I can write..
  6. jrkrish

    Did any one appear for BECP exam recently? Need some tips..

    Did any one appear for BECP exams recently? Need some tips as I am planning to appear for Level 1 and II next week. Thanks.
  7. jrkrish

    General SQL Error. Connection does not exist.

    PDF document which explains all kinds of possible general SQL errors is available in the crystal website. Serach for "general sql errors" in Kbase. There may be problem with the dll files. Try connecting MS Access file through ODBC file. Are you using Informix connect 2.7?? Krish
  8. jrkrish

    How to handle local recordsets in standalone CR 8.5

    I would like to extract the data from database and then keep it in one record set. Based on the results in the recordset, I would like to go for second recordset with out hitting the database. Also there is a need that I would combine both to go for the third recordset for the results. Is it...
  9. jrkrish

    Getting an error ""All network licenses are in use"

    I am getting an error when opening a report file in my workstation like "All network licenses are in use. You will be able to run Seagate Crystal Reports when a user leaves the program.". I tried opening only one report. Normally when you try to open two instances of CR, you get this...
  10. jrkrish

    Want to calculate total minutes between start and stop date..

    Thankyou Ido for the help. But the problem is right now I am using 7.0. I was not able to see any function with the name "Datediff". In this case, which method will be best to use. Thanks, Krish
  11. jrkrish

    Want to calculate total minutes between start and stop date..

    I have start and stop date for each system outage detail record. What I want to know is, how can I calculate the total minutes between these two dates (I want to plot that in a graph..) I tried with some FAQs and none of them are working. Thanks in advance for your help..

Part and Inventory Search

Back
Top