I am converting from 2005 to 2008 and have a report that does the following and is not working:
1. User selects a parameter denoting how they'd like to view the report (B or R values).
2. If "B" then hide the top group and show the second group and allow expanding into groups 3,4
3. If "R" show...
Is there any huge issue with the following SQL? This should be getting timesheets for only one week and it is a DOG!!
select s.surname + ', ' + s.forename EmpName
,b.businessunit BusinessUnit
,r.region Region
,case when isnull(c.firstname,'') = '' then c.searchname else c.searchname + '...
I'm trying to create a report that shows the performance of each, but getting some results that I'm not sure are correct. Please review my statement to see if I'm manipulating the milliseconds appropriately. Thanks!
LEFT('0' + convert(char, CONVERT(int,(x.TimeRendering/3600000) % 24)),2) + ':'...
Is it possible to read the report definition of where it is grabbing data from, from the Reports database?
All of our reports are based on stored procedures and it would be nice to be able to query that database to see all stored procedures in use.
any ideas? Thanks.
We have Transactional Replication pushing data to our Reporting Database once a day.
I am thinking of putting a trigger on one of the tables that gets hit by the replication. WHat the trigger would do would be to insert the ID of the table into another table. Basically, showing me all the IDs...
I have two databases. A production and a reporting db. The reporting db gets a transactional snapshot applied to it nightly for many tables.
An example is tblWIP.
Is it possible to pull the wipIDs that were updated by that snapshot and put them into a db table or access them in some way?
Thanks!
I have a report that has two images on it. One is set to the report background (no repeat) and the other is just in an image control listed as External source referencing an image in the project.
When I bring up the report everything looks fine, however, when I use an interactive sort, both...
I just installed a font to my computer and rebooted. However, VS 2005 is not recognizing the new font in any of it's font drop downs.
Any idea how to get this working?
Thanks!
I'm trying to find a document online that shows all of the new features within SQL Server 2005 T-SQL...anyone have this?
Thanks.
"...your mom goes to college..."
Can someone help me determine what the values are for the below 3 variables?
$server_pos = preg_replace('/^(.+?:\/\/)(.+)$/i','$2','http://www.mydomain.org');
$server_pos_base = preg_replace('/^(.+?)\/.+$/i','$1',$server_pos);
$server_pos_flag = preg_replace('/^.+?(\/.+)$/i','$1',$server_pos)...
I'd like my link to show <> symbols on hover and then remove them on mouse out...
here's what I have so far.
onmouseover="this.innerText= '< ' + this.innerText + ' >';"
onmouseout="this.innerText = replace(' >', replace('< ',this.innerText));"
"...your mom goes to college..."
I am looking to use an asp.net regular expression validation control on a text box. I would like to allow any character in the box, but a length of 0 to 200.
Ideas?
Thanks.
"...your mom goes to college..."
Just started getting this error after the application has been working for 7 months. The application reads and writes to a file server under an account that has access to the specific location. Any ideas?
Server Error in '/Workflow.NET.Prod/AuditLock' Application...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.