Problem when editing existing report

Hi,
I have created Report1.rdl, using a simple select such as
SELECT * FROM Table1 .
Now I want to filter the result, so I go to the Data view, and add a filter
into the GroupCode field.
But when I run again the report, it doesn´t show any data, only the header.
Isn´t it possible to edit a report once you have created it? I suppose it is
possible so, what am I doing wrong?
Thanks in advance,
Ibai PeñaI have found why it happens. I compare the filter field with a blank value,
and no record is found.
Now my question is: Is it possible to create a filter, and make be able to
use it or not, depending on what the user wants?
I have succed filtering data, but once filtered, I´m not able to see all
data again.
Thanks in advance,
Ibai Peña
"Ibai Peña" wrote:
> Hi,
> I have created Report1.rdl, using a simple select such as
> SELECT * FROM Table1 .
> Now I want to filter the result, so I go to the Data view, and add a filter
> into the GroupCode field.
> But when I run again the report, it doesn´t show any data, only the header.
> Isn´t it possible to edit a report once you have created it? I suppose it is
> possible so, what am I doing wrong?
> Thanks in advance,
> Ibai Peña|||My guess is that the filter applied does not return any data and so it is
blank.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Ibai Peña" <IbaiPea@.discussions.microsoft.com> wrote in message
news:A71B86D7-560C-4C3F-90C2-11D0947EFBF5@.microsoft.com...
> Hi,
> I have created Report1.rdl, using a simple select such as
> SELECT * FROM Table1 .
> Now I want to filter the result, so I go to the Data view, and add a
filter
> into the GroupCode field.
> But when I run again the report, it doesn´t show any data, only the
header.
> Isn´t it possible to edit a report once you have created it? I suppose it
is
> possible so, what am I doing wrong?
> Thanks in advance,
> Ibai Peña