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

Datareport not showing in v.b 6.0

P: 31
Dear all ,
I,m working with small invoice project and i need the report for 1.Purchase Order
2.SalesInvoice 3.Total stock, so created 3 dataenvironment and 3 DataReports and i created the connection for dataenvironment and declared the DataReport's Datasource as Dataenvironment and Datamember as Command1 when i run this report it showed me error msg "Report width is Larger than the paper width" but when i created a sepereted Dataproject it running fine

what is the mistake i did and what should i do now and how to create a report for particular ItemNo(in a textbox if type the particulat numbet that corresponding report only wold genarated)
plz help me to solve this issue
Apr 16 '08 #1
Share this Question
Share on Google+
2 Replies


debasisdas
Expert 5K+
P: 8,127
You simply nee dto re-size the report to fit into your default printer settings.
Apr 16 '08 #2

P: 31
Hi Debi Thank your kind reply and tell me the solution for the below issue

tell me how to get a record for particular field, in my sql i,v Pinvoice table following fields

InvNo int ItemNo int Descrption varchar(20) Price float Qty Gross float
1001 090 Fan 30 5 150
1001 080 Table 45 2 90
1002 012 Chair 90 3 270
1002 001 ToolBox 120 1 120

now t want to see the particular invNo details in datagrid when i type the particular invNo(for example InvNo =1001) in a textbox so what should i do to get the result.
i tried this ways but no result it showed me the error

1. in a Adodc control Recordsource command type AdcmdText i added the following code select ItemNo,Descrp,Rate,Qty,Gross from Pinvoice where InvNo=&

it showed me error msg Incorrect syntex near&" as well page loading & close

so i tried to give the datasource at run time, in a button click event i added this query

sqlstring
sqlstring = "select ItemNo,Descrp,Rate,Qty,Gross from Pinvoice where InvNo=& txtTest.Text"
Adodc1.RecordSource = sqlstring

it also showed me error msg

1. "Microsoft[ODBC Driver manager]datasource name not found" so i droped it.
2."Incorrect syntex near&"
3.Method 'Refresh' of object 1Adodc failed"

plz help me to solve this problem
Apr 16 '08 #3

Post your reply

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