Crystal Reports Schedulers

Can anyone recommend a good, reasonably low-priced (say, $500 or below) Crystal reports scheduling application that would be compatible with Crystal Reports version 8.0.1.0, running reports that are using Fox Pro tables (in native form) as their data source?

I need to run 16 or so sets of the same 18 reports on a monthly basis.

All help and ideas would be greatly appreciated.

Thanks!Do a google searchsql

Crystal Reports Question for BABU/any GURU

Can some one please help me with the below.

I need to write a formula in crystal reports to give the birth dates for this week. For Example: If I am running the report on a Tuesday I need to see the results from Tuesday to Saturday. I know that we can acheive this in 7 conditional steps, but I am looking for a precise formula. Can some one please help me with this.

Thanks
BTry this logic

Date=Date+5

CR.selectionFormula="{DateField=Date}"

Crystal Report Doubt

Dear All,

i am visual basic Programmer.But new to crystal report . I coded like below

report1.Formulas(1) = "compadd2='" & (PockAdd2) & "'" 'Place
report1.Formulas(2) = "compadd3='" & (PockAdd3) & "'" 'City
report1.Formulas(3) = "strtitle='" & (strtitle) & "'" 'Title
report1.RetrieveDataFiles
report1.Action = True

Which Shows an error "Invalid File name", While Executing the line "Report1.RetrieveDataFiles"

Have any solution for this problem.

Pls let me know

Regards

Abdul VahidTry the next :
1.- Click on Menu / Database / Verify Database
and / or
2.- Include file definition before preview report
.
Report1.DataFiles(0) = SomePath & "\Somefile.Mdb"
Report1.DataFiles(1) = SomePath1 & "\Somefile1.Mdb"

.

Crystal Enterprise 10 - Issue

Hi

Can any one help us to slove the below problems. It is very critical
because all our outlets are having win98 deskstop which is not able
to download activex viewer from CE10 Server (Which is running in Solaris).

If we connect to CE10 from win98 desktop using Explorer 6.0, it is pop up
the message saying that download Crystal Activex Control yes or no. After
pressing Yes button it's waiting for 2/3 mint then throwing out the error
as follows;

THE CRYSTAL REPORT VIEWER IS UNABLE TO CREATE IT'S RESOURCE OBJECTS.

Please let us to know how to slove this problems or we need to apply any
hotfix for this.

Thanks in advance.

Regards,
sashiv.I'm not sure about Crystal Enterprise 10, but Crystal Reports 10 doesn't run on Win98. Check out the minimun installation requirements for the operating systems that Crystal Enterprise 10 does support to see if it does support Win98. This link will take you to the web page where Crystal has their system requirements; http://www.businessobjects.com/products/reporting/crystalreports/sysreq.asp. Hope this helps.

CryptAcquireContext failed. Error 0x57

On a production db of over 100 GB, i am getting the below error freqently and i have to restart my server as it becomes dead.

[Microsoft][ODBC SQL Server Driver][SQL Server]CryptoAPI function 'CryptAcquireContext' failed. Error 0x57: The parameter is incorrect.

Alias: DBDest [07-07-16 17:14:04]

Please advise what is the cause of this problem/error and how to resolve this.

Can you tell us what you are doing when this error occurs? Anything to help isolate the cause of this issue will be helpful.

Can you also describe your setup? Are you running SQL Server 2005? 2000? What service pack?

Thanks,

jkh

Cross Tab Query

Hi!

I m using sql 2005.I have a table as showing below.

yearRegionloan_amtpur_idpurpose1981Andhra pradesh$20,000.00 1Animal Husbandary1981Arunachal Pradesh$110,000.00 1Animal Husbandary1981Assam$240,000.00 1Animal Husbandary1981Bihar$75,000.00 1Animal Husbandary1981Chhattisgarh$55,500.00 1Animal Husbandary1981Gujarat$77,500.00 1Animal Husbandary1982Goa$44,888.00 1Animal Husbandary1982Himachal pradesh$4,000.00 1Animal Husbandary1982Himachal pradesh$20,000.00 1Animal Husbandary1982Jammu and kashmir$30,000.00 1Animal Husbandary1882Jharkhand$35,000.00 1Animal Husbandary1982Karnataka$40,000.00 1Animal Husbandary1982Kerala $20,000.00 1Animal Husbandary1982Madhya pradesh$5,000.00 1Animal Husbandary

I want to produce report as by using crosstab query as showing bellow

Year Asam Hyadrabad goa arunachal pardesh etc.........

1981 1000.00 2000.00 8000.2 00000 000000 .....

1981

'

'

Is it possible by crosstab query ?or please suggest me another way as early as possible.

Thanx in advance.

Abhishek

Have a look at thePIVOT method in SQL Server 2005.

|||

Agree.

Based on my understanding, I think you can use crosstab query in your case. It is desgined for that.

A crosstab calculates an aggregation on a certain column (A) in a set of rows. It then transforms the unique values in another column (X) into column names for the result. All other columns (Y) are used for grouping and their unique values define the rows for the result. The aggregated values of A are distributed among columns in the result according to the value of X and among rows in the result according to the value of Y.

BTW, since you are using sql2005, i think you would need this link:http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1131829,00.html

You can first run that script to create a sp_crosstab then you will be able to use cross tab through your database. thanks

This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

|||

can you be more specific about the columns in the query? I think it can be dne with Group By.

|||

You can't do this by cross-matrix query.

But you can gather such data Datatable in asp.net.

say you have three tables

table a which contains columns : year_id, year.

table b which contains columns : region_id, region.

table c which contains columns : year_id, region_id, amt.

you just do:

string sql="select year_id, year from a";

datatable maindt=sqlhelper.executedatatable(cn, text, sql);

sql="select region_id, region from b";

datatable tempdt=sqlhelper.executedatatable(cn, text, sql);

foreach (datarow dr in tempdt.rows)

{

maindt.columns.add(dr["region"].tostring());

}

foreach (datarow dr in maindt.rows)

{

for(int i=2;i<maindt.columns.count;i++)

{

sql="select amt from c, b where c.region_id=b.region_id and year_id=dr["year_id"].tostring() and region=maindt.columns[i].columnname";

tempdt=sqlhelper.executedatatable(cn, text, sql);

dr[i]=tempdt.rows[0][0].tostring();

}

}

|||

mayankparmar2000:

You can't do this by cross-matrix query.

Yes you can (see the link in my first post). There are other methods as well if you are using a version of SQL Server older than 2005.

|||

Hi guies !

Finaly i resolve this problem by using Pivote in sql 2005 .

Any way thanks for all of u for ur suggestion.

Abhishek.