Showing posts with label details. Show all posts
Showing posts with label details. Show all posts

Monday, March 26, 2012

Getting #Error details from deployed report

I have a report that displays #Error for some field values when deployed on the server. Is there any way to get details on the error?

Thanks.

Most likely the #Error comes from making a call into a custom assembly and insufficient security permissions for that custom assembly to be invoked.

You can partially simulate the server environment, if you run the report in the stand-alone preview of report designer. I.e. instead of clicking on the Preview tab, hit F5 which should open a new window for the stand-alone preview. For the #Error you should get warning messages with more details in the output window.

-- Robert

Monday, March 19, 2012

Get weekdays and weekends in a month

Hi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .......,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays -- 1,Weekends --- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

ThanksHi all

Here i am giving the requirement

Page header i have to place months
Jan,Feb .......,Dec

In the details i have to get how many weekdays and weekends in give date range(startdate,enddate) for respective months

if i give startdate 1/1/2005(dd/mm/yyyy) end date 3/1/2005
need to get weekdays -- 1,Weekends --- 2

I am using Crystareports 8.5 and SQL Server as database

Could any one please help me out

Thanks

Try putting dates of that month in details section and then use dayofweek crystal function to find whether it is a weekday or weekend in a formula which return 1 then sum them. thats it
i know not the best way.