Skip to Content
author's profile photo Former Member
Former Member

Report that Forces a User to Input a Date Range

Greetings,

I am generating a work times report and would like to force the user to select a date range when the report first opens. This would pull only the data for the specified range from my database.

I prefer drop down lists or calendars, but am wondering if this is possible.

I guess one other important element is that I would like to "dumb down" the interface, so the user of the report does not have access to all of the features of the program. Basically I only want them to have read privileges.

I'm new to CR, so would appreciate any guidance.

Thanks

Peter

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 05:27 PM

    The ODBC data source is setup as a System DSN via Windows ODBC Data Source Administrator.

    I did not set it up through the Viewer; I don't think it is possible using Logicity

    I did set it up in CR 2008 of course

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Peter,

      I was referring to the non-development, client pc's that will be running the viewer.

      On each machine, you will have to go to Control Panel > Administrative Tools > Data Sources

      and make sure each pc has the same ODBC connection that you are using on your development machine.

      Jason

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2008 at 11:52 PM

    I have a document that has detail instaruction on how to do this, I could e-mail it to you if you would like. It has examples and pictures, ect.

    Shaun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 30, 2008 at 11:55 PM

    Hi Peter,

    Create a new parameter in the crystal report and select the data type as date field and values as static. Also in the values option select alow range values as true.

    Now go to menu option Report >selectionformulas >record and write

    {Datefield from database}={?parameter}

    this helps you to get the data in date range.

    If you want to make the report read only then goto file-->reportoptions and check the option read only.

    Regards,

    Raghavendra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 12:46 AM

    Thanks Raghavendra

    That got me started, but how do I force the user to enter a date range when the report first opens ??

    In other words, a prompt that displays when the report is opened that states: "Please Select a Date Range for Your Report"

    Also...if I do that, can the report still be "read only" ?

    Thanks

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Here is what the Help system has to say about the read only feature:

      You can make a report, section, area, or object read-only so it can't be formatted. 
      When you set this option, choices in the Format Editor become inactive. 
      The formatting options that are usually available on the toolbars or shortcut menus are also suppressed for the report or object.
      
      Note:    This feature is for your convenience in protecting report formatting; it is not intended to be used as report security.
      

      Also, if you want the user to be prompted for parameter values each time they open the report, take the check mark out of the

      "Save Data with Report" option.

      Jason

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 01:28 PM

    Thanks Jason,

    That option of not saving the data with the report presents a new set of problems, maybe I can set it up as an ASP page. I really only want people to view and print the reports, and not have access to any of the other program functions.

    The people that will generate the final report(s) have very limited skill sets.

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Peter,

      Will the viewers of the report have full copies of CR or will they be viewing with CR Viewer.

      If they have CR Viewers only, then the read only issue is no issue at all. You can't modify a .rpt from within viewer.

      As far as the "Save Data With Report" option, What problems is that causing?

      Jason

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 01:59 PM

    Jason,

    Crystal Reports Viewer would be perfect, but I cannot "refresh" the report data or enter new paramater values (date range).

    As far as "save data" is concerned, when that option is de-selected, the user is brought to the Design Page, and for these people it is an invitation for trouble, even though I have it locked.

    Thanks

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 02:49 PM

    Jason,

    I'll try it and see...

    what do you mean, "save a ton of cash" ??

    isn't the Crystal Reports Viewer "free" ?

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Peter,

      CR Viewer is free, but from the sound of your previous post, it sounded like it wasn't going to work for you.

      I had the impression that you were going to have o put full versions of CR on end user machines.

      If I misunderstood, sorry. Either way, I like that particular viewer.

      Jason

  • author's profile photo Former Member
    Former Member
    Posted on Jul 31, 2008 at 03:07 PM

    I guess there's always a catch.

    Logicity works great at refreshing except it prompts the user for the database password each time and I can't allow that...

    Sheeesh

    Peter

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.