Viewing 15 posts - 76 through 90 (of 96 total)
I am the "newbie" in my group (I have worked here almost 3 years!). I have run into situations where I ask why a certain technique is used and...
May 21, 2014 at 8:23 am
I have learned that when you consider a job opportunity, you really need to consider how your personality will fit in with the culture of the workplace.
I took a job...
May 16, 2014 at 8:22 am
The database I was running against has SQL 2000 compatibility. So I had to change the insert statements to use Selects and Unions....
Oh I just figured it out. I...
May 9, 2014 at 12:18 pm
I changed A and B to temp tables and ran this. It returned 5 rows.
How do you get 8 rows for the answer? :unsure:
May 9, 2014 at 8:17 am
I use an Exec SQL task. Create a data source that connects to msdb and use the system stored procedure dbo.sp_send_dbmail
Here is the TechNet article describing it:
May 5, 2014 at 7:26 am
What web browser are you using?
Reporting Services doesn't play nice with Google Chrome. It needs to use Internet Explorer.
May 1, 2014 at 9:09 am
I would recommend splitting it up. We have many models and use different models for different reports.
April 30, 2014 at 8:11 am
The website for Health and Human Services will have a lot of the info you need.
http://www.hhs.gov/ocr/privacy/index.html
There is an FAQ with information about your question:
http://www.hhs.gov/ocr/privacy/hipaa/faq/health_information_technology/index.html
another good resource is:
April 22, 2014 at 8:35 am
Hi Sharon,
What do you mean by lookup? Is it another dataset, table on the report, a parameter?
Sarah
March 14, 2014 at 8:40 am
Hi Karen,
Create a parameter called @updatetxt.
Then in your query, changed the like statement to this:
and updatetxt like '%' + @updatetxt + '%'
See if that works.
Sarah
March 13, 2014 at 10:27 am
What is the code behind the Airport dataset?
It should be something like:
Select Airport_Code, Airport_Name
from Airport
where @Option = 'Airport'
See if that works.
Sarah
March 13, 2014 at 10:00 am
Hi Mark,
We need more information in order to help you. Will you post your query and also a print screen of your dataset?
Thanks,
Sarah
November 19, 2013 at 8:50 am
You can undo when you go back to the Design tab.
Here is a post about how you can set it not to save. Next time try Google....
November 18, 2013 at 9:00 am
There is not a way to relate 2 tablixes.
An option is to use subreports. For more info, check out these sites:
http://technet.microsoft.com/en-us/library/ms160348(v=sql.100).aspx
http://www.youtube.com/watch?v=k_V4lam_5I0
http://technet.microsoft.com/en-us/library/ms160348(v=sql.100).aspx
On the subreport, create a parameter for...
October 9, 2013 at 1:13 pm
When you create a report in the designer and add a group, it creates a column on the left that merges all the rows together.
Delete that column. It won't...
October 2, 2013 at 8:16 am
Viewing 15 posts - 76 through 90 (of 96 total)