Search results for query: *

I'm using this syntax in a Where statement in my sp in SQL 2008. I run my sp in SQL and there is data for this particular field. However, when I access this sp this one field is BLANK in Crystal Report. I doesn't even acknowledge the datatype. I know in CR it uses dateadd('yyyy',-1,@MyDate)...

I am running SQL Server 2012. The stored procedures I'm trying to use in Report Builder 3.0 run successfully within Enterprise Manager and use these with SAP Crystal Reports 2013 without issue. When I choose the sp within the Table/Matrix wizard, it doesn't list ANY fields. I've tried the SET...

I have SQL Server 2012 with SP 2 and Report Builder 3.0. I've created a shared data source in Report Manager, then created a shared dataset in Report Builder and saved into Report Manager. I can see the shared dataset in Report Manager and it does show the data source under dependencies as...

I have a stored procedure with a parameter called #Days so depending on how many days you enter when running the report, the table will be updated with different values. For example, if I enter 10 as the parameter, the end columns of the table will be +1 Wed Nov 26, +2 Thur Nov 27 up to +10 Fri...

I have never taken our production databases offline to do weekly maintenance as it occurs when no one is using the applciations that access the databases and all the maintenance runs without issues. I'm now being questioned why they are not all taken offline to perform the maintenance. I run...

I have a table like the following: Code Qty CODE1 12 CODE2 5 CODE3 10 What I need to do is create x amount of unique rows for each code where x is the quantity by an incremeting value. The value I could actually do manually with exporting the results to excel, so I somehow need...

I'm simply trying to delete a database from SQL 2012 manangement studio by right-clicking and selecting delete. I have waited over 10 minutes then had to end task. I tried this directly on the server itself and same thing. In 2008 it took seconds. Why is this not working?

I know that it's not supported but it was working fine before I formatted my laptop and reinstall Windows. It doesn't matter what the default report location is (locally etc.) I cannot click Open (nothing happens), I just created a new report and cannot save, save as. Nothing happens. I see...

I have been looking up help (useless in SQL 2012) and googling for days yet cannot find one good article to explain how to interpret sql profile traces. It took a while to find out that on SQL 2012 the duration is milli and not micro seconds. Say I have a query that shows 12353 as the...

This doesn't happen after I log off or reboot. It happens after an hour or so passes. I have manually changed my security > internet settings multiple times today and they keep reverting back to default. I even changed ever level to medium, yet an hour or so later, I can't download, no active...

I exported the 3 packages that were setup in SQL 2005 and imported them into my new SQL 2012 server. The datasources on the package are still referencing the old server but I'm unable to edit them within the job in sql server. I don't have Visual Studio. Is that the only way to make a data...

I've migrated to a new SQL server 2012 from SQL 2005 then upgraded to Dynamics 2013. I used to be able to run a script against the SY01400 table to blank out the passwords, which forces the user to input a new one. Is that not possible anymore? Having to log into Dynamics as sa then manually...

I shouldn't have upgraded to IE10 as I had so many issues with Flash, so removed it and went back to IE9. IE9 was acting up all over the place so removed that so I could reinstall clean. Now I'm stuck on IE 8 and cannot get back to IE. Have tried the manual download and run as admin. Tried...

On SQL Server 2005 everything was SQL_Latin1_General_CP1_CI_AS. When I installed SQL 2012 Standard, I thought I had chosen the same collation but installed as Latin1_General_CI_AS. All of our databases that I migaated over (detach, attach, then change to 2012) are still...

I've created the following variable so that it takes the value of a group header as the startqty, then subtracts for each detail, which works great. However, if the group header is say 100 and the detail is 150, I don't want it to show -50 but rather stop when it meets the group header value...

I have Dreamweaver CS5 installed. I just downloaded Fireworks CS6. Every tutorial I see says choose "Commands/Create Web Photo Album" but it's not there. Can I not use Dreamweaver if FW is installed?

I've uninstalled and reinstalled but everytime I try and configure the Outlook client after enter the user's ID and password and it begins the installation at the "Microsoft Dynamics CRM for Outlook Installation" Update component registration it hangs. Waited over an hour once but it never...

I have a main report with 2 parameters, each of which allow multiple values. I started with NO parameters on the single subreport and allowed CR to create them for me (chose parameter, inserted to the right, new parameter created at bottom, then it picked the correct field to link). When I...

I have SAP CR engine 13.0.5.891. When a view a report with text that is set to wrap, it overlaps text below it. When viewed within the CR Designer, it appears fine. When it's exported to a pdf from the viewer, it's fine, but we don't want to have to export each report just to see the text...

This used to work but has stopped working over the past month or so. I've been able to replicate the issue with my CRM user (full admin) so it's not any sort of CRM access/rights issue. I've also replicated the issue using the webclient on the same workstation using 2 different windows...