Consistant dates for use in querys

I want to make some UDF()s to preset dates for a slew of reports that I need
to do.
In SQL Server I'm missing the mark in date math. I need to get a few basic
dates and I'll roll with the others
StartofLastMonth
EndofLastMonth
StartofLastW
EndofLastW
StartofCurrentMonth
EndofCurrentMonth
YesterdayWithWends
Is there any way to detect a holiday and know that business is closed? We
B2B with banks so we will be closed on Columbus Day! How can my
Yesterday... know that on Oct 11th it should really use Oct 7?
TIA
__StephenStephen,
Check out Aaron's page:
http://www.aspfaq.com/show.asp?id=2519
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:ufmEpv1yFHA.2516@.TK2MSFTNGP12.phx.gbl...
>I want to make some UDF()s to preset dates for a slew of reports that I
>need to do.
> In SQL Server I'm missing the mark in date math. I need to get a few
> basic dates and I'll roll with the others
> StartofLastMonth
> EndofLastMonth
> StartofLastW
> EndofLastW
> StartofCurrentMonth
> EndofCurrentMonth
> YesterdayWithWends
> Is there any way to detect a holiday and know that business is closed? We
> B2B with banks so we will be closed on Columbus Day! How can my
> Yesterday... know that on Oct 11th it should really use Oct 7?
> TIA
> __Stephen
>

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection to Oracle

I have created reports in SQl Server 2005 Reporting Services using an Oracle Data Sources. When I Preview the report in VS 2005, It runs fine but when I deploy it, it fails to make a coonection to the oracle data source.

Reports off the SQL Server Data Sources arerunning fine.

Can any one out there help me out on this. I will really appreaciate.

Regards,

Sam.

Assuming Oracle's client software is installed on the report server machine, it is most likely a directory permissions issue with Oracle's client software installation - see http://support.microsoft.com/?kbid=870668

-- Robert

|||

Hi Robert,

Thanks for the guideline but I have done what is required as stated in the link and I still get the same error.

|||Do you deploy the reports on the same PC? Maybe your Server has a different Oracle installation or tnsnames.ora..
For TESTING!! you could give "everyone" read/execute -access to your oracle-directory to eliminate permission-problems.
|||

It seems Permissions were my problem.

I assigned read/execute access to each of the Oracle Home Directory Folders and Subfolder to Network Service and it sorted out the problem

Thanks for all the Advise.

|||

Hi there,

I have the same issue as described earlier in this thread. I have applied the security (Read and Execute) to all known Oracle instance directories to the Network Service account (which is being used for starting the Reporting Service) and I am still receiving the following error message:

An error has occurred during report processing.

Cannot create a connection to data source 'XXX'.

System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.|||

I'm trying to use the Oracle instant client on my report server. it is setup correctly and I can connect via SQL+. I've modified reporting services to use Network Service as account for both windows and web services. And I've set permission on the OIC directory appropriately according to MS guidelines.

But same error, will not connect to the Oracle data source.

Connection string for reporting model

Hi,

I've just created a reporting model to use with my reports.

I have deployed the model to my localhost reporting server.

The name of my model is : mod_agentreporting

Can someone give me the right connection string that i have to use ?

Is there any advantage for using reporting models as datasources for reports

or a shared data sources ?

Thanks already in advance for your remarks.

Vincent

http://msdn2.microsoft.com/en-us/library/ms345238.aspx

btw, that's the top result you get by googling:

site:msdn2.microsoft.com +"report model" +"connection string"