Help in crystal reports 8.5

Hi all

I am working on Crystal reports 8.5
In one report we need to display weekdays and weekends in every month for the given date range

I mean

Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Days of Service
Weekdays Number of weekdays in the month
Weekends Number of weekends in the month

And I need to calculate total of some items from Friday after 3 pm

2) In another report I am using stored procedure to get fields
As per my knowledge we cannot use other than one stored procedure in crystal reports 8.5
So I am using sub report to get some more fields other than stored procedure fields

But in main report I need to get sub- total of fields in sub report.

Could any one please help me out?You would use the Crystal Reports (http://www.saveonsupport.com) shared variable functionality. In your subreport you would have a formula field something like this:

WhilePrintingRecords;
Shared numbervar myTotal;
myTotal := myTotal + {field name}

Add this field to the subreport and suppress it.
Then in the main report you need another formula something like this:

WhilePrintingRecords;
Shared numbervar myTotal;
myTotal

The subreport keeps adjusting the total while printing records and the main report simply displays this value.

Hop this helps!|||Thanks for your reply
it works for me

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
HenrikWhat changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want
to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for maintenance plan

Hello to all
I make maintenance plan for backup of my SQL server 2000 database. I want to
make some changes in maintenance plan but i am not bale to see where can i
perform these changes? Need help
Regds
Henrik
What changes are you trying to make?
If you open Enterprise Manager, go to Management, Maintenance Plans. Right
click the Maintenance Plan you created...go to properties. Then go to the
Complete Backup Tab...
If the option you are looking for is not there, then it's an option that can
only be changed during the creation of the plan.
You will have to create a new plan.
Donna Lambert
"Henrik" wrote:

> Hello to all
> I make maintenance plan for backup of my SQL server 2000 database. I want to
> make some changes in maintenance plan but i am not bale to see where can i
> perform these changes? Need help
> --
> Regds
> Henrik
>

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help me
A great way to learn newer concepts is probably to study other people's
source code. Check out http://www.thecodeproject.com.
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447024.790773.136420@.f14g2000cwb.googlegr oups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>
|||"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote:

>Hi All
>I am fresh college graduate who has done C and C++ during college
>times.After that i had done a C# course from one of our local computer
>institute.The course is BCM which ran for 1 year.But now when i am
>looking for job the questions asked in interview are really very very
>weird and does not match any where near to what my institute taught.
>...
>with that he has said to do small project which will make me confident.
>But i need a job soon and can not really wait to do dummy projects do
>you really think those upper links can be helpful in getting a job
Your advisor has given you good advice. The questions in your interviews
are designed to root out whether you actually have any real-world
experience, and based on your reaction, they seem to have done their job.
One of the great ways to get real-world experience is, well, to get
real-world experience, by tackling some project on your own. You might as
well use the time you have before you get a job.
Also, remember that Linux comes with hundreds of thousands of lines of
real-world, working C code that you can read and tinker with.
- Tim Roberts, timr@.probo.com
Providenza & Boekelheide, Inc.

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help me
I'll answer as best I can.
It's not unusual for Academia to teach skills which do not reflect the real
world. All they seem to do is prove you are capable of learning ...
something.
Firstly I would stongly advise that you learn the development cycle by
thinking of a project and write it. You'll go through all the pains of bugs,
code crashes, lack of information as well as building up a strong reference
of internet sites and material from which you can draw from in the future.
This does means time will need to be invested. You'll be very lucky to get a
job without some basic usable skills unless you find someone to employ you
as a trainee. As regards to getting a job. Get one but not neccesarily as a
programmer. After you've written your project(s) and got used to seeing
"real code" you'll be much better prepared for the interview process and
many of the things you were asked you will now understand and be able to
answer and maybe they'll offer you a job.
Nik Marshall-Blank MCSD/MCDBA
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447136.410064.175010@.g44g2000cwa.googlegr oups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>

Help for C# Interview questions and career decision

Hi All
I am fresh college graduate who has done C and C++ during college
times.After that i had done a C# course from one of our local computer
institute.The course is BCM which ran for 1 year.But now when i am
looking for job the questions asked in interview are really very very
weird and does not match any where near to what my institute taught.
My faculty has give me following links for preparation of interview
http://www.geocities.com/dotnetinterviews/
http://www.techninterviews.com
http://www.brainbench.com
http://www.crackinterviews.com
with that he has said to do small project which will make me confident.
But i need a job soon and can not really wait to do dummy projects do
you really think those upper links can be helpful in getting a job
I am new comer so please excuse for asking in this way.Any good website
for interview question please help meI'll answer as best I can.
It's not unusual for Academia to teach skills which do not reflect the real
world. All they seem to do is prove you are capable of learning ...
something.
Firstly I would stongly advise that you learn the development cycle by
thinking of a project and write it. You'll go through all the pains of bugs,
code crashes, lack of information as well as building up a strong reference
of internet sites and material from which you can draw from in the future.
This does means time will need to be invested. You'll be very lucky to get a
job without some basic usable skills unless you find someone to employ you
as a trainee. As regards to getting a job. Get one but not neccesarily as a
programmer. After you've written your project(s) and got used to seeing
"real code" you'll be much better prepared for the interview process and
many of the things you were asked you will now understand and be able to
answer and maybe they'll offer you a job.
Nik Marshall-Blank MCSD/MCDBA
"programmerforknowledge" <aspdotnetprogrammer420@.yahoo.co.in> wrote in
message news:1126447136.410064.175010@.g44g2000cwa.googlegroups.com...
> Hi All
> I am fresh college graduate who has done C and C++ during college
> times.After that i had done a C# course from one of our local computer
> institute.The course is BCM which ran for 1 year.But now when i am
> looking for job the questions asked in interview are really very very
> weird and does not match any where near to what my institute taught.
> My faculty has give me following links for preparation of interview
> http://www.geocities.com/dotnetinterviews/
> http://www.techninterviews.com
> http://www.brainbench.com
> http://www.crackinterviews.com
> with that he has said to do small project which will make me confident.
> But i need a job soon and can not really wait to do dummy projects do
> you really think those upper links can be helpful in getting a job
> I am new comer so please excuse for asking in this way.Any good website
> for interview question please help me
>

HELP - urgent situation

Hey all

I've got a DTS package with a script that does this:

Set xlApp = CreateObject("Excel.Application")

This fails though. Do I have to install MS Office on the machine the SQL Server is on? Or can I simply copy a few DLLs over and register them??

Thanks! I gotta get this solved within 5 hrs :(I am by no means an expert on this particular situation, but I would think that your 'best' (meaning most likely to work the first time) solution would be to install MS Office (just the Excel portion of it) on the server.

Regards,

hmscott|||Our in-house IT guy won't install Excel/Office on the server that our SQL Server is on.. something about opening up for potential problems and/or security issues.

It seems to me that if you CreateObject("Excel.Application"), that there's some kind of ActiveX .dll that could be registered on the server to allow the creation of these Excel COM objects. Anyone know which files they are??|||Where is the Package called from?

If client side app I would suggest installing Excel would work,

If a VB app adding the Excel distributables in the compile should work.

Create a reference to the Excel Object in your VB app.

mine is at
C:\Program Files\Microsoft Office 2000\Office\EXCEL9.OLB

When installed the required registry entries should follow.

Good Luck|||It's an ActiveX script within a DTS package on the server. I'd LIKE to have Office installed, but IT won't allow it.

Is there some way I could place the EXCEL9.OLB file on the server, and reference it somehow in my VBScript??|||All DTS Packages are run on the client unless scheduled by SQL Server regardless of where the code resides.

Your users will need Excel on their PC to use the output anyway, as well as DTS dlls (read SQL Server Client).

Is XML an option? or a structured text file which they can import into Excel. If so you could use the fileScripting object in Active script.|||Well.. actually this is a web page executing the DTS package.. so all the proper DTS dlls are installed on the web server now. And the DTS package has an ActiveX script that tries to create an instance of Excel.Application..but can't do so because Office is not installed on the web server (and will never be).

Nope.. XML is not an option. They gave us an Excel workbook they want populated.. there's no room to budge on this, unfortunately.|||If all you are doing is a data migration into a template try to map to the Excel spreadheet and se a dtsDataPump|||What if you pumped the data to a Comma Separated Value file (.csv), and let Excel convert it from wherever the client happens to open it from?|||OK here's the solution we went with.. MS Office Web Components.

Problem is, I can't find any thorough documentation on it. I want to know if it's possible to open an Excel file with it.

Set objOWC = CreateObject("OWC10.Spreadsheet")

That's how it's created. I have a few examples that tell you how to create a new Excel file from scratch and save it. But not how to open an existing one, modify it, then save to a new file.

Does anyone know, or can point me to some documentation? Thanks!