Data Report Designer
HelloI am using Data Report Designer and my data source is a View Query from an Access database. The Query requires a run time parameter to get the appropriate results. How do I make the data resport accept a user parameter at runtime.Please somebody help me.Thanks
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Adding Labels To A Report At Runtime (using Microsoft Data Report Designer 6.0)
Hi,
I have just tarted using the Microsoft Data Report Designer and I need a little help. I am trying to get it to add labels to a report at run-time rather than design time.
The report is supposed to save the results of some analysis. Lets for simplicitry sake say that I just want to display a list of value stored in an array, but the number of placs in the array is not known until the proram has actually run. I.e. it would e something like this:
for i = 0 to ubound(myArray)-1
myReport.addItem (newLabel(i))
newLabel(i).caption = myarray(i)
next i
Does this make sense, but how would I do this (there is no 'addItem' property of the report)?
Multiple Data Report Title In Data Report Designer....?
hello there, I'm working on a project that is using the Data Environment and the Data Report Designer to create reports. I've stumbled my way through setting up some reports but I'm having trouble with report title.
How can I make 2 report title in the insert control in vb? Is there any other way I can make another one report title in the insert control......?
Ms Data Report Designer--Error Method Or Data Member Not Found
Hie Guys
I am having some problems with my application. Firstly, I wrote it and used the Data Report Desiger and used the Orientation method to show my reports in Landscape type.
Like DataReport1.Orientation=rptOrientLandScape
Now i am having this error "Method or Data Meber not Found"
Help me so that i can use this method.
Smith.
Add The Record No To The Report Using Data Report Designer
i want to display the No of the record being typed in the report , am using Report Designer. this may be done by creating the Record No field in the Query, i need the SQL code to do this, also by assigning a caption to a report label as the report is running but i dont know the event tnat must be used
Data Report Designer
Hi All,
I have used the Data Report Designer in conjunction with the Data Environment Designer to prepare output to the screen and printer. Since the Data Report Designer does not permit the use of objects from the General Tool Box, how can I get back to my Main screen?
Your help would be appreciated.
Gorps
Data Report Designer
Simple question for you gurus.
I'm using data report designer to create a report which works fine - except - that the "header" information (title and page number) will only print on the first page. I did nothing special. I just entered the title information in the header section of the report designer and inserted the code for page number. Only page 1 shows the header and page number.
Data Report Designer
I created several reports using data report designer. They have to go to two default printers. Also, after printing job is done, the programm suppose to display confirmation message.
Do I have to use SentPrinter API or there are other ways?
And also, how can I catch the event when the printing job is done?
Sincerely,
vertinski
Data Report Designer
Hello all
In trying to use the Data Report Designer which comes with vb. All i want to do is select part of a query at run time and put it onto a report. However it will not allow me to put variables in the select statement of the command.
Does anyone have any ideas?
Thanks in advance
papa laz
Data Report Designer
I want to add a Data Report to my project. I have added the reference to my project but when I go to add the component and click on the Designers tab the Data Report is not listed. I need some insight please!
I would appreciate any help!
Data Report Designer
Hi All,
Since the Data report designer has it's own set of controls, (label, shape, image, textbox and line control) and Visual Basic intrinsic controls are not available, how do I create an event on the data report which will allow me to hide the report when no longer needed and open my "main" screen ? I would like to be able to click a control such as a Command Button (which is not available on the data report) in order to generate code to get back to my "Main" screen interface.
I know this might sound sound simplistic but I'm very newbie!!
gorps
Data Report Designer
I have developed a program using the Data Report Designer in conjunction with the Data Environment Designer. Since I have the professional version of vb 6.0 I do not have Crystal Reports available. The Data Report Designer, although cumbersome has worked out fine.
My problem is that I want to create several printouts that all have identical information but in different orders. Is there some way that the SQL statement can be modified without going through a scomplete setup for each printout
Thanks,
gorps
The Data Report Designer
Does anyone out there know how (if it is posible) to get around the "Paper width" limitation of the DR? Where you can only have a report with a width of one standard sheet of printer paper. It is annoy when you want to have a rather large Data Report.
Data Report Designer
I would like to know how to do crosstab reports using DataReport designer for Vb 6.0.
Thanks u guys.
Bro Samuel
Using Data Report Designer
Hi, I have a data report designer and data environments. They work fine with the two existing separate tables, but what I want to know is how do you produce a report based on a runtime-generated SQL string?
In other words, how do you pass the SQL string (these work OK, I've tested them!) to the report designer so that you get a report consisting of (say) secretaries, and nothing else?
Using Data Report Designer (VB6)
Can anyone tell me why, when I distribute my app and people execute the reports within, they get the report but it is blank.
When I run it in the IDE, and compiled for that matter, it's fine.
Clearly, something is missing when I deploy the app but I can't think what.
Mega.
Data Report Designer Help
I am new to the data report designer.
Do I have to specify a connection manually (in code)
Or can I add a data control to the page?
If anyone knows of a page with help on this I would also
appreciate a link!
Thanks in advance.
MCM
Data Report Designer
i have a connection in my data environment wherein the connection string varies, in a sense that the location of the database changes. i have one command in which i used the grouping tool of the data report. it has a hierarchy info SHAPE {SELECT * FROM table1 ORDER BY Code} as cmdEmp COMPUTE CmdEmp BY 'EMPLOYEENO'. i wanted to set the connection string of the connection during run time and also set the recordset of the command at run time too. thanks.
Data Report Designer
I am using the data report designer and the Data environment for the first time and was windering if I could acquire some help.
How do I tell the data environment that I want it to ptint a report based on a recordset pulled back by a form.
(e.g. A user specifies the record number they want, I then set up a SQL statement to pull back the record/records). How can I then tell the data report to use the returned recordset for the basis of its report?
Please do not point me to Crystal reports. I would rather use VB's own in-built tools.
Mega.
Data Report Designer
Im using VB6. I use the data designer to print my
reports and is bound to a data class.
My problem is that I cannot setup the default printer
setting e.g. (LANDSCAPE or PORTRAIT) at runtime....
pls. need help...tnx
VB6 Data Report Designer - Please Help!
Greetings.
I am trying to create a simple report using VB6 data report designer. I need
to have some pagebreak when department is different. However I am getting
"Report sections do not match data source" message everytime i run this
report.
Appreciate if someone can share their experience in this matter.
Data environment1
Connections
Connection1
Commands
Command1 Group using Command1_Grouping
Summary Field in Command1_Grouping
Department
Details field in Command1
Name
Position
It is ok if I define all fields in the detail section. However if i insert
a group header and define department field inside this header i get the
error message "Report sections do not match data source"
TIA
CT
Data Report Designer
Hi all,
I'm new to the data report designer and have probably a pretty easy question
for you all to answer.
I have a report that will never be more than one page long but I want it to
fill the page. It shrinks itself based on the amount of items that are
listed. I want my total column at the bottom of the page with some other
stuff and everything else in the middle. I have the report working but just
can't seem to stretch it to fit the page.
I tried to put a reporttextbox in the report footer but it won't let me. If
I could do that all would be taken care of. Please help thank you, I know I
should be using Crystal reports, but I can't afford it.
Joe
Data Report Designer
Is there any way to have a property of an unbound label in the report header
change at runtime? i.e. Have the current user ID displayed or the date
range for the report displayed? Any help would be appreciated. Thanks.
Dominic Wray
VB Data Report Designer
Hi, I am I a new programmer. I have created a report using vb data report designer and Oracle data base. The thing, which is not working, is report function (SUM or AVG) . Table is using varchar2 as datatype.
I get an error message-,“Data type mismatch”.
-Re created a view using SQL to_number function to convert the data type still same error message.
-Data format property of the function is changed to number –still does not work.
When I created similar table with number field instead of varchar2. Above function works fine.
The problem with me is that I have to use varchar2 as datatype in my table and create the report.
I am stuck here….and your help will be appreciated.
Thanks
Need Immediate Help On The The Data Report Designer
Hello Everybody,
I am using data environment and data report designer to access the data in my VB application and to generate reports. There are some fields in the report that has Cangrow property set to "true" as well as their Multiline property is "on" in the form. The reason to do this is so that they can have more than one line of text in those textboxes and also they can grow in the size.
The problem I am having is that when I print this report, it cocatenates the fields after the multiline fields. It aligns the label and the text box but it does not leave any space between two labels.
eg.
Affected Cases: fhghshgjaskjtfjs;rjf;fje;jklak lkldrugjgjdjgjldjlj ddhdghdgdghdgghgjhdhgj
djxlftgjdxjxjgdxjcktgjedjrljtljejtkjs
Description: utdfgxydurtflifxs;oese;od udxirutsieidotigrdtioeixsiwei6tioetdir6ieieipipo4swooderop5oepro6oesoow[seo[
Unit Inavolved: lan
Time spent: Minutes
It should be ,
Unit Inavolved: lan
'space
Time spent: Minutes
'space
So, basically there is spacing problem after those two multiline textboxes.
Using MS Data Report Designer
Hi everybody,
I have been using VB since over a year now. I have come across a typical problem while using MS Data Report Designer. I want to create reports which are wider than 10 inches i.e. they should fit on 132 column dot-matrix printers. But I was unable to find a way to do that. If I design the report that is wider than 10 inches then at runtime it gives me msg that the report is too wide. I could not also figure out how to set it to print in landscape mode. pls help me, its top urgent to meet my deadline.
Girish Chandra
Data Report Designer
How can I make a monthly report using Data Report Designer?
Pls give some code samples. Thank you.
"JayCee"
Data Reporting + Sources (Data Report Designer)
Hi
I have three tables, tblStudent, tblTeacher, tblSSD. tblSSD is where everything is linked (so once incident in the tblSSD can have 1 teacher and one student; one teacher many SSD, one student many SSD).
now I want to have a report where select some fields from SSD, and using the appropriate IDs, some fields from teacher and student.
i want to order by year.
so in the report you would have
Code:
date (from SSD table) in the page header
year X
student ----- details
student ------ details
year total no events ...
year X+1
student ------ details
year total no events....
year N
student ------ details
year total no events
i am not sure how to set this up in the data environment designer... if i try and make a straight query with all the data then try and make groupings, it doesnt work; should i do Year > Student ? [remember, I still need some data from SSD]..
cheers!
How To Generate Data Report Without Using Data Environment Designer
Is there any way to generate Data report without using Data Environment Designer from VB Codes. The report must contain Records from more than 2 tables. Say for Example : SalesMaster & Sales Detail table. Again SalesMaster table must have some relationship with the Customer table. Where CustomerID is the link between the SalesMaster & Customer table.
Thanks in advance
Data Report Designer And Dbase
Well,
Here I go again. Once again my stubborn refusal to abandon dbase tables is getting me into trouble. As we all know how crappy the print capabilities of VB are intrinsically, I thought it would be really nice if I could use the built in data report designer to create a nice little summary report at the end of my app. The problem is, the source tables for the report are dbase, and I need to be able to modify the source in code, such as sort order, and what does, and does not, show up on the report. I found some very nice samples that show you how to pass a recordset object to the report as the data source, but when I try to do this with a dbase table, although I can debug.print the information in the fields, I get an error message that says invalid data source when I try to assign the recordset to the report. Is crystal reports the answer to my prayers, and if so, can anyone point me to a tutorial, or should I just give up and make a low quality text-based report. Thanks!
Here is a code sample:
Dim cnn As New ADODB.Connection
Dim rsReport As ADODB.Recordset
Dim i As Integer
Dim tempString As String
Dim rsHist As ADODB.Recordset 'create a connection
Set cnn = New ADODB.Connection
cnn.Open "Provider=MSDASQL.1;Persist Security Info=false;Data Source=dBASE Files" 'create a recordset
Set rsHist = New ADODB.Recordset 'define recordset parameters
rsHist.CursorType = adOpenKeyset
rsHist.LockType = adLockOptimistic
'open the recordset
'pending: trap for error here if ClaimsDirect is already running
rsHist.Open "C:SAErrors.dbf", cnn, , , adCmdTable
Debug.Print rsHist![CHARTNO]
Set rptSummary.DataSource = rsReport
rptSummary.Show 1
cnn.Close
[You can take my dbase tables away from me when you pry them from my cold dead fingers!]
Data Report Designer Question
I have a access database that contains name, address, bill number, date, amount due, etc... I currently have a form that asks the user to enter in a name for the program to search out in the database and report on. I currently print this out to a regular text file. How can I get the data report designer to do this. I currently can print out a report using the designer, but I can not get it to do a specific search on the name and just pull that specific name. Can anyone please give me an idea on how to get this accomplished? Thank You...
Generating Report By Using Data Designer
Hi every one,
I am new to vb and I need some help.
I am using vb6. I am generating a report in the following format by using data report:
Subject: Maths
Teacher: A
Student: A Pass
Student : B Pass
Student: C Pass
Subject: English
Teacher: B
Student: A Pass
Student : B Pass
Student: C Pass
Subject: Maths
Teacher: C
Student: A Pass
Student : B Pass
Student: C Pass
While I actually need to generate report in the following format:
Teacher: A
Student Name Maths English Science
Student: A Pass Pass Fail
Student : B Pass Fail Pass
Student: C Pass Pass Pass
Teacher: B
Student Name Maths English Science
Student: D Pass Pass Fail
Student: E Pass Fail Pass
Student:F Pass Pass Pass
Teacher: C
Student Name Maths English Science
Student: G Pass Pass Fail
Student : H Pass Fail Pass
Student: I Pass Pass Pass
I guess that to generate report inthis format I need to creat record set and then generate report but I have no Idea how to do that.
Please give some example code.
The data I am getting after executing storeprocedure is like that:
Student A Teacher A Maths Pass
Student A Teacher A English Pass
Student A Teacher A Science Pass
Student B Teacher A Maths Pass
Student B Teacher A English Pass
Student B Teacher A Science Pass
Student C Teacher A Maths Pass
Student C Teacher A English Pass
Student C Teacher A Science Pass
Student D Teacher B Maths Pass
Student D Teacher B English Pass
Student D Teacher B Science Pass
Student E Teacher B Maths Pass
Student E Teacher B English Pass
Student E Teacher B Science Pass
Student F Teacher B Maths Pass
Student F Teacher B English Pass
Student F Teacher B Science Pass
Student G Teacher C Maths Pass
Student G Teacher C English Pass
Student G Teacher C Science Pass
Student H Teacher C Maths Pass
Student H Teacher C English Pass
Student H Teacher C Science Pass
Student I Teacher C Maths Pass
Student I Teacher C English Pass
Student I Teacher C Science Pass
I will reall appereciate if some one could help me.
Cheers
Questions About Data Report Designer
Hi,
Just started using data report designer, got a few questions:
1, How do you delete the footers from the default report?
When you first load up a data report it comes with 2 footers (1 page footer and 1 report footer) I dont want these, but when I right-click on them and try to delete them, it asks me if I am sure I want to delete both the headers and the footer? (I want to keep the footers)
I had some other questions, but as often happens, putting my questions down in writing has actually caused me to realise the answers. So its just the one question for now.
Data Report Designer Problem
I'm having a strange problem using the Data Report Designer. I'm trying to use it to print out a standard form. The detail section is very small (Only 11 items) but there is alot of text that needs to go in the header and footer sections. The problem is in the design mode. If the header sections (report header or page header, I've tried using both) get too big, you can't scroll down to work in the details or footer sections. I've also tried putting everything in the details section but you can only make that so big before the scroll bar stops working.
Has anyone else seen a problem like this? Am I using the data report designer wrong?
Is There Anyother Data Report Designer ?
In VB6 and later we have datareport designer. But with this new addin, VB6 still lack of dealing with complicated functions with the records that we retieved from the database.
I really would like to know if is there anywhere in the world of software having a kind of datareport designer that is best for all kind of functions.
Microsoft Data Report Designer
Hi all.
In my app, I'm gonna need to generate some reports. I've never used the Microsoft Data Report Designer, and I'm looking for some feedback, hints, suggestions, etc. from those of you who may have.
TIA.
Data Report Designer Question
Hi,
Can the VB6 Data Report Designer run if it has no data source?
What I'm trying to do is to display and then print a report with values that were entered and or calculated that are held in some text boxes on my main form.
In the main form module this doesn't seem to work:
rptMyReport.text1.text = txtName.text
I get an object or method not defined error.
Nor this in the Data Report Initialize event:
text1.text = frmMain.txtName.text
I get an object required error.
I imagine I can write the data to a text file, but can the Data Report Designer use a text file as a data source? Hell, can the Crystal Report Component? If they can I'm having trouble figuring how to connect them.
Thanks in advance for any help.
Regards,
Jack Vinitsky
Data Environment/report Designer
I=92m looking for some help with designing my data environment to allow
multiple levels of grouping with the data report in visual basic. I am
using the Data Environment designer in Visual Basic. I had gotten a
suggestion to use the Parent/Child features in the Data Environment, and
it seems to be getting me in the right direction, but I keep getting
records over and over=85 here is the hierarchy that my program needs to
display on several reports:
Contractor
----- Landowner
---------- Receiving Site (Mill)
--------------- Record displayed here
---------- Totals for Mill (within Landowner and Contractor)
----- Totals for Landowner (within Contractor)
Totals for Contractor
Any help would be greatly appreciated!
Thank You,
Jeremy Clay
IT Manager
Gardner Companies
207-794-2303
207-290-1492 cell
207-794-3202 home
Problem With Data Report Designer
Hi everyone,
Has anyone had this problem with vb's Data Report Designer.
I am trying to load an image using the designers rptImage control at run time
The normal syntax of Image1.picture = LoadPicture="image.bmp" reports
that the control does not support this property. Is this correct or is there
another way of loading an imge to this control.
Clive...............
VB Data Report Designer Problems
I'm trying to generate a report in Visual Basic Using the Data Report Designer. When I run the report I keep getting this error "Data field "(Empty)"not found". Does anybody know what the problem could be? Thanks in Advance.
Calculation, And Data Report Designer
Hello all
Is it possible to calculate two
fields shown on the detail secion
of a data report desinger.
the sum als must be on the detail section
the values are coming from a data base.
thanks in advance
Add Autonumber To Data Report Designer
Hi, I have trouble to add autonumber field in recordset selection from one table for set to datasource report designer in VB6.
Please help... Thank You.
Satrio.
[NOT RESOLVED]Never Used A Data Report Designer I Need Help
Guys,
I have never used a data Report Designer in vb6
I have a recordset full of the data .
I now need to put this data in the designer.
Can somebody give me an example or point to article?
thanks a lot
Edited by - dotnetsql on 1/14/2005 8:48:40 AM
Data Report Designer Image
Hello,
I have an image control on a report. It is in a grouping. I have the filename of a picture in a datafield in the recordset that is being used on the data report.
When running the report, I would like the image control that is in the grouping to be loaded with the picture that is in the picture datafield located in that grouping. This way, each record that is displayed on the report will have a little picture of the item, that record/grouping is describing.
I have no problem loading an image into an image control in code. The problem is for every record displayed, the same pic is showed, not the pic that is saved in that records picture datafield.
Thanks ahead for any help.
Aaron
Eporting To Excel Using Data Report Designer
I am using vb6.0 and am writing a Data Project. Using MS Data Report Designer for the reports.
The default Report export formats are txt and html. I was wondering if sumone can help me with how i can enable export to excel and/or pdf formats too in addition to html and txt.
thanks in advance!
Data Report Designer Print Issue
I have created a using the Data Report designer. I use Courier font in the detail/body section, but Arial in the headers/footers.
On certain printers, the print preview looks great, but when it prints on paper (by clicking the printer icon from the designer preview window) the Courier font is really small. The Arial prints out fine.
Has anyone ever seen this? If so, is there a work around? I'm not sure if the problem is in the Data Report Designer or a printer issue. There are only a handful of complaints we have gotten, so most of the time it works fine. I just don't know if there's anything else I can do at this point.
Thanks!
Kamie
|
TRACKER
