By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,968 Members | 1,178 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,968 IT Pros & Developers. It's quick & easy.

how to add two command in detail section of datareport

P: 1
my shabpe String is given below
but it is not working
Expand|Select|Wrap|Line Numbers
  1. sqlw = "SHAPE {SELECT * FROM labour_main}" _
  2.             & " AS RsMain APPEND ({SELECT * FROM labour_child1}" _
  3.             & " AS RsFamily RELATE reg_no TO reg_no) AS RsFamily," _
  4.             & "({SELECT * FROM labour_child2}  AS RsReg" _
  5.             & " RELATE reg_no TO reg_no) AS RsReg"
  6.  
  7. and code of report is
  8. Private Sub SetSection1()
  9.     Sections("Section1").Controls("TEXT2").DataMember = "RsFamily"
  10.     Sections("Section1").Controls("TEXT17").DataMember = "RsFamily"
  11.     Sections("Section1").Controls("TEXT18").DataMember = "RsFamily"
  12.  
  13.     Sections("Section1").Controls("text2").DataField = "relation"
  14.     Sections("Section1").Controls("text17").DataField = "name"
  15.     Sections("Section1").Controls("text18").DataField = "age"
  16.  
  17.  
  18.     Sections("Section1").Controls("TEXT19").DataMember = "RsReg"
  19.     Sections("Section1").Controls("TEXT20").DataMember = "RsReg"
  20.     Sections("Section1").Controls("TEXT21").DataMember = "RsReg"
  21.     Sections("Section1").Controls("TEXT22").DataMember = "RsReg"
  22.     Sections("Section1").Controls("TEXT3").DataMember = "RsReg"
  23.  
  24.  
  25.  
  26.     Sections("Section1").Controls("TEXT19").DataField = "reg_date"
  27.     Sections("Section1").Controls("TEXT20").DataField = "bank_cash"
  28.     Sections("Section1").Controls("TEXT3").DataField = "amount"
  29.     Sections("Section1").Controls("TEXT21").DataField = "bill_no"
  30.     Sections("Section1").Controls("TEXT22").DataField = "payment_mode"
  31. end sub
  32.  
  33.  
Jan 23 '12 #1
Share this Question
Share on Google+
1 Reply


100+
P: 759
I am not an expert, so I can't be sure, but... what is the SHAPE word in the SELECT clause of SQLW ?
Jan 24 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.