Hello all,

I know I must be doing something stupid here but it's driving me crazy.  I'm trying to create a report through an asp page querying an access database which is fine until I have tried to create some grouping - listing the group name only once on the report. 

I'm trying to use the line <% if  objrs(i) <> grouping then %> to detect if the grouping name needs to be input into the report or not however this is always returning true and the next bit of code is always being executed...

 any help is much  appreciated. 

The full code is: -

<%

dim grouping

grouping = "first"

while not objrs.eof

%>

   <TR>

<% For i = 0 to objrs.fields.count - 1%>

<% Select Case i %>

                 <% Case "0" %>

                                  <% if  objrs(i) <> grouping then %>

                                                   <TD VALIGN=TOP><B><% = objrs(i) %></B></TD>

                                                    <% grouping = objrs.fields("Location").value %>

                                                    </tr>

                                                    <tr>

                                  <% End if %>

                 <% Case "1" %>

                                  <TD VALIGN=TOP ALIGN=LEFT><% = objrs(i) %></TD>

                                  <td></td>

                 <% Case "2" %>

I don't know if this is related or not, but shouldn't the case statement not contain quotes?  If you are trying to compare integers, then it should be: <% Case 1 %>.

As far as the other problem, what kind of record is being returned with objrs?  i.e. show me the list of what one record being returned contains (id,name,date,etc.), and in what order they are being returned from the database.

Thanks for the reply

the fields and field values being returned in this order: -

fields

Location,ID,Title,InsuranceValue,PurcahsePrice

Values sample

Room 9,1,happy valley,3500,3500

Room10,2,rounding the copelands,300,200

probably should of included the SQL statement I was using: -

strSQL="SELECT Asset_Register_Heritage.Location,Asset_Register_Heritage.ID, Asset_Register_Heritage.Title,Asset_Register_Heritage.Insura nce,Asset_Register_Heritage.purchaseprice FROM Asset_Register_Heritage ORDER BY Asset_Register_Heritage.Location,Asset_Register_Heritage.ID"

I have put into the code  the statement <%=grouping%> --- <%objrs(i)%> just after the case 0 to see what values are being fired out each time and the variables being stored are correct as in when I want the statement to be false I'm getting

Room 9 --- Room9

which should ignore the td line but its not...

likewise when it comes accross a new value in the table and I want this to be represented this statement does all the right things i.e.

Room 9 --- Room 10

It just doesn't seem to be working in the if statement

Sorry don't have time to fully help you, but some tips:

<% and %> are called ASP blocks, they slow the page loading time down.  In your code you have for example:

                                  <% End if %>

                 <% Case "1" %>

This can be changed to:

<%
  End if
  Case "1"
%>

Room 9 <> Room9

They are different strings... Try changing your compare to "Room 9"

Ok, let's try something else, do this and look at the output:

*<%=grouping%>* --- *<%objrs(i)%>*

I'm wondering if there are any extra spaces in your database object...  If not this should show up as *Room 9* --- *Room 9*.  If it shows up as *Room 9* --- *Room 9   * that is the problem.  I'll keep looking if you want to check that out.

Is this what you want your fields to look like?  If so your code works for me ...

Thanks for all your help aalavar.  Afraid I tried something similar with no luck:-

still getting the output in the following format