Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
 
  HOME    TRACKER    Visual Basic




Data Report Export Command


I was just wondering if I could remove the export command on a data report? I have been searching it but haven't found anything that will really help.




View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Passing A Command To A Blank Command In A Data Enviroment For A Data Report
Howdy All

I have a problem. I have a data report that displays all fields from a table. But each year a new table is created. So this data report can only show the new year fields. Not the previous. (EX. two tables in the database table 2004(called Tab2004) and a newly created table just called Tab) Now the data enviroment comand 'select * from Tab' so each year as a new table is created the report can only print out the new table. But my problem is I want the data report to be able to print the previous years when selected and adapt for each new year added.

I know the command won't accept a param for the table. So I tried inserting the SQL from the form but to no avail.

Basically what i want is this SQL in my command

'SELECT * From (whatever table choosen)'

and insert it during runtime into the data enviroments command

I tried this

Dataenviroment1.Commands("Command1").CommandText="'SELECT * From '" & strTable & "' ORDER BY field_Name"

But all I get is a rowset error
 failure to recieve rowset I beileve.

Can anybody help

Thanx in advance

Export To Data Report
I need help attached file for your reference.

Question:

The report in the individual item for the long description line cannot form the second item in line.
For eg. Item 1 with the long description will jump down to second line, then for item 2 the description line should be printed on line 3, but some description line printed on line 2, it mess up the item 1.

Data Report Export
Hi
I am using a dataReport with DataEnvironment, I need to Export My DataReport to an EXCEL File, How can I do it?

Thank you for your concern
Roger

Export In Data Report
Hi Gurus!

I made a report using Data Report.
This report includes 8 images on RptImage controls.
There's no text in this report.
But in case export as html, there's no images in that exported html file.
Why does this happens?
Could anybody help me figuring out this problem?

Export Data Report In VB6
When I try to export a data report in VB6 I got "Report width is larger than the paper width".

Please help.

Thanks.

Export Data Report To File
I am trying to export a data report to file. It is easy enough to use the Data Report component of VB, but it does not support graphics. I am going to try and use crystal reports, but I cannot install the component correctly. I added by going to Project->Components->Crystal Report Controls

But if I go to Project->References there is no reference to Crystal Reports. What am I doing wrong?? How do I correctly set up Crystal reports?

Thanks,

Brandon

Export Report Data Into Word Doc
How can I export the Report Data which are viewing in report view into Word doc

Thanx in advance

How To Export A Data Report To Excel?
how can i export a data report to excel? can anybody help me....?

Export Button On Data Report
Does anyone know a simple way to disable the export button on the data report? I'd like to allow users to print out the data but not to export it to a file.

Export A Data Report As A Word Document
Hi,

Can any one tell me how I can export a data report as a Word document?

Thanks.


WY

Rid Data Report Preview Of Export Icon
How do I remove the export icon when you view the data report. I only want to be able to view or print the report. Help new to VB and new member here.

Disable Export Button On Data Report
Does anyone know a simple way to disable the export button on the data report? I'd like to allow users to print out the data but not to export it to a file.

How To Export Data Report In Excel Sheet
Hi,


I am using datareports to generate the reports in VB. I want to transfer datareports to excel sheet. Please let me know the code to transfer datareports in excel sheet.


thanks

Export Data From Crystal REport Viewer
hi friends,
i have used crystal report 8 , display records from my db. I have make Property Code:EnableExportButton=True of Crystalviewer. But when i click on export button and want to store all records in text or rtf file it doesn't store any data init.
so where m wrong , pls help me

How To Export Data To Excel From Cryastal Report
Hi all,

I want to export the data from crystal report to excel.
so i want to give one button , instead of using export
functionality in crystal report....
the same functionality i want to use ....just user clicks
on that..it has to store in the excel file in a specified formate...
let me know the code ....vb code

Thanks

Export Data In Listview To Crystal Report
I have a listview with data pulled from my MySQL database.
NOw I would like to print out the data in the listview. Note that my intention is just to print it.

I planned on using crystal report to print, to be more specific, i am thinking of first exporting the data to crystal report then call the print function to pribnt it. But how do I start? Do I even need crystal report in thye first place, because I just want the printing functuion?

How To Export Data From Crystal Report To Exel
Hi all,

I want to export the data from crystal report to excel.
so i want to give one button , instead of using export
functionality in crystal report....
the same functionality i want to use ....just user clicks
on that..it has to store in the excel file in a specified formate...
let me know the code ....vb code

Thanks

Export Landscape Data Report To Text File
I can display and print a data report in landscape mode, but cannot get the report written to a text file without receiving the dreaded "Report Width is Larger than the Paper Width" error.
I've tried: filename1.ExportReport rptKeyText, with and without setting the paper orientation to landscape for the printer, but I still get the above error message. Any other suggestions?

Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,

Data Report Problem (export Format Messed Up)
Hello all,
I needs some help here before I pull out all of my hair. I wrote a program in vb6, that use an access db and data reports. The problem is that when I view my reports in the preview, everything is perfect, all formatting is where it should be, but when I export the file (txt or html, tried both) and save it to my computer and open it again, some the formatting is out of wack. Some parts skip over a few spots and some print on the line beneath it. Why is this doing this?
Help anyone.
Thanks,
creggio

Disable Print And Export Controls In Data Report
Hi,

Could you please advise how to disable the print button and export button in data report in VB6? Is it possible to do so?

Many thanks!!

Lavenus

How To Know The User Selection Export File Format Based On Microsoft Data Report
Hi all,

i am using microsoft data report in VB 6 , how to i get the user selection file format (open the export file dialog box) he or she wish to export the file for example to EXCEL. or is any window API to detect the file selection from the file dialog box.

after when the user select *.xls for export i wish to do other application processing , therefore is there any other to detect or know the file format selection from the file dialog box ?


Private Sub DataReport_Initialize()

rptDemo.ExportFormats.Add _
   Key:="ExcelReport", _
   FormatType:=rptFmtText, _
   FileFormatString:="Excel (*.xls)", _
   FileFilter:="*.xls"

End Sub

Private Sub DataReport_AsyncProgress(ByVal JobType As MSDataReportLib.AsyncTypeConstants, ByVal Cookie As Long, ByVal PageCompleted As Long, ByVal TotalPages As Long)

Dim iCount As Integer
Dim i As Integer

'iCount = rptDemo.ExportFormats.Count
'
'For i = 1 To iCount
' Debug.Print rptDemo.ExportFormats(i).FileFormatString
'Next

End Sub

 

Data Report Doesnt Print In Data Environment With A Child Command Attached
I am trying to print a report using a Data report linked to a Data Environment recordset.

If I run the command:


Code:Report1.PrintReport

when the recordset has a child command attached to it , I get an error.

If I go to the DE and dis-associate the child command with its parent the same command works. I conclude the child command is causing the problem.

Can anyone shed some light on this.


Mark

Failed To Export The Report, Error In MS Excel Export Format DLL
Hi,

I have a little problem with Crystal Reports (CR 8) :

I try to export one of my reports from a VB program. When I try to export it in "Comma Separated Values" format everything is ok (except this is not the format I need
). When I try to export it in excel format it works, on some PCs but not on others ?

VB code sample :

rpt.ExportOptions.FormatType = crEFTExcel80Tabular
rpt.ExportOptions.DestinationType = crEDTDiskFile
rpt.ExportOptions.UseReportDateFormat = True
rpt.ExportOptions.UseReportNumberFormat = True
rpt.ExportOptions.DiskFileName = txtExportDirectory.Text & ExportName
rpt.Export False

I tried all the excel formats (crEFTExcel50, crEFTExcel50Tabular, crEFTExcel70 ...) but on some PC's I always get the "Exporting Records" window for a second and then the error "Failed to export the report, Error in MS Excel Export Format DLL".

Can anyone help me out ?
Thanks !

Data Report Command Grouping
i have a SQL Command1 grouped using COMMAND2
how do i write the sql command to sort the records from command1
DataEnvironment2.Commands("command1").CommandText = "select uhr,bemerkungen,datum,typ from termine where datum=datevalue('" & Form2.MonthView1.Value & "') "
when i use this command i get an error


help help
thanks a lot
sipi

Data Report Using Shape Command Without DE
I have to make a datareport without data environment. My query contains shape commands. I m writing down the code i m writing.


--------------------------------------------------------------------------------
Db.ConnectionString = "Provider=MSDataShape;Data Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & App.Path & "abc.mdb"
Db.Open

Sql = "SHAPE {SELECT Order_Date,product,Count(product) FROM Order_Detail Group By Product,Order_Date Order By 2 Desc} AS Command1 COMPUTE Command1 BY 'Order_date'"

Rs.Open Sql, Db, adOpenKeyset, adLockOptimistic
With DataReport1
.Hide
Set .DataSource = Rs
.DataMember = Command1
With .Sections("Section6").Controls 'Here Section6 is group header
For intCtrl = 1 To .Count
If TypeOf .Item(intCtrl) Is RptTextBox Then
.Item(intCtrl).DataMember = "Command1"
.Item(intCtrl).DataField = "Order_date"
End If
Next intCtrl
End With
With .Sections("Section1").Controls
For intCtrl = 1 To .Count
If TypeOf .Item(intCtrl) Is RptTextBox Then
.Item(intCtrl).DataMember = "Command1"
.Item(intCtrl).DataField = rs(z).Name
z = z + 1
End If
Next intCtrl
End With
.Refresh
.Show
End With
----------------------------------------------------------------------------------
I have done using data environment but i want to make datareport without using de.
Can anyone help me.....

Data Report Using Child Command
Hi Friends,
I am generating one report in which i want to display all the data for a particular ID.
e.g. I am taking invoice no as parameter and fetching data from invoice_main (exporter,consignee,invoice date etc.) and i want to display the data corresponding to this invoice no from different table invoice_data(quantity,rate,amount,total amount).
I am using two child command,but getting an error message
"CANNOT DO RELATE,COMPUTE BY OR SORT OPERATIONS ON COLUMNS WHOSE KEYLEMGTH IS UNKNOWN OR MORE THAN 10K"

Its urgent and please,help me out.

Regards
Atul

Data Report And Connection Command 1 And 2
Hi,

I need to add a 2nd command to my Data environment1 Connection1

example:

In my DataEnvirinment1 Connection1 Command 1: I have a SQL Statement

select * from CUSTRECS where ORDERNUM = ? and prod = ?

I'm passing 2 parameters and everythings is OK, now I need to add another command passing only one parameter (ORDERNUM) .

What I did is: Under the same connection1, I added a command2 with a SQl statement

select * from CUSTRECS where ORDERNUM = ? order by date


When I run it It gives me all kind of error,
MDI form not available or Data member not found

This is my code

Private Sub CmdReport_Click()

Set DataReport1.DataSource = Nothing
        Set DataReport1.DataMember = DataEnvironment1.rsCommand2
        If DataEnvironment1.rsCommand2.State Then DataEnvironment1.rsCommand2.Close
               DataEnvironment1.rsCommand2 OrderNum
               Set DataReport1.DataSource = DataEnvironment1
               DataReport1.Show
         End If

End Sub

In the data report properties I tried MDI Child = True

Any ideas please?

Shape Command + Data Report
I want to attach datasource to data report at runtime. I achieved this much. But when i want to add group header, it gives me problem.. I want to group my report on some field..at run time..

For that i used Shape Command to generate Hierarchial recordset..

But is giving me problem : Report Section Don't match Data sourse

could you help me.......

thanks

Urgent: SQL Statment In A Data Report Command
hi all
I'am make a data environment(de) and connect it to my access db stu.mdb and i'am trying to view a data report(dr) to show a specific records according to the sql statment cammand i made comparing the log_date field (text field) but the report didnt show anything, please help me as soon as possible.

table:stu
st_no as text
pc_no as text
log_date as text
log_time as text

s_date = string
e_date = string

i use this in the sql statment :
select * from stu where log_date between s_date and e_date
"i write it in the sql sttment textbox in the command properties
is this statment syntax true or not and whats the correct way

any replay will be appreciated

Glory

Shape And Append Command Data Report
I am trying to fabricate a hierarchial recordset. I want to create two sibling recordsets below one parent. I do this all the time with regular queries but I can't figure out how to do it without a data provider. This is what I have so far:

strShape = _
"SHAPE APPEND NEW adChar(30) AS Foo, " & _
" ((SHAPE APPEND NEW adChar(30) AS Bar) RELATE Foo TO Bar) AS FooBar, " & _
" (( NEW adChar(30) AS FooFoo) RELATE Foo TO FooFoo) AS FooFooBar"

The syntax is correct up to As FooBar in the second line.

What I am after is this:

+Foo
+--FooBar
+--FooFooBar

NOT this:

+Foo
+-+FooBar
  +--FooFooBar

So could someone please give me a hint. I can't be that far off.

Thanks,

Shape And Append Command Data Report
I am trying to fabricate a hierarchial recordset. I want to create two sibling recordsets below one parent. I do this all the time with regular queries but I can't figure out how to do it without a data provider. This is what I have so far:

strShape = _
"SHAPE APPEND NEW adChar(30) AS Foo, " & _
" ((SHAPE APPEND NEW adChar(30) AS Bar) RELATE Foo TO Bar) AS FooBar, " & _
" (( NEW adChar(30) AS FooFoo) RELATE Foo TO FooFoo) AS FooFooBar"

The syntax is correct up to As FooBar in the second line.

What I am after is this:

+Foo
+--FooBar
+--FooFooBar

NOT this:

+Foo
+-+FooBar
  +--FooFooBar

So could someone please give me a hint. I can't be that far off.

Thanks,

Shape And Append Command Data Report
I am trying to fabricate a hierarchial recordset. I want to create two sibling recordsets below one parent. I do this all the time with regular queries but I can't figure out how to do it without a data provider. This is what I have so far:

strShape = _
"SHAPE APPEND NEW adChar(30) AS Foo, " & _
" ((SHAPE APPEND NEW adChar(30) AS Bar) RELATE Foo TO Bar) AS FooBar, " & _
" (( NEW adChar(30) AS FooFoo) RELATE Foo TO FooFoo) AS FooFooBar"

The syntax is correct up to As FooBar in the second line.

What I am after is this:

+Foo
+--FooBar
+--FooFooBar

NOT this:

+Foo
+-+FooBar
  +--FooFooBar

So could someone please give me a hint. I can't be that far off.

Thanks,

My Data Report Won't Display The Child Command.
Hi, I have a data environment and data report set up. Command1 takes info and displays from a table and then there is a child command that takes info from a second table, but it will not display it.

I looked at the table in access and the information is there. I have the relate to parent command checked. I have added the estimate number for the relation. What else could be causing this not to load? I tried to just place a label in the details section and it won't even display.

Any ideas as to what I am doing wrong. I am following Deke's FAQ and have displayed things in the details section before. I have had soo many bugs and changed soo much that I don't know if I have messed something up or not. Like I say Command1 is displaying fine.

Thanks

thanks
leadfinger
http://www3.nbnet.nb.ca/gspil

Shape And Append Command Data Report
I am trying to fabricate a hierarchial recordset. I want to create two sibling recordsets below one parent. I do this all the time with regular queries but I can't figure out how to do it without a data provider. This is what I have so far:

strShape = _
"SHAPE APPEND NEW adChar(30) AS Foo, " & _
" ((SHAPE APPEND NEW adChar(30) AS Bar) RELATE Foo TO Bar) AS FooBar, " & _
" (( NEW adChar(30) AS FooFoo) RELATE Foo TO FooFoo) AS FooFooBar"

The syntax is correct up to As FooBar in the second line.

What I am after is this:

+Foo
+--FooBar
+--FooFooBar

NOT this:

+Foo
+-+FooBar
  +--FooFooBar

So could someone please give me a hint. I can't be that far off.

Thanks,
Edit/Delete Message

Pass Parameter To Child Command In Data Report
hi, ....
i'm using DE connected to Access, and my DE is like this...
Company (Parent Command)
a
b
c
SQL(child command) <<== Problem ***
k
l
m
acccoutingng (child command)
x
y....

i used the SQL builder to setup the sql statement like this ...

"SELECT Brno, City, CNno, Tseqno, TDate, Payment, DOno FROM FECMS_Transaction WHERE (TDate = ?)"

, and went to setup parameter. Everything seems fine except the relation part. I need it to have a relation with the previous level (Company). when i assign the relation, an error message comes out said

"All required parameters must be linked with a parent field." I'm pretty sure linking the right fields between these 2 tables. If i didn't do this part, this level will becomes the same level like "Company".

can someone help me, million million thanks.....

Please Show Me How To Access A Child Command In A Data Report???
Please can someone show me how I can access the fields contained within a child command from the Data Report??

What started all this is that the two tables I have in my Access database are too large when I attempted to join the tables together into one query...so I created 2 seperate tables and was hoping to create a Hierarchical command in my DataEnvironment..I think I did that, but when I try to set fields within the Data Report to the child command fields, I can not see the child command fields!!!

I am in the dark here...does anyone have some light on this subject

Thanx

Unable Update Data In Report Even If Ado.command Has Executed A Different Query
My problem is i have function called preview report. When the user select a new contract and clicks on the button, the report should be updated with the new contract. But, it does not get updated with the new contract. It still shows
the old record.

I will show you my code and explain what i have done.

i am using crystal report 8.5 and VB 6.0

I am using

Function preview_Report()

Dim rsd As ADODB.Recordset
Dim rs_cmd As ADODB.Command
Dim query_temp As String
Dim test As String
Dim cp_no As Long
Dim dt As String

dt = ""
dt = built_date
'********************************************
'built_date Its a function to get the year and '
'month from the user and combined. Its a criteria that
'is used in the query
'*********************************************
cp_no = 0

cp_no = Combo1.Text
'**********************************************
'cp_no is the contract no that is selected by the user
'Used as a criteria in the query
'**********************************************

query_temp = ""
query_temp = " Select agency_name, agency_add, advertiser_name, advertiser_add, camp_no, "
query_temp = query_temp + " camp_origination_date, camp_pree_status, order_no, product_name, "
query_temp = query_temp + " camp_start_date, camp_end_date, spot_no, spot_duration, "
query_temp = query_temp + " spot_type, spot_air_date, brek_nom_time, prog_name, channel, "
query_temp = query_temp + " spot_code, spot_price, copy_code "
query_temp = query_temp + " From campaign_summary_direct Where camp_no = " & cp_no&
query_temp = query_temp + " And spot_air_date Like " + dt

'********************************
'query temp is the query that will be passed to
'Ado.command to be executed
'I have tested the query and i am very sure that
'its fine.
'***********************************


Set rs_cmd = New ADODB.Command
Set rsd = New ADODB.Recordset

on error goto x

'*************************************************
'on error go to x is need when the function is executed
'for the first time , because the rsd recordset is
'not opened,

'*************************************

rsd.close


x:

rsd.Open query_temp, cn_temp, adOpenForwardOnly, adLockReadOnly


Set rs_cmd.ActiveConnection = cn_temp
rs_cmd.CommandText = query_temp
rs_cmd.CommandType = adCmdText
Set rsd = rs_cmd.Execute(query_temp)

Bound_report
'*************************************
'Bound Report is a function set unbound fields. My report
' has unbound fields in it.
'I have checked and its Fine
'**************************************

Report1.Database.AddADOCommand cn_temp, rs_cmd
'cn_temp is the connections string defined and set
'during form load.


Form1.CRViewer1.ReportSource = Report1
Report1.ReadRecords
Report1.DiscardSavedData
Form1.CRViewer1.ViewReport
Form1.Show

End Function


Further explanation

I am very sure that the query is executed with different criteria. so this cannot be the reason why the report is
not being updated. What happens is when i first start my program, i select the contract no = 1000 and the report gets updated with ccontact 1000. then lets say i select
contract 1200 , the report still shows me contract 1000.

any subsequent execution of preview report function shows me contract 1000. So only the first attempt , right after i start the program shows me the correct contract.

i have used Report1.DiscardSavedData to remove saved data, if there is any.(Does not work)

I have used Report1.ReadRecords to force it to update the data in the report from the ADO.command,(Does not work).

Query Command Buttons That Print Results In Data Report?
I don't think I will ask this correctly, but if anyone know where I'm trying to go with this, I'd be appreciative fo assistance.

I've been on the MSDN site all day; literally. I hav successfully figured out and created a DataEnvironment objec and a DataReport object and both run as they should. I have als been about to retrieve successfully a report in the Acces database in which it's connecting to. My questions are these=2 Can, within the DataReport object, an object (textbox, button etc) perfom single/multiple queries on the data of a specifi report. Once the query/queries have been completed, can they b reported? I've been looking through the Data Environmen Designer section for the past two hours and everything I've se comes close to what I'm asking, but it's not what I would lik to be able to to. Is it even possible?

On one end, I'm thinking it's not possible, but on the other fro reading the MSDN site, it could be possible and I'm just no looking in the right section.

Data Report Shows No Records Unless I Pause After Command Execution
I am using the data environment to set up commands to get records which are placed onto data reports. I have found that if the command is simply returning records (in this case one record) and not using groupings or aggregates then no record detail is placed on the report. If, however, I pause for say 5 secs after calling the command and use DoEvents then the record detail is on the report! Why? It's as though the command execution is asynchronoous (I haven't set this to be the case). How do I resolve this problem without using an arbitrary pause? Here is an example of my code:

'populate the report temp table with details first
    If Not bPopVolTempReport(vdtmFrom, vdtmUntil) Then
        bVolumeReport = False
        Exit Function
    End If
    
    If deReport.rscmdVolumeRep.State = adStateOpen Then
        deReport.rscmdVolumeRepByDate.Close
    End If
    
    'generate recordset to place in report
    Call deReport.cmdVolumeRepByDate
    
    'Need to pause report output
    'without the next 6 lines or if PauseTime is less than 5
    'no details appear on report
    Dim PauseTime, Start, Finish, TotalTime
    PauseTime = 5   ' Set duration in secs.
    Start = Timer   ' Set start time.
    Do While Timer < Start + PauseTime
       DoEvents   ' Yield to other processes.
    Loop
    
    'Ensure records have been got
    If deReport.rscmdVolumeRepByDate.State <> adStateOpen Then
        deReport.rscmdVolumeRepByDate.Open
    Else
        deReport.rscmdVolumeRepByDate.Requery
    End If
    
    While (deReport.rscmdVolumeRepByDate.State <> adStateOpen)
        DoEvents
    Wend
    
    'Load the report
    Load repTransactionVolumes
    
    Call repTransactionVolumes.ExportReport(rptKeyHTML, vstrPath &
gstr_RSP_TransVolume, True, False)
    
    'Wait for the asynchronous process to
    While repTransactionVolumes.AsyncCount > 0
        DoEvents
    Wend

Any insight into the use of commands in the data environment and reports would be very welcome.

Cheers
Phil

Data Report : Child Command Field In Group Footer
lets say I have query
select count(studntid), marks_obt, subjectId from result
where grade <> 'F'
and sectionid = 'SE06BLU'
and year = '99-00'
group by marks_obt,subjectID
(this query is my child command, I am using shape statemnet)

Now can I use count(studentId) in the group footer........................?????????
and how if it is possible.............




Edited by - haahoou on 2/10/2004 1:59:30 AM

How To Make Runtime Connection To Data Envirinment, Connection, Command For Data Report
I have one form in my application.

In that form user enters start date & end date

Based on the dates I want to create record set of the order between dates.
This recordset I want to passed to data environment, connection, command,
(which I used while creating Data Report).

How to passed dynamic recordset to Data Report



Bharat

Prob. In Export A Report In RTF Format Through Crystal Report 8.0
I have a prob. in exporting a report in rtf format through crystal
report 8.0 on some client machine...

i am able to export report on my pc. but not on client machine....

plz suggest

--
Best Regards,
Sachin Jain

How Can I Export A Report, Naming The Report ...
I need help. I'm trying to export a report and naming it based on the value in a control on the report. Can I do this using VB in MS ACCESS?

Tom: Thanks for your reply.

I figured it out, The code works fine, the problem I had was that I didn't have write permissions to save the file in the network location I wanted.
Code:
DoCmd.OutputTo acOutputReport, "rpt_Whatever", acFormatSNP, "C:" & (Forms![frm_Whatever].[WhateverName]) & ".snp"

Shelling The Registry Export Command
Hi All,

I have had no success shelling the reg export command. Here's my syntax....

Private Sub Command1_Click()

Shell ("regedit /e c:Program FilesExecutionerImport.reg "HKey_Current_UserSoftwarevb and vba program settings heexecutioner"")

End Sub

If I execute the syntax (below) in a batch file it works fine.

regedit /e c:Program FilesExecutionerImport.reg "HKey_Current_UserSoftwarevb and vba program settings heexecutioner"

Here's the error message that I receive when trying to compile.

compile error:

Expected: list seperator or )


Can anyone please tell me what I doing wrong.

Thanks,

techsent

Export Report From CR9
Have been able to add photos/images on the fly in VB6 with CR9. All images show up as they are intended.

However, whenever the report is exported with a .pdf format, the first page has no images attached, but the other pages do. If exported to Word, on images are present. Then when I go back to the .pdf format, no images. Shut down and restart the program, the same results.

I populate the report using the crSection_Format:


Code:
Set crSection.ReportObjects("Classmate").FormattedPicture = _
LoadPicture(crNameTagsAdhesive.Sections("DetailSection3").ReportObjects("PicFile").Value)

Thanks for the help.

Kim

Export A Report
hi

please can anyone tell me how to export a report programmatically

i know i can do it using the report it self but i want the report tp be saved at form load without been displayed
can this be done
plz tell me the procedure
thanx

Export Report
hi.. im using datareport to generate my reports with (us std) as the paper size.. it works well when i print these reports.. but it generates an error (report width is larger than paper width) if i try to export it to another format e.g. text file(.txt).. i've already changed the properties of my default printer but it still wont work.. please help..

a friend of mine posted a similar question in the reports section of this forum but it has 0 replies.. hope somebody can help me..

Copyright © 2005-08 www.BigResource.com, All rights reserved