December 2, 2010 at 6:35 pm
Hi
I m designing a report
I have a member name field and in my query i used order by menber name.
now i need to show only first letter of a member name in a textbox sothat it should be displayed
ex:
A
Membername
AAA
AIII
B
Membername
BBBB
BDDD
Thanks
December 6, 2010 at 10:40 am
I would add a LEFT(Membername,1) to the dataset query, and then use that to sort and group your report.
December 6, 2010 at 2:55 pm
Hey
Thank you somuch its working but.I want this first letter should be displayed in my report for all
I need something like this
X
Member Name M/F DOB Age Effective
XIAO, STEVEN M 7/7/2008 10 1/1/1901
XIE, JEREMYEN J M 5/23/2001 8 1/1/1901
XIAO, FIO T M 12/28/2003 4 12/28/2005
Y
Member Name M/F DOB Age Effective
YIPMIN, CLAUDIA L F 31 /6/1974 36 4/2/2009
YIPKL, GARY L M 18/10/1958 52 4/2/2009
YAMAK, CLINT M F 12/8/1972 33 4/2/2009
Now i m using template for my reports and i am trying to write fields!Sort.Value in one textbox just above the column names row
Sort here is LEFT(MemberName,1) in my select statement in dataset query as u said. but i m only getting first A letter at the start but i want it for all others?
Plz suggest me
December 6, 2010 at 8:58 pm
Hi,
You can use a List and then keep the text box in side that List and use the above expression.
Thanks & Regards,
MC
December 7, 2010 at 7:17 am
You should use the field I suggested you create above as a grouping field, and then put the field in the group.
December 8, 2010 at 4:05 pm
Hi
thanks for your help.with list i m getting all the letter on the single page
Daniel Bowlin
I can able to do with your suggestion.
One concern is that
Now I can see this letter displayed above the details group and below the headers
Coz my report template is something like this
_________________________________________________
Member Name M/F DOB Age Effective
________________________________________________________header
<<EXP>> my expression is coming here
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Member Name M/F DOB Age Effective details row group
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Can I get something like this
X
Member Name M/F DOB Age Effective
XIAO, STEVEN M 7/7/2008 10 1/1/1901
December 9, 2010 at 6:26 am
Hi,
Can you try with a page break for the List?
Thanks & Regards,
MC
December 9, 2010 at 8:54 am
ry.sqldev (12/8/2010)
Hithanks for your help.with list i m getting all the letter on the single page
Daniel Bowlin
I can able to do with your suggestion.
One concern is that
Now I can see this letter displayed above the details group and below the headers
Coz my report template is something like this
_________________________________________________
Member Name M/F DOB Age Effective
________________________________________________________header
<<EXP>> my expression is coming here
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Member Name M/F DOB Age Effective details row group
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
Can I get something like this
X
Member Name M/F DOB Age Effective
XIAO, STEVEN M 7/7/2008 10 1/1/1901
This looks like you have your groups out of order. The outermost/uppermost group should be the one with the column that has just the letter.
December 10, 2010 at 6:03 pm
Hi
Yes, in my template the first row is header where i am getting the column names and down that detailed row
that is nothing but tables details group.so,when i try to add the new row with in group i m just getting it in between.i dont know how can i avoid this.
December 10, 2010 at 7:10 pm
Hey
Got it guys.thank you somuch for your help.
Thanks
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply