Crystal V9 Range selection

Hi all,

I have installed SP3. whilst in the development environment, I have created a simple report that just lists everything from a single table. This works fine.

I then introduced a range parameter on one of my fields. then go to preview and enter a valid range, but the results still show all records???

Cant believe this is a enuine bug, as it's pretty fundemental. What am I doing wrong?What datatype it is? I tried with date range. It works fine.|||the field type is a character string and the database is an Access 2000 one.

The values are 2 characters like:

LA LB LC LD LE ......and so on.

when I enter a start of LB and and end LD for instane, it returns All|||check ur selection formula.|||I have now removed all parameter fields and will walk you through what I am doing.

I have the field explorer open and have right clicked on the parameter fields and selected new.

this displays a create parameter field dialog box I then enter a value in the name and propting text values leaving value type as string. I change options to range values then press the button set default values. I ensure that the table is correct and then set the browse field with the column from the table that I want to filter on. Then in the left hand pane it displays all values relating to that column. I press the >> button to make all values the default I then set the order to alphabetical ascending i then press ok. it goes back to the previous dialog and I leave allow editing of default values checked and press ok.

My parameter field now exists in the field explorer window under parameters. I drag this to the report header, and press preview I'm them prompted for a start and end of range which I enter, I then press ok, and then I'm returned all values.

???:confused:|||Everythings looks correct.

The last step is, you have to write the record selection formula.

Goto Report menu, select "SelectFourmula" and then "Record..."

This will opens the edit formula window.

Here select your database field and then give in condition which will be suitable for range values and then select ur parameter field.
This looks like

{table.column} in {?parameter}

now save and close this.

Refrsh the report|||Ah....thx the manual doesn't mention the last bit. It works now.

CryptographicException

I started getting the error
CryptographicException "the parameter is incorrect" whilst designing a
report. Interestingly, I removed everything from the report so there is
nothing in the report, including the dataset and I still get this error. I
guess it must be corruption in the RDL. Can anyone suggest where I might
look?
thanksHi,
I get this error very often while designing reports.
When you get this error, Just Save the changes and Close the Project. Open
it again, you will not have the error.
Hope this helps
Ponnurangam
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
>I started getting the error
> CryptographicException "the parameter is incorrect" whilst designing a
> report. Interestingly, I removed everything from the report so there is
> nothing in the report, including the dataset and I still get this error.
> I
> guess it must be corruption in the RDL. Can anyone suggest where I might
> look?
> thanks
>|||I got this problem also. The problem exists even after I reboot my computer.
There are other corruption issues, such as all of a sudden, the report would
stop passing parameter to execute a stored procedure in dataset... Again,
saving, closing, rebooting, and reopening didnt help. I ended up having to
recreate the rdl,
I now establish version control, so that I can revert back to an older,
workable version.
"Ponnurangam" wrote:
> Hi,
> I get this error very often while designing reports.
> When you get this error, Just Save the changes and Close the Project. Open
> it again, you will not have the error.
> Hope this helps
> Ponnurangam
> "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
> >I started getting the error
> > CryptographicException "the parameter is incorrect" whilst designing a
> > report. Interestingly, I removed everything from the report so there is
> > nothing in the report, including the dataset and I still get this error.
> > I
> > guess it must be corruption in the RDL. Can anyone suggest where I might
> > look?
> >
> > thanks
> >
> >
>
>|||Thanks for your replies,
I found that deleting the data file resolve the problem in my case.
regards
Matt
"LBJOHN" <LBJOHN@.discussions.microsoft.com> wrote in message
news:B7A559E8-576B-43AC-9164-548AC6F145BA@.microsoft.com...
> I got this problem also. The problem exists even after I reboot my
computer.
> There are other corruption issues, such as all of a sudden, the report
would
> stop passing parameter to execute a stored procedure in dataset... Again,
> saving, closing, rebooting, and reopening didnt help. I ended up having
to
> recreate the rdl,
> I now establish version control, so that I can revert back to an older,
> workable version.
> "Ponnurangam" wrote:
> > Hi,
> >
> > I get this error very often while designing reports.
> >
> > When you get this error, Just Save the changes and Close the Project.
Open
> > it again, you will not have the error.
> >
> > Hope this helps
> >
> > Ponnurangam
> >
> > "Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
> > news:eGGM$BYvEHA.3856@.TK2MSFTNGP10.phx.gbl...
> > >I started getting the error
> > > CryptographicException "the parameter is incorrect" whilst designing a
> > > report. Interestingly, I removed everything from the report so there
is
> > > nothing in the report, including the dataset and I still get this
error.
> > > I
> > > guess it must be corruption in the RDL. Can anyone suggest where I
might
> > > look?
> > >
> > > thanks
> > >
> > >
> >
> >
> >