group toggle works in desinger but not when published

Folks -
I have a date group in a simple detail report that toggles the detail
records by date. I used the report desinger wizard to create the initial
report, which toggles fine in the desinger. When published, the toggle
functionality does not work, and no detail records can be
accessed/displayed. RS
server and my VS install have all the latest SPs and patches.
Ideas?
Please reply to the group.
Eric HallI had a very similar problem and worked out by accident that it was because I
was using "lines" in the page header and footer. I removed the lines and used
very thin rectangles and all is good. Very weird though...I think that this
must be a bug.
"Eric Hall" wrote:
> Folks -
> I have a date group in a simple detail report that toggles the detail
> records by date. I used the report desinger wizard to create the initial
> report, which toggles fine in the desinger. When published, the toggle
> functionality does not work, and no detail records can be
> accessed/displayed. RS
> server and my VS install have all the latest SPs and patches.
> Ideas?
> Please reply to the group.
> Eric Hall
>
>
>sql

group expression

Hello, I am very new to Reporting Services and want to do something I have
done in other programs using a tool or wizard. I want to group my data by "
30 days over due" , then " 60 days over due" etc..Based on the following
DAYSDUE > 30 and < 60
DAYSDUE > 60 and < 90
DAYSDUE > 90 and < 120
DAYSDUE > 120
I think it will need to be an expression in the group dialog box, but for
the life of me I cant's seem to come up with it. Any help would be
appreciated. ThanksTry this:
=iif(Fields!Daysdue.Value > 120, 1, iif(Fields!Daysdue.Value > 90, 2,
iif(Fields!Daysdue.Value > 60, 3, iif(Fields!Daysdue.Value > 30, 4, 5))))
The expression basically maps the integer values to five distinct groups: 1,
2, 3, 4, 5
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"SLB" <SLB@.discussions.microsoft.com> wrote in message
news:D262B295-7A20-45F0-B6A4-1ADC448FD970@.microsoft.com...
> Hello, I am very new to Reporting Services and want to do something I have
> done in other programs using a tool or wizard. I want to group my data by
> "
> 30 days over due" , then " 60 days over due" etc..Based on the following
> DAYSDUE > 30 and < 60
> DAYSDUE > 60 and < 90
> DAYSDUE > 90 and < 120
> DAYSDUE > 120
> I think it will need to be an expression in the group dialog box, but for
> the life of me I cant's seem to come up with it. Any help would be
> appreciated. Thanks
>

GridView wont delete or update

I have had this problem before but it turned out to be dodgy SQL created by the wizard. Doesn't seem to be the case this time.

The following does a postback but makes no changes.

1<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ehlConnectionString %>"2DeleteCommand="DELETE FROM [tblSubRegions] WHERE [SubRegionID] = ?"3InsertCommand="INSERT INTO [tblSubRegions] ([SubRegionID], [RegionID], [SubRegionName]) VALUES (?, ?, ?)"4ProviderName="<%$ ConnectionStrings:ehlConnectionString.ProviderName %>"5SelectCommand="SELECT tblSubRegions.SubRegionID, tblSubRegions.RegionID, tblSubRegions.SubRegionName, tblRegions.RegionName FROM (tblSubRegions INNER JOIN tblRegions ON tblSubRegions.RegionID = tblRegions.RegionID) WHERE (tblSubRegions.RegionID = ?) ORDER BY tblSubRegions.SubRegionName"6UpdateCommand="UPDATE [tblSubRegions] SET [RegionID] = ?, [SubRegionName] = ? WHERE [SubRegionID] = ?">78<DeleteParameters>9 <asp:Parameter Name="SubRegionID" Type="Int32" />10</DeleteParameters>1112<UpdateParameters>13<asp:Parameter Name="RegionID" Type="Int32" />14<asp:Parameter Name="SubRegionName" Type="String" />15<asp:Parameter Name="SubRegionID" Type="Int32" />16</UpdateParameters>1718<SelectParameters>19<asp:ControlParameter ControlID="dropRegions" Name="RegionID" PropertyName="SelectedValue" Type="Int32" />20</SelectParameters>2122<InsertParameters>23<asp:Parameter Name="SubRegionID" Type="Int32" />24<asp:Parameter Name="RegionID" Type="Int32" />25<asp:Parameter Name="SubRegionName" Type="String" />26</InsertParameters>2728</asp:SqlDataSource>29303132<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ehlConnectionString %>"33ProviderName="<%$ ConnectionStrings:ehlConnectionString.ProviderName %>"34SelectCommand="SELECT [RegionID], [RegionName] FROM [tblRegions]">3536</asp:SqlDataSource>37383940<asp:DropDownList id="dropStates" runat="server" OnSelectedIndexChanged="dropStates_SelectedIndexChanged" AutoPostBack="True">41</asp:DropDownList>4243<asp:DropDownList id="dropRegions" runat="server" OnSelectedIndexChanged="dropRegions_SelectedIndexChanged" AutoPostBack="True">44</asp:DropDownList>45464748 <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"49 AutoGenerateColumns="False" EnableViewState=false Width="100%" DataSourceID="SqlDataSource1">50 <Columns>51 <asp:TemplateField HeaderText="SubRegionName" SortExpression="SubRegionName">52 <EditItemTemplate>53 <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource2"54 DataTextField="RegionName" DataValueField="RegionID" SelectedValue='<%# Bind("RegionID") %>'>55 </asp:DropDownList>56 </EditItemTemplate>57 <ItemTemplate>58 <asp:Label ID="Label1" runat="server" Text='<%# Bind("SubRegionName") %>'></asp:Label>59 </ItemTemplate>60 </asp:TemplateField>61 <asp:BoundField DataField="RegionName" HeaderText="RegionName" SortExpression="RegionName" />62 <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />63 </Columns>64 </asp:GridView>

Thanks in advance.

Shaun

You need to set DataKeyNames="yourprimarykey"