Recommendations Reporting Services 2008
Can anyone give me their recommendations on what manual to get to learn SSRS
2008? - I am between a beginner and intermediate in writing SQL queries.
Your response is appreciated. Thanks
Message posted via SQLMonster.com
On Tue, 27 Apr 2010 18:59:41 GMT, "Chamark via SQLMonster.com"
>Can anyone give me their recommendations on what manual to get to learn SSRS
>2008? - I am between a beginner and intermediate in writing SQL queries.
>Your response is appr...extra pages on reports
I have the same issue with 2 reports that I have created. They both have
sub-reports attached to them. The problem is that each report has a blank
page in addition to the report. How can I delete the blank page from the
report format? Any help would be appreciated.
...Drilldown.htm page size
I have created a custom button to show this page. I would like the page to
be full screen, rather than just fitting into RMS window. I can do this by
selecting 'internal html window' when creating the custom button. But when i
do this, the page does not work.
Can anybody help me in making the page bigger.
This page needs to be loaded in the transaction screen as you found out. The
only way of making this bigger is by making everything else smaller. i.e.
Custom Buttons, Function Keys and the Status Bar. To do this you need to
press Shift+F6 click on the Transa...Cant send urls, pages
Just upgraded from 2002 to 2003. Now I can not send interesting websites to friends, associates, or send links the way I used to. I went in and adjusted several security levels to no avail.
It is probably something simple but I am not seeing it
Katmido <email@example.com> wrote:
> Just upgraded from 2002 to 2003. Now I can not send interesting
> websites to friends, associates, or send links the way I used to. I
> went in and adjusted several security levels to no avail.
Include the URL in a plain text message and it will get through. Don...Background color on a tab page with XP theme
I have a dialog with a tab control on it. Tab pages are created from dialog
resources. When the tab control displays, the tabs are "white" and the
background of the tab pages is the COLOR_BTNFACE color. When I call
EnableThemeDialogTexture for the dialog page object, now the background of
the dialog appears to be "white" while the tab page has a white gradient
getting darker toward the bottom. This leaves an outline around where my
dialog resource is being displayed. How do I get the gradient to come out
right? Do I need to call DrawThemeBackground on the page?...Lopsided report
I am trying to create a report which has Cash Contributors on one side of the
page with In-Kind Contributors on the other side of the page !! (Side by side
I have all the information i need in the same query.
If I create a single report, I get the lopsided effect. One group of
contributors is higher than the other, leaving blank spaces above one side.
I tried creating a report with a sub report. I used the MonthYear as the
link, as I could find no other common ground. Doing that, I have encounter
two errors, the filter (I used a form filter with the MonthYear as the
filter...Page Break in Access Report
How do I get rid of the last page break in a report? The last page of my
report is always followed by a blank page.
How many pages is your report? If it is normally only one page, then the
last page would be page 2. One possible cause of this symptom is having a
report that is too wide. For example, if you are printing Portrait, on 8 1/2"
X 11" paper, the following applies:
8.5 <= Left Margin + Report Width + Right Margin
If your report is more than one page of data, and the sum of the above
three settings is greater than 8.5 inches, then the classic sympto...Code Page problem in SetWindowText
This is a multi-part message in MIME format.
I've created a MFC project in MBCS. I need to show some set special =
characters ( ASCII code > 128) in a CStatic controls. It shows correctly =
in all English locale window. However all those special character =
becames "?" in non-English window. How to solve this problem? Here's =
part of my source code
Ze...Errors exist in the page of http://runonce.msn.com/runonce3.aspx
So i can't save my options. When i open the IE browse, it will always pop up
Always state your full Windows version (e.g., WinXP SP3; WinXP 64-bit SP2;
Vista SP1; Vista 64-bit SP2; Win7; Win7 64-bit) as well as your IE version
when posting in an IE-specific forum or newsgroup. Please do so in your next
What anti-virus application or security suite is installed and is your
subscription current? What anti-spyware applications (other than Defender)?
What third-party firewall (if any)? Were any of these applications running
in the background when you inst...Page Numbering #17
I'm working on my first newsletter using Publisher 2003. It is going well,
but I have a confusing problem with page numbering. The newsletter is four
pages long. I took the original page numbers off, and made new text boxes
for the title and page #. Page 1 is fine (and not numbered) Page 4 is fine.
But page 2 and 3 keep changing back and forth. If I save page 2, page 3
becomes page 2 also. Same if I save page 3 - page 2 changes back to page 3.
I've tried everythinig I can think of. Any ideas? Thanks
You are changing the Master page, by doing so you are ...Converting from page-layout program to Word
I'm using Microsoft Office Word 2003.
I have a document that was formatted for some ancient page-layout program
that won't even run under Windows XP, so I'd like to put it all into Word.
It's currently in a tag-style format; for example, to italicize some section,
it needs surrounding tags, like this:
<W0I>Passage to be italicized.<D>
The document is huge, so I need to use Replace all to turn all of these into
italics in Word. Is there a way to turn such passages, wherever they occur,
into italicized text in Word, dropping the tags on either sid...Form Information to Report
I'm hoping someone can help me with this.
First of all, i created a form with multiply text boxes with complex
calculations in each text box. When you move from one record to another
record, each text box will change due to the calculation.
Now what i need to do is to create a separate report for each record. I
started creating a report by copying and pasting the text boxes from the
form to report in design mode. If at anytime the calculation changes, i don't
want to change the calculation on the form and also on the report. (to much
of chance of forgetting to change bo...Fiscal Year settings and reporting
This is a multi-part message in MIME format.
I know that Fiscal year settings are once and for all. No changes can =
take place in it. Is it possible to set the period to monthly and then =
roll up by quarter? Can we generate quarterly reports if we select =
Thanks any help is appreciated....
Content-Transfe...Print multiple pages per Sheet in Excel 2003
I have a spreadsheet with 12 rows that goes for many columns ( with formulas).
Is there a way to print this where three pages are on each piece of paper?
How about inserting a new worksheet, then copying and pasting (as values) to
that new sheet. Then print that "helper" worksheet.
If you have to do this lots, this may be worth the trouble.
Insert a new sheet.
select a nice range on the original sheet
go to the new worksheet
shift-edit|Paste picture link
Repeat so that you have pictures of the ranges so it prints the way you want.
Then print this helper worksheet.
Th...Table fields not appearing in report writer
I have created an add-in app for GP. With the app are reports. When I go
into Great Plains in the Report Writer and modify the report I need to create
a relationship with existing GP tables. When I am in the Report Writer and I
choose the MY table and look at the table, I can see all the fields.
When I go to create a relationship, I click the Relationship button, select
Great Plains for the product, select the table I want and choose the index.
In the portion of the form where you associate one field with another, the
secondard table (GP) shows the fields that are in the index. H...Conditional Printing of Certain Fields in A Report
i need to have a conditional printing of some fields (SEE BELOW)
VENDOR SHARE $999.99
LESS TAX $999.99
tax (%) 20%
AMT DUE $999.99
how do I print only these 5 lines when the tax amount is not zero.
Also how do i combine line 2,3 & 4 and looks like
LESS ENGLAND (20%) TAX
I tried doing the following:
="LESS" & [COUNTRY] &"(" &[TAX (%)] &")"
in the control source but i got a #ERROR error
Any help would be appreciated.
Kevin T <Kevin T@discussions.microsoft.com> wrote:
>i need to...How can I count unique values in a query in the report footer
Am using Access 2003
I have a report that gives me the count of the status of individuals . This
works fine as long is there is only one record in the query (in my query
there is one record per month). When I query 12 months (individuals may
appear in various months) it counts each record of an individual. For
Example in a query considering 12 months for a widow Jones it may count her
12 times and for a survivor named Smith may count her 8 times:
I would like to add a count in the report footer that will tell me how many
unique individuals I have in the repo...VBA to create series of workbooks need to add code to skip creating a report if no lines meet criteria
I need some assistance as where I'm at with this report is far beyond
my level of knowledge and I'm hoping that someone can point me in the
I've created a template that creates a report and displays variances
based on the "search criteria" which is defined in another worksheet
and hides any rows that are equal to Zero and are between the value
(>= -5000 AND <= +5000) and what I'm trying to figure out is if there
are no rows visible within the report then it should not save the
report (that way I don't email a blank works...Excel worksheet saved as web page--trouble printing
I have an worksheet that uses a graphic for a background, which I hav
also saved in HTML using the Save as a Web Page option. The web pag
looks great--but just like the excel background graphic, th
"background" graphic in the webpage won't print out for me.
Is there any way to fix this so that the graphic will print when
print the web page?
Message posted from http://www.ExcelForum.com
check the background printing options within the tools,
options menu and also the printer properties.
hope that helped.
>I have an workshee...Import data from a web page
I've read the suggestions about this topic and none of them work. The only
thing I am able to do is manually copy and paste data from a website to my
Excel worksheet. In the past, with the previous version of Excel I had a web
query that worked but now I just get an error message that says the query
retrieved no data. Following the instructions in the error message window
yields no results.
Has anyone else had this problem and arrived at a solution?
What version of Excel, previous version is not descriptive of what
you had what you have now. And it possibly does not matter.
In...Report not functionning in Money 2007
I just finished the upgrade from Money 2004 to Money 2007. Everything went
fine except that the Report function no longer work. Every time i try to
get a report, the "Loading" stays there forever and nothing happen.
Does someone has a clue of what is happening ?
I am using Money 2006 was also experiencing the problem you described where
I would attempt to generate a report, would get the pie chart and then the
"Loading" message and nothing would happen. I converted over from Quicken in
2005. I was only experiencing this problem when I tr...Characters not displaying in Reports
Hi I have a problem where certain characters are not displaying when i print
An example of the characters would be:
which when they are printed within the report come out as:
Is there any reason for it doing this?
Is there any way to get the report to display these characters?
The reason I would like the characters displayed is due to the Romanian
language using some of those said characters.
"Are you sick" becomes "eşti tu bolnav?" where the 'ş' is displayed as '?'
Thank you very much in advance
If this is just...Exporting CRM Reports Gives Error
Whenever I try to export or print any CRM reports I recieve the following
Error: ix is undefined
I get the same error on all reports, both custom and standard.
It is happening on both thick and thin clients with different versions of
Anyone got any ideas please? MS Support unfortunately have yet to come up
with a solution.
is this happening from all your workstations? i e can you print from one but
Microsoft...GP Payroll and HR Report Printing Problem #2
I am using GP9. I am not able to print the report for an employee from cards
or reports even in Fabrikam company.
It simply shows the
Employee master detail Level 3
Total Number of Employee: 0
The user have the all rights to access Payroll & HR
We did the check links the result is same
But if I add new employee it prints fine no problem.
I cant delete all the information of more than 100 employee payroll and HR
data and recreate again.
Any one can help me solve this problem
Thanks in advance
...My web publication is 5 pages but only 1 page prints. Why?
My web publication is 5 pages but only the page I am looking at will print
even when I say print all or print pages 1-5. The same applies to sending as
an email attachment - only page 1 is attached. I am using Publisher 2003.
The publication is a school newsletter. The version previous to this one is
fine. When I created this troublesome newsletter I copied the good version.
Thanks for your help.