Falcon is correct that Snapshot viewer comes with Office installs 2000 and later. You can get an accurate representation of your report by creating a pdf. Unfortunately, Access does not make this as easy as does Word or Excel. As with those applications, you must have Adobe Acrobat installed...
You could try this code. MS says .snp (snapshot) files can be published to the web as easily as HTML. This is good for static reports only:
DoCmd.OutputTo acOutputReport, "SpecSheet", acFormatSNP
The final part of this argument would be , "c:\my documents\specsheet" or...
Melissa, I do a lot of work with reports and subreports, but I don't understand what you mean by "synchronizing" the subreports. Can you be more specific about what you are trying to accomplish? Describe what it is doing now and what it is you want it to do.
Thank you for your advice. I'll give it a shot. If it doesn't work, I may keep the query and push this function back to the DBA to perform in Excel.
Matthew
I have two sets of data on which I need to calculate the correlation coefficient on a report. In Excel, this would be =Correl(B3:B25,D3:D25) However, I can't seem to find a similar built-in Correl function in Access and, not being a math wizard, I can't seem to decipher the various examples...
Lionel, thank you for pointing me in the right direction. I tried this and it still did not work - MS says I must remove controls for pictures in my mainreport, but I have a watermark (embedded picture) that might be preventing the solution from working. Glad to know that this is a "known...
My subreport has 2 columns which displays correctly when I run just the subreport. When I run the main report (which contains the subreport in the detail section), the subreport is ignoring the columns. I can't columnize the main report because of the complicated layout, watermark, etc. Why...
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.