Hi,
I want to be able to do a simple import from an excel spreadsheet i.e.
DTS, within SQL Server Management Studio. I have added two registered
servers, but I cannot register them to the integration services, so
that I can then do an import. is this correct or am I doing somethign
wrong? I have used SQL Server Business Intelligence Development
Studio, but surely there is a way to do it simply withing SSMS.
Appreciate any help on this.
Damon.You can do it pretty much the same way as with SQL 2000. Try right clicking
on the database name in SSMS, select Tasks, Import Data and go from there...
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||There are a number of different ways to start the SSIS Import / Export
wizard. You can start it a couple of ways using the SQL Server Business
Intelligence Development Studio. Or you can start
it using the SQL Server Management Studio. Lastly, you can start it using an
executable.
Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
http://www.databasejournal.com/feat...cle.php/3580216
Thanks
Hari
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||On 14 Feb, 13:11, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:[vbcol=seagreen]
> There are a number of different ways to start the SSIS Import / Export
> wizard. You can start it a couple of ways using the SQL Server Business
> Intelligence Development Studio. Or you can start
> it using the SQL Server Management Studio. Lastly, you can start it using
an
> executable.
> Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
> http://www.databasejournal.com/feat...cle.php/3580216
> Thanks
> Hari
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
>
>
>
>
Excellent, thanks very much. Fair play though, I should have checked
there.
Thanks again.
Damon
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Wednesday, March 28, 2012
Help with sql 2005 integration services.
Hi,
I want to be able to do a simple import from an excel spreadsheet i.e.
DTS, within SQL Server Management Studio. I have added two registered
servers, but I cannot register them to the integration services, so
that I can then do an import. is this correct or am I doing somethign
wrong? I have used SQL Server Business Intelligence Development
Studio, but surely there is a way to do it simply withing SSMS.
Appreciate any help on this.
Damon.You can do it pretty much the same way as with SQL 2000. Try right clicking
on the database name in SSMS, select Tasks, Import Data and go from there...
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||There are a number of different ways to start the SSIS Import / Export
wizard. You can start it a couple of ways using the SQL Server Business
Intelligence Development Studio. Or you can start
it using the SQL Server Management Studio. Lastly, you can start it using an
executable.
Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
http://www.databasejournal.com/features/mssql/article.php/3580216
Thanks
Hari
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||On 14 Feb, 13:11, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> There are a number of different ways to start the SSIS Import / Export
> wizard. You can start it a couple of ways using the SQL Server Business
> Intelligence Development Studio. Or you can start
> it using the SQL Server Management Studio. Lastly, you can start it using an
> executable.
> Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
> http://www.databasejournal.com/features/mssql/article.php/3580216
> Thanks
> Hari
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> > Hi,
> > I want to be able to do a simple import from an excel spreadsheet i.e.
> > DTS, within SQL Server Management Studio. I have added two registered
> > servers, but I cannot register them to the integration services, so
> > that I can then do an import. is this correct or am I doing somethign
> > wrong? I have used SQL Server Business Intelligence Development
> > Studio, but surely there is a way to do it simply withing SSMS.
> > Appreciate any help on this.
> > Damon.
Excellent, thanks very much. Fair play though, I should have checked
there.
Thanks again.
Damon
I want to be able to do a simple import from an excel spreadsheet i.e.
DTS, within SQL Server Management Studio. I have added two registered
servers, but I cannot register them to the integration services, so
that I can then do an import. is this correct or am I doing somethign
wrong? I have used SQL Server Business Intelligence Development
Studio, but surely there is a way to do it simply withing SSMS.
Appreciate any help on this.
Damon.You can do it pretty much the same way as with SQL 2000. Try right clicking
on the database name in SSMS, select Tasks, Import Data and go from there...
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||There are a number of different ways to start the SSIS Import / Export
wizard. You can start it a couple of ways using the SQL Server Business
Intelligence Development Studio. Or you can start
it using the SQL Server Management Studio. Lastly, you can start it using an
executable.
Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
http://www.databasejournal.com/features/mssql/article.php/3580216
Thanks
Hari
"nomad" <d.bedgood@.ntlworld.com> wrote in message
news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> Hi,
> I want to be able to do a simple import from an excel spreadsheet i.e.
> DTS, within SQL Server Management Studio. I have added two registered
> servers, but I cannot register them to the integration services, so
> that I can then do an import. is this correct or am I doing somethign
> wrong? I have used SQL Server Business Intelligence Development
> Studio, but surely there is a way to do it simply withing SSMS.
> Appreciate any help on this.
> Damon.
>|||On 14 Feb, 13:11, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> There are a number of different ways to start the SSIS Import / Export
> wizard. You can start it a couple of ways using the SQL Server Business
> Intelligence Development Studio. Or you can start
> it using the SQL Server Management Studio. Lastly, you can start it using an
> executable.
> Take a look into the below URL on using Improt/Export wizard in SQL 2005:-
> http://www.databasejournal.com/features/mssql/article.php/3580216
> Thanks
> Hari
> "nomad" <d.bedg...@.ntlworld.com> wrote in message
> news:1171456545.592838.73050@.a75g2000cwd.googlegroups.com...
> > Hi,
> > I want to be able to do a simple import from an excel spreadsheet i.e.
> > DTS, within SQL Server Management Studio. I have added two registered
> > servers, but I cannot register them to the integration services, so
> > that I can then do an import. is this correct or am I doing somethign
> > wrong? I have used SQL Server Business Intelligence Development
> > Studio, but surely there is a way to do it simply withing SSMS.
> > Appreciate any help on this.
> > Damon.
Excellent, thanks very much. Fair play though, I should have checked
there.
Thanks again.
Damon
Monday, March 26, 2012
Help with setting up Reporting Services
I am trying to set up Reporting Services. I am using SQL Server 2005.
I installed service pack 2 for SQL Server 2005. The database looks to be set up in the configuration manager. When I try to deploy the report I get the following message:
A connection could not be made to the report serverhttp://localhost/ReportServer
When trying to open the ReportServer folder in IIS I get another message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Exception has been thrown by the target of an invocation.
Could not load file or assembly 'Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.
I am not sure what SharePoint is and why I need it. I am just trying to set up simple reports on a local host SQL database and IIS on a standalone PC.
Any help appreciated.
Thanks
I recently installed SQL Server 2005 SP2 and I'm receiving this same error.
When I bring up the Reporting Services Configuration tool, and go to "Database Setup" as you say, I do in fact see a "Server Mode" line and it's set to "SharePoint Integrated".
How do I turn this off / fix the problem?
Thanx for any help in advance.
|||I found my answer here:http://msdn2.microsoft.com/en-us/library/bb326407.aspx
Friday, March 23, 2012
Help with security model for RS implementation needed
We're running Reporting Services (wSP1) on a Win 2003 server box. Presently
(for development), SQL Server, the web application and RS all run on the
same box. I've configured an app pool in IIS under which Reports,
ReportServer and the web application run. I'm also collecting credentials
via forms auth which I pass as the credentials to RS during web service
calls. We are using URL access to access rendered reports.
RS Windows Service is configured to run as NT AUTH\Network Service.
All datasources are set up using trusted security.
What I'd like to be able to do to ensure that we use connection pooling is
not impersonate the credentials passed in but instead connect to the OLAP
database as a single domain account.
Is this possible and if so, what security configuration changes should I
make to make this happen?
Thanks in advance.
-TimPlease disregard my original post. The absurd amounts of caffeine I've been
consuming lately have caused temporary memory loss. :)
-Tim
"Tim Ellison" <TimEllison@.direcway.com> wrote in message
news:Oajl$kstEHA.1400@.TK2MSFTNGP11.phx.gbl...
> We're running Reporting Services (wSP1) on a Win 2003 server box.
Presently
> (for development), SQL Server, the web application and RS all run on the
> same box. I've configured an app pool in IIS under which Reports,
> ReportServer and the web application run. I'm also collecting credentials
> via forms auth which I pass as the credentials to RS during web service
> calls. We are using URL access to access rendered reports.
> RS Windows Service is configured to run as NT AUTH\Network Service.
> All datasources are set up using trusted security.
> What I'd like to be able to do to ensure that we use connection pooling is
> not impersonate the credentials passed in but instead connect to the OLAP
> database as a single domain account.
> Is this possible and if so, what security configuration changes should I
> make to make this happen?
> Thanks in advance.
> -Tim
>
(for development), SQL Server, the web application and RS all run on the
same box. I've configured an app pool in IIS under which Reports,
ReportServer and the web application run. I'm also collecting credentials
via forms auth which I pass as the credentials to RS during web service
calls. We are using URL access to access rendered reports.
RS Windows Service is configured to run as NT AUTH\Network Service.
All datasources are set up using trusted security.
What I'd like to be able to do to ensure that we use connection pooling is
not impersonate the credentials passed in but instead connect to the OLAP
database as a single domain account.
Is this possible and if so, what security configuration changes should I
make to make this happen?
Thanks in advance.
-TimPlease disregard my original post. The absurd amounts of caffeine I've been
consuming lately have caused temporary memory loss. :)
-Tim
"Tim Ellison" <TimEllison@.direcway.com> wrote in message
news:Oajl$kstEHA.1400@.TK2MSFTNGP11.phx.gbl...
> We're running Reporting Services (wSP1) on a Win 2003 server box.
Presently
> (for development), SQL Server, the web application and RS all run on the
> same box. I've configured an app pool in IIS under which Reports,
> ReportServer and the web application run. I'm also collecting credentials
> via forms auth which I pass as the credentials to RS during web service
> calls. We are using URL access to access rendered reports.
> RS Windows Service is configured to run as NT AUTH\Network Service.
> All datasources are set up using trusted security.
> What I'd like to be able to do to ensure that we use connection pooling is
> not impersonate the credentials passed in but instead connect to the OLAP
> database as a single domain account.
> Is this possible and if so, what security configuration changes should I
> make to make this happen?
> Thanks in advance.
> -Tim
>
Wednesday, March 21, 2012
Help with roles in SQL Server Reporting Services 2005
I know how to create roles but how do you add users to them, and then roles to different levels? This section of MSDN doesn't tell much
http:
You can also do this at the site level for the site level permissions. Click on 'Site Settings' in the upper right hand corner. Then click on 'Configure site-wide security'. From here you can again add users and assign them different system roles.
-Daniel
Help with reporting services
Ok, here's the deal.
I uninstalled SQL on the first machine i was trying it on ... and have now installed SQL on a new machine and I have run through the set up the same way I did before and I am getting this error now. I get this error when trying to connect from the server machine .. and when I try to connect from a client machine I get a page not found error in the browser
I'm just learning sql express and I'm trying to get my reporting
services worked out. I have everything installed and I have managed to
connect to the report server at http://<computername>/Reports
my problem is I can only connect to this page when I am at the machine
where the sql database, reporting database, etc... I cannot log on to
this site from any other computer no my network? Does any one know why
?
I have also tried installing on a different machine and I get an error "Server Error in /ReportServer application..... failed to access IIS metabase.
IIS is installed on this machine.
Thanks!!!
As long as you are inserting the correct computer name in your URL string, I don't see why it shouldn't connect. Obviously you wouldn't want to use http://localhost/Reports to connect from a client machine. Are both the server and client under the same domain?
What happens when you try http://<computername>/reportserver ?
|||I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?|||Jamaz wrote:
I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?
No that wouldn't matter.
What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?
|||Jamaz wrote: I've tried using the computer name when trying to connect from a client machine and I get the same result. Both machines are on the same domain but using different user accounts. Would that matter?
No that wouldn't matter.
What happens when you try http://<computername>/reportserver from a client machine where computername is the name of the computer with SQL server?
That's the only way I had tried it. Should I be making computer name the name of the computer I happen to be on ? I didn't think that was the way it worked ?|||No, it should be the name of the computer on which SQL server resides. What is the error message you are getting?|||
Server Error in '/Reports' Application.
Failed to access IIS metabase.
I uninstalled SQL on the first machine i was trying it on ... and have now installed SQL on a new machine and I have run through the set up the same way I did before and I am getting this error now. I get this error when trying to connect from the server machine .. and when I try to connect from a client machine I get a page not found error in the browser
|||
Oh I see. I thought it was working on the server.
Check this forum: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=116989&SiteID=1
help with reporting services
I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.
Hi,
did you check your IIS configuration of your localhost (Tester)?
Is there an alias for your network computer - "Tester", DNS?
Have you put in a Hostheadername by IP?
What about a ping`?
Have you test http://172.../reports ?
CU
tosc
|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||Hi John,
by installation, have you check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?
Thanks,
John
|||Hi John,
NO, i'm referring to Installing and Configuring SQL Server Reporting Services!
Have yopu check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||Hi John,
Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.
Mike
|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.
However, when I try to access the report server from a different computer on the network I also get a
Internet Explorer cannot display the webpage
message.
I have tried:
http://rs_name/reports
http://rs_name.network.local/reports
http://rs_name/reports$sqlexpress
I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.
Many thanks.
Leslie
|||You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)
Mike
|||OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.
L
help with reporting services
I installed sql express with advanced services on a local network computer named 'Tester'. For service accounts I used 'network service' and 'mixed mode' for authentication. I would like to publish database reports using reporting services. when i open a web browser on the machine with sql express and type in the url: http://localhost/reports or http://localhost/reportserver the web pages work fine. but when i go to a different machine thats on the same network and use the url: http://Tester/reports or http://Tester/reportserver the web page is not found. how do i get users on the network to be able to view the virtual report server directories on the Tester computer? Help would be greatly appreciated.
Hi,
did you check your IIS configuration of your localhost (Tester)?
Is there an alias for your network computer - "Tester", DNS?
Have you put in a Hostheadername by IP?
What about a ping`?
Have you test http://172.../reports ?
CU
tosc
|||i can ping 'Tester' fine, i've tried http://<ip of host>/reports. IIS is configured for integrated windows autentication. I tried setting authentication to allow anonymous access but that didnt work either.|||Hi John,
by installation, have you check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||are you referring to the install of IIS? I dont recall, should I try to reinstall IIS?
Thanks,
John
|||Hi John,
NO, i'm referring to Installing and Configuring SQL Server Reporting Services!
Have yopu check "Use SSL..." checkbox in the installation wizard?
CU
tosc
|||Hi John,
Unless you changed it manually, Reporting Services is given an instance name just like the database service. Try adding "$SQLEXPRESS" (without quotes) to the end of your URL. Needless to say, if you installed to a different instance name, use that inplace of SQLEXPRESS.
Mike
|||I've tried all the url's and none of them work. Does IIS have to be configured in a particular way? also do I need to add permissions to my report server database? I would think that anyone on the intranet who knows the host computer name can put in the url and view the reportserver web page. Im not getting prompted for a login, my web browser just says the page cannot be displayed, that makes me think that it is network problem and not a configuration problem on the local machine.|||I have had similar troubles. I have a report server configured on a computer on the network. I've installed SQL Express 2005 and the toolkits to get hold of RS. The computer is running IIS 5 and is connected using MMC. Reports can be generated, deployed, and viewed using a browser and URL from this machine quite happily.
However, when I try to access the report server from a different computer on the network I also get a
Internet Explorer cannot display the webpage
message.
I have tried:
http://rs_name/reports
http://rs_name.network.local/reports
http://rs_name/reports$sqlexpress
I can ping the machines from eachother successfully and I have made profiles from within Report Manager for each user on these machines. Is this a Express thing? SURELY, you must be able to access these reports across a Windows network.
Many thanks.
Leslie
|||You sould ask this question in the Report Services forum to get a better answer. (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1)
Mike
|||OK. I'll ask them over there. Thank you very much, and apoligies for being in the wrong place.
L
Help With Report That Shows Late Sales Orders
Hello Everyone,
I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
reports is coming from a SQL 2000 EE database. All running on Server 2003.
I've been asked to create a report that shows all sales orders that are past
thier due date. I'm having some difficulty in coming up with a way to do this.
The table I'm pulling the information from is named oe_hdr (Order Entry
Header)
In the table there is a field named req_date (required date). This field is
used by the sales staff to enter in the date that the order is due to ship
from our facility. There is also a field named complete. This field is
checked when the order is invoiced, I think.
The sales staff wants a report that shows all orders that have not shipped
by thier due date.
Based on the info I've provided does anyone have an idea how I can make this
report. Maybe an expression or something. If this is not enough info, please
let me know.
Thanks.On May 7, 11:50 am, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Hello Everyone,
> I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> reports is coming from a SQL 2000 EE database. All running on Server 2003.
> I've been asked to create a report that shows all sales orders that are past
> thier due date. I'm having some difficulty in coming up with a way to do this.
> The table I'm pulling the information from is named oe_hdr (Order Entry
> Header)
> In the table there is a field named req_date (required date). This field is
> used by the sales staff to enter in the date that the order is due to ship
> from our facility. There is also a field named complete. This field is
> checked when the order is invoiced, I think.
> The sales staff wants a report that shows all orders that have not shipped
> by thier due date.
> Based on the info I've provided does anyone have an idea how I can make this
> report. Maybe an expression or something. If this is not enough info, please
> let me know.
> Thanks.
So you want the report to ONLY show late orders and nothing else?
Put a where clause that includes this:
select *
from oe_hdr
where getdate() >= req_date and complete = ?
I'm not sure what data is put into that complete field, but whatever
indicated that is it NOT complete, then it should be put where I
placed the question marks. The script will look for any orders where
the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
req_date and the order has not completed - therefore it is overdue.
I hope this helps. A helpful tip, it might be better for your
company's privacy to make up names for tables. You never know how
people may use your information.|||Thanks Ayman,
Since writing my query, I found this in Visual Studio help;
=IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
What this does is compare the value of the importantdate with todays date
and if the importandate is greater than a day old, it will format the date
font as red, otherwise blue. This gets me closer to what I'm looking for.
I'll massage this and see what i come up with. I will also give your
suggestion a go as well.
Thanks for the privacy info.
"Ayman" wrote:
> On May 7, 11:50 am, Damon Johnson
> <DamonJohn...@.discussions.microsoft.com> wrote:
> > Hello Everyone,
> > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> >
> > I've been asked to create a report that shows all sales orders that are past
> > thier due date. I'm having some difficulty in coming up with a way to do this.
> >
> > The table I'm pulling the information from is named oe_hdr (Order Entry
> > Header)
> > In the table there is a field named req_date (required date). This field is
> > used by the sales staff to enter in the date that the order is due to ship
> > from our facility. There is also a field named complete. This field is
> > checked when the order is invoiced, I think.
> >
> > The sales staff wants a report that shows all orders that have not shipped
> > by thier due date.
> >
> > Based on the info I've provided does anyone have an idea how I can make this
> > report. Maybe an expression or something. If this is not enough info, please
> > let me know.
> > Thanks.
> So you want the report to ONLY show late orders and nothing else?
> Put a where clause that includes this:
> select *
> from oe_hdr
> where getdate() >= req_date and complete = ?
> I'm not sure what data is put into that complete field, but whatever
> indicated that is it NOT complete, then it should be put where I
> placed the question marks. The script will look for any orders where
> the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> req_date and the order has not completed - therefore it is overdue.
> I hope this helps. A helpful tip, it might be better for your
> company's privacy to make up names for tables. You never know how
> people may use your information.
>|||On May 7, 12:25 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Thanks Ayman,
> Since writing my query, I found this in Visual Studio help;
> =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> What this does is compare the value of the importantdate with todays date
> and if the importandate is greater than a day old, it will format the date
> font as red, otherwise blue. This gets me closer to what I'm looking for.
> I'll massage this and see what i come up with. I will also give your
> suggestion a go as well.
> Thanks for the privacy info.
> "Ayman" wrote:
> > On May 7, 11:50 am, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Hello Everyone,
> > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > I've been asked to create a report that shows all sales orders that are past
> > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > Header)
> > > In the table there is a field named req_date (required date). This field is
> > > used by the sales staff to enter in the date that the order is due to ship
> > > from our facility. There is also a field named complete. This field is
> > > checked when the order is invoiced, I think.
> > > The sales staff wants a report that shows all orders that have not shipped
> > > by thier due date.
> > > Based on the info I've provided does anyone have an idea how I can make this
> > > report. Maybe an expression or something. If this is not enough info, please
> > > let me know.
> > > Thanks.
> > So you want the report to ONLY show late orders and nothing else?
> > Put a where clause that includes this:
> > select *
> > from oe_hdr
> > where getdate() >= req_date and complete = ?
> > I'm not sure what data is put into that complete field, but whatever
> > indicated that is it NOT complete, then it should be put where I
> > placed the question marks. The script will look for any orders where
> > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > req_date and the order has not completed - therefore it is overdue.
> > I hope this helps. A helpful tip, it might be better for your
> > company's privacy to make up names for tables. You never know how
> > people may use your information.
Thats a good way to show all the data and filter it by color. Hint:
you can put nicer colors by using their numbers like "#dedab5" in
place of red or blue. If you select the entire data row, then put
that IIF command in the background color box under properties. It will
make the entire row change color as opposed to one cell - usually
easier to see.|||Ayman,
Do you have any suggestions on how to use the Datediff in my query to pull
the reports that are a day late?
Thanks.
"Ayman" wrote:
> On May 7, 12:25 pm, Damon Johnson
> <DamonJohn...@.discussions.microsoft.com> wrote:
> > Thanks Ayman,
> > Since writing my query, I found this in Visual Studio help;
> >
> > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> >
> > What this does is compare the value of the importantdate with todays date
> > and if the importandate is greater than a day old, it will format the date
> > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > I'll massage this and see what i come up with. I will also give your
> > suggestion a go as well.
> >
> > Thanks for the privacy info.
> >
> > "Ayman" wrote:
> > > On May 7, 11:50 am, Damon Johnson
> > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > Hello Everyone,
> > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> >
> > > > I've been asked to create a report that shows all sales orders that are past
> > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> >
> > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > Header)
> > > > In the table there is a field named req_date (required date). This field is
> > > > used by the sales staff to enter in the date that the order is due to ship
> > > > from our facility. There is also a field named complete. This field is
> > > > checked when the order is invoiced, I think.
> >
> > > > The sales staff wants a report that shows all orders that have not shipped
> > > > by thier due date.
> >
> > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > report. Maybe an expression or something. If this is not enough info, please
> > > > let me know.
> > > > Thanks.
> >
> > > So you want the report to ONLY show late orders and nothing else?
> > > Put a where clause that includes this:
> > > select *
> > > from oe_hdr
> > > where getdate() >= req_date and complete = ?
> >
> > > I'm not sure what data is put into that complete field, but whatever
> > > indicated that is it NOT complete, then it should be put where I
> > > placed the question marks. The script will look for any orders where
> > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > req_date and the order has not completed - therefore it is overdue.
> >
> > > I hope this helps. A helpful tip, it might be better for your
> > > company's privacy to make up names for tables. You never know how
> > > people may use your information.
> Thats a good way to show all the data and filter it by color. Hint:
> you can put nicer colors by using their numbers like "#dedab5" in
> place of red or blue. If you select the entire data row, then put
> that IIF command in the background color box under properties. It will
> make the entire row change color as opposed to one cell - usually
> easier to see.
>|||On May 7, 1:26 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Ayman,
> Do you have any suggestions on how to use the Datediff in my query to pull
> the reports that are a day late?
> Thanks.
> "Ayman" wrote:
> > On May 7, 12:25 pm, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Thanks Ayman,
> > > Since writing my query, I found this in Visual Studio help;
> > > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> > > What this does is compare the value of the importantdate with todays date
> > > and if the importandate is greater than a day old, it will format the date
> > > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > > I'll massage this and see what i come up with. I will also give your
> > > suggestion a go as well.
> > > Thanks for the privacy info.
> > > "Ayman" wrote:
> > > > On May 7, 11:50 am, Damon Johnson
> > > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > > Hello Everyone,
> > > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > > > I've been asked to create a report that shows all sales orders that are past
> > > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > > Header)
> > > > > In the table there is a field named req_date (required date). This field is
> > > > > used by the sales staff to enter in the date that the order is due to ship
> > > > > from our facility. There is also a field named complete. This field is
> > > > > checked when the order is invoiced, I think.
> > > > > The sales staff wants a report that shows all orders that have not shipped
> > > > > by thier due date.
> > > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > > report. Maybe an expression or something. If this is not enough info, please
> > > > > let me know.
> > > > > Thanks.
> > > > So you want the report to ONLY show late orders and nothing else?
> > > > Put a where clause that includes this:
> > > > select *
> > > > from oe_hdr
> > > > where getdate() >= req_date and complete = ?
> > > > I'm not sure what data is put into that complete field, but whatever
> > > > indicated that is it NOT complete, then it should be put where I
> > > > placed the question marks. The script will look for any orders where
> > > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > > req_date and the order has not completed - therefore it is overdue.
> > > > I hope this helps. A helpful tip, it might be better for your
> > > > company's privacy to make up names for tables. You never know how
> > > > people may use your information.
> > Thats a good way to show all the data and filter it by color. Hint:
> > you can put nicer colors by using their numbers like "#dedab5" in
> > place of red or blue. If you select the entire data row, then put
> > that IIF command in the background color box under properties. It will
> > make the entire row change color as opposed to one cell - usually
> > easier to see.
try using Today() instead of now since it is a date function. The
Syntax seems correct just make sure you use it in the actual report
properties section. So select the entire row (not the titles, but
where the data is on your table/matrix) and press properties. Under
background color, select EXPRESSION and put in the expression. You
can use TRANSPARENT as the color that is used for orders that are not
late as opposed to BLUE. There is also a section about visibility
under properties but it's pretty tricky and I've wasted hours on it.
Fancy colors should impress the boss : D
Let me know how it works out, I have a suggestion for a case statement
if needed.|||On May 7, 1:26 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Ayman,
> Do you have any suggestions on how to use the Datediff in my query to pull
> the reports that are a day late?
> Thanks.
> "Ayman" wrote:
> > On May 7, 12:25 pm, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Thanks Ayman,
> > > Since writing my query, I found this in Visual Studio help;
> > > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> > > What this does is compare the value of the importantdate with todays date
> > > and if the importandate is greater than a day old, it will format the date
> > > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > > I'll massage this and see what i come up with. I will also give your
> > > suggestion a go as well.
> > > Thanks for the privacy info.
> > > "Ayman" wrote:
> > > > On May 7, 11:50 am, Damon Johnson
> > > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > > Hello Everyone,
> > > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > > > I've been asked to create a report that shows all sales orders that are past
> > > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > > Header)
> > > > > In the table there is a field named req_date (required date). This field is
> > > > > used by the sales staff to enter in the date that the order is due to ship
> > > > > from our facility. There is also a field named complete. This field is
> > > > > checked when the order is invoiced, I think.
> > > > > The sales staff wants a report that shows all orders that have not shipped
> > > > > by thier due date.
> > > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > > report. Maybe an expression or something. If this is not enough info, please
> > > > > let me know.
> > > > > Thanks.
> > > > So you want the report to ONLY show late orders and nothing else?
> > > > Put a where clause that includes this:
> > > > select *
> > > > from oe_hdr
> > > > where getdate() >= req_date and complete = ?
> > > > I'm not sure what data is put into that complete field, but whatever
> > > > indicated that is it NOT complete, then it should be put where I
> > > > placed the question marks. The script will look for any orders where
> > > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > > req_date and the order has not completed - therefore it is overdue.
> > > > I hope this helps. A helpful tip, it might be better for your
> > > > company's privacy to make up names for tables. You never know how
> > > > people may use your information.
> > Thats a good way to show all the data and filter it by color. Hint:
> > you can put nicer colors by using their numbers like "#dedab5" in
> > place of red or blue. If you select the entire data row, then put
> > that IIF command in the background color box under properties. It will
> > make the entire row change color as opposed to one cell - usually
> > easier to see.
try using Today() instead of now since it is a date function. The
Syntax seems correct just make sure you use it in the actual report
properties section. So select the entire row (not the titles, but
where the data is on your table/matrix) and press properties. Under
background color, select EXPRESSION and put in the expression. You
can use TRANSPARENT as the color that is used for orders that are not
late as opposed to BLUE. There is also a section about visibility
under properties but it's pretty tricky and I've wasted hours on it.
Fancy colors should impress the boss : D
Let me know how it works out, I have a suggestion for a case statement
if needed.sql
I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
reports is coming from a SQL 2000 EE database. All running on Server 2003.
I've been asked to create a report that shows all sales orders that are past
thier due date. I'm having some difficulty in coming up with a way to do this.
The table I'm pulling the information from is named oe_hdr (Order Entry
Header)
In the table there is a field named req_date (required date). This field is
used by the sales staff to enter in the date that the order is due to ship
from our facility. There is also a field named complete. This field is
checked when the order is invoiced, I think.
The sales staff wants a report that shows all orders that have not shipped
by thier due date.
Based on the info I've provided does anyone have an idea how I can make this
report. Maybe an expression or something. If this is not enough info, please
let me know.
Thanks.On May 7, 11:50 am, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Hello Everyone,
> I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> reports is coming from a SQL 2000 EE database. All running on Server 2003.
> I've been asked to create a report that shows all sales orders that are past
> thier due date. I'm having some difficulty in coming up with a way to do this.
> The table I'm pulling the information from is named oe_hdr (Order Entry
> Header)
> In the table there is a field named req_date (required date). This field is
> used by the sales staff to enter in the date that the order is due to ship
> from our facility. There is also a field named complete. This field is
> checked when the order is invoiced, I think.
> The sales staff wants a report that shows all orders that have not shipped
> by thier due date.
> Based on the info I've provided does anyone have an idea how I can make this
> report. Maybe an expression or something. If this is not enough info, please
> let me know.
> Thanks.
So you want the report to ONLY show late orders and nothing else?
Put a where clause that includes this:
select *
from oe_hdr
where getdate() >= req_date and complete = ?
I'm not sure what data is put into that complete field, but whatever
indicated that is it NOT complete, then it should be put where I
placed the question marks. The script will look for any orders where
the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
req_date and the order has not completed - therefore it is overdue.
I hope this helps. A helpful tip, it might be better for your
company's privacy to make up names for tables. You never know how
people may use your information.|||Thanks Ayman,
Since writing my query, I found this in Visual Studio help;
=IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
What this does is compare the value of the importantdate with todays date
and if the importandate is greater than a day old, it will format the date
font as red, otherwise blue. This gets me closer to what I'm looking for.
I'll massage this and see what i come up with. I will also give your
suggestion a go as well.
Thanks for the privacy info.
"Ayman" wrote:
> On May 7, 11:50 am, Damon Johnson
> <DamonJohn...@.discussions.microsoft.com> wrote:
> > Hello Everyone,
> > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> >
> > I've been asked to create a report that shows all sales orders that are past
> > thier due date. I'm having some difficulty in coming up with a way to do this.
> >
> > The table I'm pulling the information from is named oe_hdr (Order Entry
> > Header)
> > In the table there is a field named req_date (required date). This field is
> > used by the sales staff to enter in the date that the order is due to ship
> > from our facility. There is also a field named complete. This field is
> > checked when the order is invoiced, I think.
> >
> > The sales staff wants a report that shows all orders that have not shipped
> > by thier due date.
> >
> > Based on the info I've provided does anyone have an idea how I can make this
> > report. Maybe an expression or something. If this is not enough info, please
> > let me know.
> > Thanks.
> So you want the report to ONLY show late orders and nothing else?
> Put a where clause that includes this:
> select *
> from oe_hdr
> where getdate() >= req_date and complete = ?
> I'm not sure what data is put into that complete field, but whatever
> indicated that is it NOT complete, then it should be put where I
> placed the question marks. The script will look for any orders where
> the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> req_date and the order has not completed - therefore it is overdue.
> I hope this helps. A helpful tip, it might be better for your
> company's privacy to make up names for tables. You never know how
> people may use your information.
>|||On May 7, 12:25 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Thanks Ayman,
> Since writing my query, I found this in Visual Studio help;
> =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> What this does is compare the value of the importantdate with todays date
> and if the importandate is greater than a day old, it will format the date
> font as red, otherwise blue. This gets me closer to what I'm looking for.
> I'll massage this and see what i come up with. I will also give your
> suggestion a go as well.
> Thanks for the privacy info.
> "Ayman" wrote:
> > On May 7, 11:50 am, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Hello Everyone,
> > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > I've been asked to create a report that shows all sales orders that are past
> > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > Header)
> > > In the table there is a field named req_date (required date). This field is
> > > used by the sales staff to enter in the date that the order is due to ship
> > > from our facility. There is also a field named complete. This field is
> > > checked when the order is invoiced, I think.
> > > The sales staff wants a report that shows all orders that have not shipped
> > > by thier due date.
> > > Based on the info I've provided does anyone have an idea how I can make this
> > > report. Maybe an expression or something. If this is not enough info, please
> > > let me know.
> > > Thanks.
> > So you want the report to ONLY show late orders and nothing else?
> > Put a where clause that includes this:
> > select *
> > from oe_hdr
> > where getdate() >= req_date and complete = ?
> > I'm not sure what data is put into that complete field, but whatever
> > indicated that is it NOT complete, then it should be put where I
> > placed the question marks. The script will look for any orders where
> > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > req_date and the order has not completed - therefore it is overdue.
> > I hope this helps. A helpful tip, it might be better for your
> > company's privacy to make up names for tables. You never know how
> > people may use your information.
Thats a good way to show all the data and filter it by color. Hint:
you can put nicer colors by using their numbers like "#dedab5" in
place of red or blue. If you select the entire data row, then put
that IIF command in the background color box under properties. It will
make the entire row change color as opposed to one cell - usually
easier to see.|||Ayman,
Do you have any suggestions on how to use the Datediff in my query to pull
the reports that are a day late?
Thanks.
"Ayman" wrote:
> On May 7, 12:25 pm, Damon Johnson
> <DamonJohn...@.discussions.microsoft.com> wrote:
> > Thanks Ayman,
> > Since writing my query, I found this in Visual Studio help;
> >
> > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> >
> > What this does is compare the value of the importantdate with todays date
> > and if the importandate is greater than a day old, it will format the date
> > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > I'll massage this and see what i come up with. I will also give your
> > suggestion a go as well.
> >
> > Thanks for the privacy info.
> >
> > "Ayman" wrote:
> > > On May 7, 11:50 am, Damon Johnson
> > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > Hello Everyone,
> > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> >
> > > > I've been asked to create a report that shows all sales orders that are past
> > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> >
> > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > Header)
> > > > In the table there is a field named req_date (required date). This field is
> > > > used by the sales staff to enter in the date that the order is due to ship
> > > > from our facility. There is also a field named complete. This field is
> > > > checked when the order is invoiced, I think.
> >
> > > > The sales staff wants a report that shows all orders that have not shipped
> > > > by thier due date.
> >
> > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > report. Maybe an expression or something. If this is not enough info, please
> > > > let me know.
> > > > Thanks.
> >
> > > So you want the report to ONLY show late orders and nothing else?
> > > Put a where clause that includes this:
> > > select *
> > > from oe_hdr
> > > where getdate() >= req_date and complete = ?
> >
> > > I'm not sure what data is put into that complete field, but whatever
> > > indicated that is it NOT complete, then it should be put where I
> > > placed the question marks. The script will look for any orders where
> > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > req_date and the order has not completed - therefore it is overdue.
> >
> > > I hope this helps. A helpful tip, it might be better for your
> > > company's privacy to make up names for tables. You never know how
> > > people may use your information.
> Thats a good way to show all the data and filter it by color. Hint:
> you can put nicer colors by using their numbers like "#dedab5" in
> place of red or blue. If you select the entire data row, then put
> that IIF command in the background color box under properties. It will
> make the entire row change color as opposed to one cell - usually
> easier to see.
>|||On May 7, 1:26 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Ayman,
> Do you have any suggestions on how to use the Datediff in my query to pull
> the reports that are a day late?
> Thanks.
> "Ayman" wrote:
> > On May 7, 12:25 pm, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Thanks Ayman,
> > > Since writing my query, I found this in Visual Studio help;
> > > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> > > What this does is compare the value of the importantdate with todays date
> > > and if the importandate is greater than a day old, it will format the date
> > > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > > I'll massage this and see what i come up with. I will also give your
> > > suggestion a go as well.
> > > Thanks for the privacy info.
> > > "Ayman" wrote:
> > > > On May 7, 11:50 am, Damon Johnson
> > > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > > Hello Everyone,
> > > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > > > I've been asked to create a report that shows all sales orders that are past
> > > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > > Header)
> > > > > In the table there is a field named req_date (required date). This field is
> > > > > used by the sales staff to enter in the date that the order is due to ship
> > > > > from our facility. There is also a field named complete. This field is
> > > > > checked when the order is invoiced, I think.
> > > > > The sales staff wants a report that shows all orders that have not shipped
> > > > > by thier due date.
> > > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > > report. Maybe an expression or something. If this is not enough info, please
> > > > > let me know.
> > > > > Thanks.
> > > > So you want the report to ONLY show late orders and nothing else?
> > > > Put a where clause that includes this:
> > > > select *
> > > > from oe_hdr
> > > > where getdate() >= req_date and complete = ?
> > > > I'm not sure what data is put into that complete field, but whatever
> > > > indicated that is it NOT complete, then it should be put where I
> > > > placed the question marks. The script will look for any orders where
> > > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > > req_date and the order has not completed - therefore it is overdue.
> > > > I hope this helps. A helpful tip, it might be better for your
> > > > company's privacy to make up names for tables. You never know how
> > > > people may use your information.
> > Thats a good way to show all the data and filter it by color. Hint:
> > you can put nicer colors by using their numbers like "#dedab5" in
> > place of red or blue. If you select the entire data row, then put
> > that IIF command in the background color box under properties. It will
> > make the entire row change color as opposed to one cell - usually
> > easier to see.
try using Today() instead of now since it is a date function. The
Syntax seems correct just make sure you use it in the actual report
properties section. So select the entire row (not the titles, but
where the data is on your table/matrix) and press properties. Under
background color, select EXPRESSION and put in the expression. You
can use TRANSPARENT as the color that is used for orders that are not
late as opposed to BLUE. There is also a section about visibility
under properties but it's pretty tricky and I've wasted hours on it.
Fancy colors should impress the boss : D
Let me know how it works out, I have a suggestion for a case statement
if needed.|||On May 7, 1:26 pm, Damon Johnson
<DamonJohn...@.discussions.microsoft.com> wrote:
> Ayman,
> Do you have any suggestions on how to use the Datediff in my query to pull
> the reports that are a day late?
> Thanks.
> "Ayman" wrote:
> > On May 7, 12:25 pm, Damon Johnson
> > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > Thanks Ayman,
> > > Since writing my query, I found this in Visual Studio help;
> > > =IIF(DateDiff("d",Fields!ImportantDate.Value, Now())>1,"Red","Blue")
> > > What this does is compare the value of the importantdate with todays date
> > > and if the importandate is greater than a day old, it will format the date
> > > font as red, otherwise blue. This gets me closer to what I'm looking for.
> > > I'll massage this and see what i come up with. I will also give your
> > > suggestion a go as well.
> > > Thanks for the privacy info.
> > > "Ayman" wrote:
> > > > On May 7, 11:50 am, Damon Johnson
> > > > <DamonJohn...@.discussions.microsoft.com> wrote:
> > > > > Hello Everyone,
> > > > > I'm running SQL Server Reporting Services on SQL2005 SE. The data for the
> > > > > reports is coming from a SQL 2000 EE database. All running on Server 2003.
> > > > > I've been asked to create a report that shows all sales orders that are past
> > > > > thier due date. I'm having some difficulty in coming up with a way to do this.
> > > > > The table I'm pulling the information from is named oe_hdr (Order Entry
> > > > > Header)
> > > > > In the table there is a field named req_date (required date). This field is
> > > > > used by the sales staff to enter in the date that the order is due to ship
> > > > > from our facility. There is also a field named complete. This field is
> > > > > checked when the order is invoiced, I think.
> > > > > The sales staff wants a report that shows all orders that have not shipped
> > > > > by thier due date.
> > > > > Based on the info I've provided does anyone have an idea how I can make this
> > > > > report. Maybe an expression or something. If this is not enough info, please
> > > > > let me know.
> > > > > Thanks.
> > > > So you want the report to ONLY show late orders and nothing else?
> > > > Put a where clause that includes this:
> > > > select *
> > > > from oe_hdr
> > > > where getdate() >= req_date and complete = ?
> > > > I'm not sure what data is put into that complete field, but whatever
> > > > indicated that is it NOT complete, then it should be put where I
> > > > placed the question marks. The script will look for any orders where
> > > > the getdate() [THIS IS TODAY'S DATE] is greater than or equal to the
> > > > req_date and the order has not completed - therefore it is overdue.
> > > > I hope this helps. A helpful tip, it might be better for your
> > > > company's privacy to make up names for tables. You never know how
> > > > people may use your information.
> > Thats a good way to show all the data and filter it by color. Hint:
> > you can put nicer colors by using their numbers like "#dedab5" in
> > place of red or blue. If you select the entire data row, then put
> > that IIF command in the background color box under properties. It will
> > make the entire row change color as opposed to one cell - usually
> > easier to see.
try using Today() instead of now since it is a date function. The
Syntax seems correct just make sure you use it in the actual report
properties section. So select the entire row (not the titles, but
where the data is on your table/matrix) and press properties. Under
background color, select EXPRESSION and put in the expression. You
can use TRANSPARENT as the color that is used for orders that are not
late as opposed to BLUE. There is also a section about visibility
under properties but it's pretty tricky and I've wasted hours on it.
Fancy colors should impress the boss : D
Let me know how it works out, I have a suggestion for a case statement
if needed.sql
Friday, February 24, 2012
Help with LinkTarget
I am trying to access the Employee Summary Report in reporting services examples using URL access.
I want to open the sub-reports in this report to be opened in a different window.
Here is the url I am using
http://ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fEmployee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
I was assuming that when I click the sub-report it will open in a browser since the LinkTargete is to _blank.
Please let me know why this is not working .
Thanks!!
SqlNew
The LinkTarget device setting is for the links inside the report, e.g. for drilling down. Instead, consider a javascript code:
=void(window.open('http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
|||Hi,
thanks for the information. I trying to using this asp.net web application where i am building the url dynamically and passing it to a iframe. when i click on the report it opens in the iframe and when i click on the subreport i want subreport to open in a new browser.
thanks
SqlNew
|||So the main report is loading in an iframe, correct? By subreport I assume you mean a drillthrough report which is displayed after the user clicks on a hyperlink on the main report, correct? If so, the LinkTarget should open up in a new window. Note that your URL link is wrong. It should be:
http://<machinename>/ReportServer?/AdventureWorks Sample Reports/Employee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
If still no new window, try the javascript approach.
|||Hello Teo Lachev,
I corrected the URL still i am not able to open the subreport in a new window. I tried setting the src of the iframe with the javascript I get a page cannot be displayed error.
here is the src set to the iframe.
src='javascript:void(window.open('http://<machinename>/ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fTerritory Sales Drilldown&rs:Command=Render&rc:LinkTarget=_blank','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))'
this is set in a method is side the code of asp,net page as follows where GETURL is the method which builds the url.
String ifrDis= "";
ifrDis += "<iframe width=100% height=800px frameborder=0 scrolling=no id='if_displayreport' marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" style=\"overflow=hidden;\" src='http://pics.10026.com/?src= ";
ifrDis += void(window.open('" + GETURL() + "','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))' ";
ifrDis += " runat=server/>";
disArea.InnerHtml = ifrDis;
Please let me know if i am missing something.
Thanks!!
SqlNew
|||Again, the URL is wrong. Should be
http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary
Open up IE and make sure that the URL works.
|||hello,
I think I typed the URL wrong, I am able to open the report from IE but this happens when i set the url for the iframe.
thanks!!
|||I have spent some time trying to figure out what was wrong, and basically it would appear that, if your iFrame has ANY style information (through the style attribute or stylesheet) then IE will NOT obey the LinkTarget.My solution is place the iFrame within a DIV tag if you need to apply any style information.
It is absolutely shocking that something like this breaks it, but that's the IE we know and love/hate.
Help with LinkTarget
I am trying to access the Employee Summary Report in reporting services examples using URL access.
I want to open the sub-reports in this report to be opened in a different window.
Here is the url I am using
http://ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fEmployee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
I was assuming that when I click the sub-report it will open in a browser since the LinkTargete is to _blank.
Please let me know why this is not working .
Thanks!!
SqlNew
The LinkTarget device setting is for the links inside the report, e.g. for drilling down. Instead, consider a javascript code:
=void(window.open('http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
|||Hi,
thanks for the information. I trying to using this asp.net web application where i am building the url dynamically and passing it to a iframe. when i click on the report it opens in the iframe and when i click on the subreport i want subreport to open in a new browser.
thanks
SqlNew
|||So the main report is loading in an iframe, correct? By subreport I assume you mean a drillthrough report which is displayed after the user clicks on a hyperlink on the main report, correct? If so, the LinkTarget should open up in a new window. Note that your URL link is wrong. It should be:
http://<machinename>/ReportServer?/AdventureWorks Sample Reports/Employee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
If still no new window, try the javascript approach.
|||Hello Teo Lachev,
I corrected the URL still i am not able to open the subreport in a new window. I tried setting the src of the iframe with the javascript I get a page cannot be displayed error.
here is the src set to the iframe.
src='javascript:void(window.open('http://<machinename>/ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fTerritory Sales Drilldown&rs:Command=Render&rc:LinkTarget=_blank','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))'
this is set in a method is side the code of asp,net page as follows where GETURL is the method which builds the url.
String ifrDis= "";
ifrDis += "<iframe width=100% height=800px frameborder=0 scrolling=no id='if_displayreport' marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" style=\"overflow=hidden;\" src='http://pics.10026.com/?src= ";
ifrDis += void(window.open('" + GETURL() + "','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))' ";
ifrDis += " runat=server/>";
disArea.InnerHtml = ifrDis;
Please let me know if i am missing something.
Thanks!!
SqlNew
|||Again, the URL is wrong. Should be
http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary
Open up IE and make sure that the URL works.
|||hello,
I think I typed the URL wrong, I am able to open the report from IE but this happens when i set the url for the iframe.
thanks!!
|||I have spent some time trying to figure out what was wrong, and basically it would appear that, if your iFrame has ANY style information (through the style attribute or stylesheet) then IE will NOT obey the LinkTarget.My solution is place the iFrame within a DIV tag if you need to apply any style information.
It is absolutely shocking that something like this breaks it, but that's the IE we know and love/hate.
Help with LinkTarget
I am trying to access the Employee Summary Report in reporting services examples using URL access.
I want to open the sub-reports in this report to be opened in a different window.
Here is the url I am using
http://ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fEmployee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
I was assuming that when I click the sub-report it will open in a browser since the LinkTargete is to _blank.
Please let me know why this is not working .
Thanks!!
SqlNew
The LinkTarget device setting is for the links inside the report, e.g. for drilling down. Instead, consider a javascript code:
=void(window.open('http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))"
|||Hi,
thanks for the information. I trying to using this asp.net web application where i am building the url dynamically and passing it to a iframe. when i click on the report it opens in the iframe and when i click on the subreport i want subreport to open in a new browser.
thanks
SqlNew
|||So the main report is loading in an iframe, correct? By subreport I assume you mean a drillthrough report which is displayed after the user clicks on a hyperlink on the main report, correct? If so, the LinkTarget should open up in a new window. Note that your URL link is wrong. It should be:
http://<machinename>/ReportServer?/AdventureWorks Sample Reports/Employee Sales Summary&rs:Command=Render&rc:LinkTarget=_blank
If still no new window, try the javascript approach.
|||Hello Teo Lachev,
I corrected the URL still i am not able to open the subreport in a new window. I tried setting the src of the iframe with the javascript I get a page cannot be displayed error.
here is the src set to the iframe.
src='javascript:void(window.open('http://<machinename>/ReportServer/ReportService2005.asmx/?%2fAdventureWorks Sample Reports%2fTerritory Sales Drilldown&rs:Command=Render&rc:LinkTarget=_blank','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))'
this is set in a method is side the code of asp,net page as follows where GETURL is the method which builds the url.
String ifrDis= "";
ifrDis += "<iframe width=100% height=800px frameborder=0 scrolling=no id='if_displayreport' marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" style=\"overflow=hidden;\" src='http://pics.10026.com/?src= ";
ifrDis += void(window.open('" + GETURL() + "','_blank', 'location=no,toolbar=no,left=100,top=100,height=600,width=800'))' ";
ifrDis += " runat=server/>";
disArea.InnerHtml = ifrDis;
Please let me know if i am missing something.
Thanks!!
SqlNew
|||Again, the URL is wrong. Should be
http://localhost/ReportServer?/Adventure Works Sample Reports/Employee Sales Summary
Open up IE and make sure that the URL works.
|||hello,
I think I typed the URL wrong, I am able to open the report from IE but this happens when i set the url for the iframe.
thanks!!
|||I have spent some time trying to figure out what was wrong, and basically it would appear that, if your iFrame has ANY style information (through the style attribute or stylesheet) then IE will NOT obey the LinkTarget.My solution is place the iFrame within a DIV tag if you need to apply any style information.
It is absolutely shocking that something like this breaks it, but that's the IE we know and love/hate.
Subscribe to:
Posts (Atom)