Re: How to connect to different servers at runtime
Hi,
yes, crystal report had LogOnServer method it contains server connection string, so that you can change the sql server location.
In crystal report design time, you can use "logon/off server" and "set location" to change the server location.
Regards,
K.Babu
Quote:
Originally posted by mpsudheer
Hi ,
In crystal Report can i be able to connect to different servers based on the user input. Eg- User will select a location (Chennai, Bangalore etc..) based on which i have to connect to SQL Server on that location. I don't have a front end like VB or ASP. I have to do it directly in Crystal Report. Is it possible to do this????
Please suggest a solution
Thanks in advance
Sudheer
Exporting crosstab report to excel file.
Hi,
I have a report with crosstab. this crosstab appears per group. i want to export each crosstab on separate excel sheet. as the number of groups incerases, the excel sheet should also increase.
I will make it clear.
i have something as category. i create a group of this field category. now i create a crosstab and insert in detail section. so the output will be matrix report as per category. that is i will get as many crosstabs as there are categories in my table.
now i want to export this report into microsoft excel file. Microsoft Excel is a spreetsheet package. Each file is a workbook and there can be n number of worksheets into that workbook.
what i want is that each crosstab ir each group should appear in single worksheet of excel workbook. It means there should be as many worksheets in the excel workbook as there are categories or crosstabs in the report.
Looking forward for ur reply.
Thank You.
Crystal Report 9 - Deployment Problem
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
Re: Crystal Report 9 - Deployment Problem
Hi,
What type of crystal report engine you are using in your vb app.
eg. (ActiveX control, RDC)
regards,
K.Babu
Quote:
Originally posted by syedhassan4
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
Re: Clarification needed ... to Babu
First of all I would like to Thank you for replying.... Babu..
I tested what you said.. but i get an error stating...
x20506 Invalid Table Number
This is my coding.... Check where I made the Mistake. {First I checked the 'Verify on Every Print' in the report at Design Time} I use sub-report too.
Crys.LogonInfo(0) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.LogonInfo(1) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
' SubReport
Crys.SubreportToChange = "Liab.rpt"
Crys.LogonInfo(2) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.SelectionFormula = lvQuery ' Query Variable
' SubReport Assets.rpt
Crys.SubreportToChange = "Asset.rpt"
Crys.LogonInfo(3) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.SelectionFormula = lvQuery ' Query Variable
' Main Report
Crys.SubreportToChange = ""
Crys.SelectionFormula = lvQuery
Crys.DiscardSavedData = True
Crys.Destination = crptToWindow
Crys.WindowState = crptMaximized
Crys.Action = 1
In this report 1 main report, 2 Sub-report.
In the Main report I used 2 tables, in the Sub report, I used 1 report each.
Regards
Soundar
Note: Expecting your Early reply.. Thank You !!
Re: Crystal Report 9 - Deployment Problem
The required runtime files for an application developed using the Report Designer Component are listed below.
FILE LOCATION
CRAXDRT.DLL \PROGRAM FILES\SEAGATE SOFTWARE\REPORT DESIGNER COMPONENT
CRVIEWER.DLL \PROGRAM FILES\SEAGATE SOFTWARE\VIEWERS\ACTIVEXVIEWER
NOTE: You must register these DLLs using regsvr32.exe.
NOTE: The Crystal Report Viewer DLL needs to be distributed if reports are being printed to the screen. If the reports are being exported or printed to the printer, and not being viewed to a window, then this DLL is not required. Note: Embeddable Crystal Reports Designer Control accesses to the report engine through using CRAXDDRT.DLL (Crystal Reports ActiveX Designer Design and Runtime Support DLL
FILE LOCATION
IMPLODE.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
SSCSDK80.DLL \PROGRAM FILES\SEAGATE SOFTWARE\SHARED
PG32CONV.DLL \PROGRAM FILES\SEAGATE SOFTWARE\SHARED
CRPAIG80.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
MFC42.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
MSVCRT.DLL \WINDOWS\SYSTEM or \WINDOWS\SYSTEM32
NOTE: Include IMPLODE.DLL only for applications using reports created in versions previous to SCR 8.
The following files are also must register using with regsvr32.exe
"COMCAT.DLL"
"OLEPRO32.DLL"
"OLEAUT2.DLL.DLL"
"MSVBVM60.DLL"
"MSRDO20.DLL"
"MSSTDFMT.DLL"
"MSADODC.OCX"
"CRYSTL32.OCX"
"COMDLG32.OCX"
"MSCOMCTL.OCX"
"MSCOMCT2.OCX"
"MSRD2X35.DLL"
"MSJET35.DLL"
"DAO350.DLL"
"EXPORTMODELLER.DLL"
"CRTSLV.DLL"
Quote:
Originally posted by syedhassan4
I used Crystal Report 9 (Crystal Report Service Pack 1) in my Visual Basic application and it working fine on my system (i am using Windows 2000 Pro - Service Pack 4, Visual Studio Service Pack 5).
Now I need to creat a Deployment wizard, which can be Run on Windows 2000 and also on WINDOWS 98 (second edition). After a long searching and working, and spending alot of time on the file required files for Crystal Report, i creat a setup. BUT that dose not work properly even though i put all the required files as per the given instruction in the Crystal Report Runtime help.
Please please help me on that matter.... GIVE me list of files which required for the setup, and also which file should be put on which Path, and which DLL should be registered.
And the most important part is WINDOWS 98, in windows 98 there is problem of UNICOWS, please also help me on that matter.
I will be really very very very very thankful to u....
I am really unable to solve the problem of Crytal Report 9.0.
Re: Re: Clarification needed ... to Babu
You have to specify all the information in logoninfo(n) property
DSN = Data Source Name
UID = User Logon ID
PWD = Logon password
DSQ = "c:\projects\data.mdb" [or server name]
Quote:
Originally posted by bsoundar
First of all I would like to Thank you for replying.... Babu..
I tested what you said.. but i get an error stating...
x20506 Invalid Table Number
This is my coding.... Check where I made the Mistake. {First I checked the 'Verify on Every Print' in the report at Design Time} I use sub-report too.
Crys.LogonInfo(0) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.LogonInfo(1) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
' SubReport
Crys.SubreportToChange = "Liab.rpt"
Crys.LogonInfo(2) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.SelectionFormula = lvQuery ' Query Variable
' SubReport Assets.rpt
Crys.SubreportToChange = "Asset.rpt"
Crys.LogonInfo(3) = "DSN=Acc;UID=abc;PWD=abc;DSQ="
Crys.SelectionFormula = lvQuery ' Query Variable
' Main Report
Crys.SubreportToChange = ""
Crys.SelectionFormula = lvQuery
Crys.DiscardSavedData = True
Crys.Destination = crptToWindow
Crys.WindowState = crptMaximized
Crys.Action = 1
In this report 1 main report, 2 Sub-report.
In the Main report I used 2 tables, in the Sub report, I used 1 report each.
Regards
Soundar
Note: Expecting your Early reply.. Thank You !!
Re: Exporting crosstab report to excel file.
Hi,
In Crystal Report Viewer there is an option to filter the data while viewing the report, use the filter wizard to filter the exact data whatever you need then export the content which format you wish.
Quote:
Originally posted by SayliJoshi
Hi,
I have a report with crosstab. this crosstab appears per group. i want to export each crosstab on separate excel sheet. as the number of groups incerases, the excel sheet should also increase.
I will make it clear.
i have something as category. i create a group of this field category. now i create a crosstab and insert in detail section. so the output will be matrix report as per category. that is i will get as many crosstabs as there are categories in my table.
now i want to export this report into microsoft excel file. Microsoft Excel is a spreetsheet package. Each file is a workbook and there can be n number of worksheets into that workbook.
what i want is that each crosstab ir each group should appear in single worksheet of excel workbook. It means there should be as many worksheets in the excel workbook as there are categories or crosstabs in the report.
Looking forward for ur reply.
Thank You.
Re: Re: Exporting crosstab report to excel file.
Hi
see i do not want to filter the data. i want all the groups or categories to appear in the report. while exporting i want each crosstab or category with the categoryname as name of sheet to appear in each sheet of excel file.
Pl Help .its really important.
Thank you
Quote:
Originally posted by K.Babu
Hi,
In Crystal Report Viewer there is an option to filter the data while viewing the report, use the filter wizard to filter the exact data whatever you need then export the content which format you wish.