Report Manager-Tab Order

I have a mystery. I have a series of reports. Each report has the same
basic parameters all of which except for dates have default values. The
first two are From Date and Through Date. I have couple dozen of these
reports. When I select a report via Report Manager I click my mouse in the
first parameter box. I type date desired and hit tab key. Cursor goes to
Through Date. I type that in and then pressing the enter key activates "view
report". On a small handful of these reports the behavior is different. I
select these from repot manager and put the cursor inthe first parameter box
just like before. Enter the value and then press tab. The cursor does move
to the from date box BUT it doesn't stay there. It immediately leaves.
After this pressing enter does nothing. Using mouse I can put cursor back in
From Date box, but pressing enter still does nothing. I have to actually
click on view report to get it to generate. I'm using Internet Explorer 7.0
and SQL RS 2005. Another strange thing is that these reports are just clones
of each other with some tweaking of the query that returns the data sets.
The same layouts, xml (except query), and properties on all of them. Anyone
have any ideas? Thanks.
--
Thanks, JimOn Aug 9, 2:14 pm, Jim B <J...@.lightning.com> wrote:
> I have a mystery. I have a series of reports. Each report has the same
> basic parameters all of which except for dates have default values. The
> first two are From Date and Through Date. I have couple dozen of these
> reports. When I select a report via Report Manager I click my mouse in the
> first parameter box. I type date desired and hit tab key. Cursor goes to
> Through Date. I type that in and then pressing the enter key activates "view
> report". On a small handful of these reports the behavior is different. I
> select these from repot manager and put the cursor inthe first parameter box
> just like before. Enter the value and then press tab. The cursor does move
> to the from date box BUT it doesn't stay there. It immediately leaves.
> After this pressing enter does nothing. Using mouse I can put cursor back in
> From Date box, but pressing enter still does nothing. I have to actually
> click on view report to get it to generate. I'm using Internet Explorer 7.0
> and SQL RS 2005. Another strange thing is that these reports are just clones
> of each other with some tweaking of the query that returns the data sets.
> The same layouts, xml (except query), and properties on all of them. Anyone
> have any ideas? Thanks.
> --
> Thanks, Jim
>From what I can understand, some of the reports seem to have defaults
for the second parameter and some don't. You may want to check the
default properties of the report parameters to make sure that they are
consistent. Also, you may want to make sure that you have the latest
Microsoft updates (for IE7, SQL Server 2005 SP2, etc). If this does
not resolve the problem, you may want to re-upload the reports. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Aug 9, 2:14 pm, Jim B <J...@.lightning.com> wrote:
> I have a mystery. I have a series of reports. Each report has the same
> basic parameters all of which except for dates have default values. The
> first two are From Date and Through Date. I have couple dozen of these
> reports. When I select a report via Report Manager I click my mouse in the
> first parameter box. I type date desired and hit tab key. Cursor goes to
> Through Date. I type that in and then pressing the enter key activates "view
> report". On a small handful of these reports the behavior is different. I
> select these from repot manager and put the cursor inthe first parameter box
> just like before. Enter the value and then press tab. The cursor does move
> to the from date box BUT it doesn't stay there. It immediately leaves.
> After this pressing enter does nothing. Using mouse I can put cursor back in
> From Date box, but pressing enter still does nothing. I have to actually
> click on view report to get it to generate. I'm using Internet Explorer 7.0
> and SQL RS 2005. Another strange thing is that these reports are just clones
> of each other with some tweaking of the query that returns the data sets.
> The same layouts, xml (except query), and properties on all of them. Anyone
> have any ideas? Thanks.
> --
> Thanks, Jim
>From what I can understand, some of the reports seem to have defaults
for the second parameter and some don't. You may want to check the
default properties of the report parameters to make sure that they are
consistent. Also, you may want to make sure that you have the latest
Microsoft updates (for IE7, SQL Server 2005 SP2, etc). If this does
not resolve the problem, you may want to re-upload the reports. Hope
this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Report Headers showing on blank page

I hope someone will have time to answer a really basic RS question.

I have a simple report, the query will only return a few rows (16 - 20), my header is repeating on a 2nd blank page. I'm sure it's because I grouped on a column from the record set. I can not find where you delete the grouping.

Anyone have any good suggestions on RS books?

Thanks

Hey Marc,

There are a couple of places to check:

When you click on the table, are there rows that have little numbers on them (1,2, etc)? If so, you should be able to right-click on these and select Delete Groups.

Another place could be the Properties of the table (Select the table, right click on the Properties option). Select the Grouping tab. Delete any of the groups in there (usually named something like "details_group")

Good luck!

Jessica